View previous topic :: View next topic
|
Author |
Message |
dirceu.alves
New User
Joined: 03 Aug 2005 Posts: 17
|
|
|
|
I really need to know if there's a way to get a DB2 table structure and indexes from a job?
I tried to use the DESCRIBE command but it seems it isn't working...
Ideas?
This is the JCL I tried to use...
Code: |
//STEP001 EXEC PGM=IKJEFT01,DYNAMNBR=20,REGION=4M
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB1D)
RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) -
LIB('SYS1.DSNDB1D.RUNLIB.LOAD') PARMS('/ALIGN(MID)')
END
/*
//SYSIN DD *
DESCRIBE XXXX.XXXXXXXXXXXXXXXX;
/*
//*
|
Tks |
|
Back to top |
|
|
wanderer
Active User
Joined: 05 Feb 2007 Posts: 199 Location: Sri Lanka
|
|
|
|
I don't think describe commands work in DB2 mainframe.
If you are looking to generate DDLs of objects, there is no simple way unless you use a third party tool like BMC or CA or even IBM DB2 tools.
However you can get all information about the objects from catalog tables and try and reconstruct DDLs yourself if you like. |
|
Back to top |
|
|
|