TargetDBMS

Specifies whether SQL transformation will be applied to specific dialects of DB2 for z/OS, or DB2 for Windows and UNIX.

Syntax

TargetDBMS=[notused | UDBLAN | UDBOS390 | UDBAS400]

Default

notused

Values

notused specifies no SQL transformation to specific dialects.
UDBLAN specifies SQL transformation to specific dialects for DB2 for Windows and UNIX.
UDBOS390 specifies SQL transformation to specific dialects for DB2 for z/OS.
UDBAS400 specifies SQL transformation to specific dialects for DB2 for AS/400.

Comments

Affects the generation of DB2 DDL statements, such as create table and alter table.
Setting the value to UDBLAN or UDBOS390 indicates which create table syntax to use when in sybase translation mode. The database part of the three-part table name is appended with or without the IN DATABASE clause. UDBLAN causes the translation to drop the DATABASE symbol from the IN DATABASE clause.