I need to be able to create a batch job that generates all DDL for a specified database in DB2 os/390. Does anyone have any experience with this? I think I can write straight SQL to query the catalog and format the DDL (a little hairy) but if anyone has already written the SQL and would like to share it, it would be appreciated.
Omit the parameters that you don't need eg.: table_name.
See the full help with command:
Hope this helps,
Well, that's kinda the problem. You can execute DB2LOOK against a mainframe database but only throught a remote connection (from windows or unix). I am in need of a batch job that runs on the mainframe for reasons to complicated to get into here. Anyway, thanks for the reply.