Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Ilakshi Rathod : "This tool is just wonderful. I have never seen any tool for DB2. This tool provides very good features which helps in ease us work as well as quick resolution of any errors.".
Jeff Rule: "I have to tell you I am really impressed. I have never had a software company turn around a bug fix like this so fast. I have been doing database work for over 20 years and that has never happened.".

More

Add your opinion

SQL Maestro Group / Products / DB2 / DB2 Maestro / Product tour / Working with data

DB2 Maestro: Product Tour

Features of DB2 Maestro:

Working with data

DB2 Maestro provides you with powerful tools for viewing, editing and printing data from tables and queries.

Click the column caption to sort data by the column values in the ascending or descending mode. You can also group grid data by any of the columns by dragging the column header to the destination area as well as filter records in the grid.

You can export data from a table or a query result to any of available formats such as MS Excel, MS Word, HTML, PDF, etc. and import data from MS Excel, MS Access, DBF, XML, TXT or CSV files.

It is also possible to get an SQL dump of data.

These operations are performed within the appropriate DB2 Maestro wizards.

There is a simple way to edit the grid data. The appropriate item of the grid's popup menu allows you to open the Data Input Form dialog and edit data within the dialog.

The fields of the dialog contain the values pertaining to the current grid row. Use the Insert button to add values as a new row to the grid and the Post button to update the current row.

Back Next