db2look

db2look是系统命令，而非db2命令，用于导出表结构
导表结构：db2look -d CONFORM -z XFORM -t P2C_SCORE_CALC -e -x -o P2C_SCORE_CALC.ddl
导view结构：db2look -d CONFORM -z XFORM -v STG_P2C_SCORE_CALC -e -x -o  STG_P2C_SCORE_CALC2.ddl
不要联邦code的表结构：db2look -d CONFORM -z XFORM -t P2C_SCORE_CALC -e -x -o -nofed P2C_SCORE_CALC.ddl
只查询不导出到文件： db2look -d sb1dm -z EDGEDM -t PEOPLE -e -x
-d : database
-z : schema
-t : table
-v : view
-x : Generates authorization DDL statements such as GRANT statements.
-o : Redirects the output to the given file name
-nofed : Do not generate Federated(联邦) DDL