There is a freeware tool called DB2LOOK for z/OS. You can obtain it from www.idug.org
IBM's File Manager/DB2 has DDL generation capability, but it's not free. On Wed, Aug 5, 2009 at 11:11 AM, CUNY Yann<[email protected]> wrote: > Ok ... it's possible with a "HDDL batch" command. > In the generated JCL, the database name is specified. > > Any IBM idea ? > > Cordialement, > > Yann Cuny > Groupe GENERALI > Industrialisation et Gestion des Environnements > * 01 58 34 12 64 > *[email protected] > -----Message d'origine----- > De : IBM Mainframe Discussion List [mailto:[email protected]] De la part > de CUNY Yann > Envoyé : mercredi 5 août 2009 15:52 > À : [email protected] > Objet : DB2 : How to extract DDL > > Is there a possibility to extract DDL from a DB2 Database ? > > We got DB2 V8 ... and BMC Software. > > I know that it is possible with BMC Change Manager or Catalog Manager. > > But I have to use JCL, and it seems impossible to specify the database name > in the BMC JCL. > > > > Any Idea ? > > > > Regards. > > > > Cordialement, > > > > Yann Cuny > > Groupe GENERALI > > Industrialisation et Gestion des Environnements > > * 01 58 34 12 64 > > * [email protected] > > P Pensez « environnement », n'imprimez ce mail que si cela est nécessaire... > > > > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
