TargetDBMS

Specifies whether SQL transformation are 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 transforms SQL to specific dialects.

  • UDBLAN transforms SQL to specific dialects for DB2 for Windows and UNIX.

  • UDBOS390 transforms SQL to specific dialects for DB2 for z/OS.

  • UDBAS400 transforms SQL 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.

Parent topic: Target Interaction Properties