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 / Documentation

DB2 Maestro online Help

Prev Return to chapter overview Next

Work with Data in DB2 Maestro

Query results and table data are displayed on the Data or Result tabs of Table Editor, SQL Editor or Visual Query Builder.

 

Data are displayed as a grid (or as info cards) which provide a lot of useful features such as editing, grouping, sorting, filtering, etc. See Data View for details.

 

Navigation bars of these tabs as well as popup menus of their working areas places at your disposal the following functions for managing data:

 

Export Data allows you to export data to various formats, including MS Excel, MS Access, RTF, HTML, PDF and more.

 

Get SQL Dump exports data to the SQL script as a number of INSERT statements.

 

Import Data provides you with possibility to import data from MS Excel, MS Access, DBF, XML, TXT, and CSV.

 

Edit BLOB allows you to view and edit the content of BLOB and TEXT fields.


Prev Return to chapter overview Next