DB2 Database Query Tool Features

The DB2 database GUI query tool features provided by RazorSQL include a custom DB2 database browser tailored to DB2, a DB2 SQL editor with DB2 and SQL PL specific features and syntax highlighting, custom DB2 GUI and visual tools, and DB2 specific database administration tools. Listed below are more details on these features.

DB2 GUI Tools DB2 GUI Tools

DB2 Database Browser DB2 Database Browser

  • Displays information in a tree format for schemas, tables, views, procedures, functions, triggers, indexes, constraints, and sequences
  • Displays DB2 table information such as column name, column type, column length, column nullability, and primary and foreign key information
  • Easily view table contents or database object information via the View Contents and Show Info context menu options

DB2 SQL Editor  DB2 SQL Editor

Edit SQL scripts. Run SQL queries. Auto column and auto table lookup. Supports over 20 programming languages including SQL, PHP, HTML, XML, Java, and more.

DB2 Import Tool DB2 Import Tool

Import data from various formats such as delimited files, Excel spreadsheets, and fixed width files.

DB2 Export Tool DB2 Export Tool

Export data in various formats such as delimited files, Excel spreadsheets, text, HTML, XML, and SQL insert statements.

DB2 Table Editor DB2 Table Editor

Edit tables in a spreadsheet format with support for finding and replacing data, automatic generation of SQL, and support for editing multi-line data.

DB2 SQL Query Builder DB2 SQL Query Builder

Easily build select, insert, delete, and update SQL queries. Build multi-table joins.

DB2 Database Convertion Tools DB2 Database Conversion Tools

Convert database tables from DB2 to other database types such as Oracle, MySQL, MS SQL Server, PostgreSQL, SQLite, Access, and HSQLDB and from other database types to DB2.

Below is a screen shot of the RazorSQL DB2 GUI Tool

DB2 GUI Tool