You use the Generate SQL From Db2® Catalog panel to specify how the generation
of SQL from the Db2® catalog
should work. You can specify which SQL statement types ZDT/Db2 should
generate, and optionally which names and values should be changed.
Panel and field definitions
Generate SQL statements for database
Specify Y for each SQL statement type you want
ZDT/Db2 to generate, and N for each SQL statement
type you do not want generated.
Object owner
New owner (authorization ID) of the objects.
Alloc TS size as
Specifies how to generate the primary quantity:
DEFINED
Use the size defined in the catalog
USED
Use the size that actually is used
ALLOCATED
Use the allocated size
USED and ALLOCATED require
that the STOSPACE utility has been run for the storage groups for
the objects being generated.
Database name
New database name for the objects.
Storage group for TS
New storage group for the table spaces.
Storage group for IX
New storage group for the indexes.
Target Db2® version
Db2® level of generated SQL
statements.
Data set name
An existing valid SPUFI input data set name, or as SYSOUT=x. SYSOUT=* is
the default if the field is blank.
Data set disposition
The disposition of the output data set.
Execution mode
Specify:
BATCH
Generates a batch job
TSO
Runs the generation online
Commit statements per
When to generate COMMIT statements:
D
Ffor each database
S
For each table space
T
Ffor each table
A
For all objects
N
Never
Db2® defaults handling
Specifies how Db2® default
parameters should be handled:
Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.