Generate SQL From Db2® Catalog panel

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 FM/Db2 should generate, and optionally which names and values should be changed.

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)           Generate SQL From Db2 Catalog

 Generate SQL statements for database :   DSN8D10A                                +

 SQL statement types to be generated from the Db2 catalog:
    CREATE DATABASE . . . . Y        GRANT access ON DATABASE  . . Y
    CREATE TABLESPACE . . . Y        GRANT access ON TABLESPACE  . Y
    CREATE TABLE  . . . . . Y        GRANT access ON TABLE . . . . Y
    CREATE VIEW . . . . . . Y        GRANT access ON VIEW  . . . . Y
    CREATE INDEX  . . . . . Y        ALTER TABLE ADD FOREIGN KEY . Y
    CREATE SYNONYM  . . . . Y        LABEL ON  . . . . . . . . . . Y
    CREATE ALIAS  . . . . . Y        COMMENT ON  . . . . . . . . . Y
    CREATE TRIGGER  . . . . Y

 New names/values for generated SQL (leave blank to use current values):
    Object owner  . . . . .           +
    Alloc TS size as  . . . DEFINED  (DEFINED, USED, or ALLOC)
    Database name . . . . .         
    Storage group for TS  .           +
    Storage group for IX  .           +
    Target Db2 version  . .          (Current Db2 version: 1015)

 Output file and execution mode:
    Data set name . . . . .                                                
    Data set disposition  . OLD      (OLD, SHR, or MOD)
    Execution mode  . . . . BATCH    (BATCH or TSO)
    Commit statements per .          (Db, tS, Tb, All, None)
    Db2 defaults handling            (Keep, or Remove)
 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel
Generate SQL statements for database
Specify Y for each SQL statement type you want FM/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:
K
Keep Db2® default parameters
R
Remove Db2® default parameters

Parent panels

Child panels

None.

Related tasks