output of this command

[vinny321]

Hello,

i am new to DB2. can u tell me what does this command do ?

db2look -e -d CDMTEST -z cdm_hist -i cdmbatch -w tuesday0 -o cdm_hist.ddl

thanks,
vinni

 

[ifxtechie]

This command uses userid as cdmbatch and password as tuesday0 for the database CDMTEST and will extract the DDL of schema cdm_hist and the output is placed in cdm_hist.ddl file.
You can what 'db2look' will do by issuing db2look -?.
Hope this helps.
Good luck