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, andN
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
- 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.