Generate the DDL statements for objects that have schema name ianhe, created by user walid, in database DEPARTMENT. The db2look output is sent to file db2look.sql:
db2look -d department -u walid -z ianhe -e -o db2look.sql