Is this the Db2 for i dialect?

The selected dialect is db2. A separate Db2 for i dialect is not offered by this interface; do not assume every platform-specific extension is supported.

Are parameter markers replaced?

No. The ? marker stays a marker. The tool does not bind values, execute the query or validate it against a database schema.

Can it format SQL PL routines?

Stored procedure and procedural routine formatting is outside this page’s supported scope. Use an appropriate routine formatter for those programs.

IBM Db2 SQL Formatter

Start with the IBM Db2 dialect and an editable SELECT query using a ? parameter marker and FETCH FIRST 10 ROWS ONLY. The formatter changes statement layout, keyword casing and indentation, while quoted text and parameters retain their contents. This page supplies text to copy into your Db2 environment; it does not connect to Db2.

SQL dialect

SQL input110 characters

Formatted

Preparing current SQL output…

Output

Keywords

Indent

Formatting arranges SQL statements for the selected dialect. It does not execute queries, validate database objects or optimize performance. Stored procedures and client batch directives are outside this formatter’s scope. SQL stays in this browser. Your input and settings are remembered in local browser storage; Start over clears them.

Common questions

Is this the Db2 for i dialect?: The selected dialect is db2. A separate Db2 for i dialect is not offered by this interface; do not assume every platform-specific extension is supported.
Are parameter markers replaced?: No. The ? marker stays a marker. The tool does not bind values, execute the query or validate it against a database schema.
Can it format SQL PL routines?: Stored procedure and procedural routine formatting is outside this page’s supported scope. Use an appropriate routine formatter for those programs.

Formats SQL statements for the selected dialect; it does not execute SQL, check database objects, optimize queries or validate a complete SQL grammar. Stored procedures and client batch directives are outside its scope. Minify preserves comments and quoted values and can retain meaningful newlines.