CreateTable

For the CreateTable option, enter any additional text that you want to append to SQL create table statements. This text indicates where you want the table to be created. For example, if you enter "in database DSNTEST" in the Values box for the CreateTable entry and the application contains the statement:

create table test (num integer)

the statement is passed to DB2 as

create table test (num integer) in database DSNTEST

See Table Creation Directives for information on the table creation directive syntax supported for the various DB2 platforms.