Choose your database:

Partners

Testimonials

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.".

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.".

Add your opinion

Customers

Become a customer

SQL Maestro Group / Products / DB2 / DB2 Maestro / Documentation

Download

Buy

DB2 Maestro online Help

Return to chapter overview

Among other features DB2 Maestro provides you with SQL Generator, a tool to create simple SQL statements. Just choose a database object, select statement type (Definition, Select, Insert, Update, or Delete) and the destination device (Clipboard, File, SQL Editor, SQL Script Editor).

The SQL Generator window can be invoked from the Explorer tree.

Return to chapter overview

SQL Maestro Group wishes you a happy Thanksgiving!

We are pleased to grant you a 20% discount for all our products and bundles till the end of November!

Company news

May 18, 2023

DB2 Maestro 23.5 released

New version comes with colored tabs, new encryption algorithms in data grids, updated BLOB Editor, database profile usage statistics and a lot of other useful things.

Nov 9, 2013

DB2 Maestro 13.11 released

A new reporting tool, advanced SQL Dump wizard, updated SQL Editor, enhanced data grids, redesigned Start Page, improved Database Explorer, and a lot of other useful things.

May 16, 2011

DB2 Maestro 11.5 released

Completely redesigned Data Export and Data Import wizards, improved database profile management, updated OLAP viewer and a lot of other improvements.

More news

Resources

How to add inline buttons to a webpage created with PHP Generator?

The article shows how to implement an AJAX-based one-click editor for a logical column.

Investigating NBA demo. Part 1: Customizing common templates

This article begins a series of step-by-step tutorials on how we made the NBA demo. It explains how to add new items to the menu, implement run-time theme selection, and tweak the login form.

How to add a chart to a webpage created with PHP Generator?

The article illustrates how to use various chart libraries with PHP Generator.

More resources

Feature of the day

Data Grouping

You can group your data in the grid by any table column in DB2 Maestro.

Code Folding

All editors of DB2 Maestro provide a customizable ability to divide text into logical parts (regions). Each part can be collapsed and extended.

DB2 Maestro online Help

SQL Generator

Thanksgiving Sale