I generate a DDL with db2look, and create a new db with this DDL file. most of view cannot created due to the view's dependency problem , the error like below, any idea for sloving this problem
any idea for generating db2look in the correct dependency order


DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0204N "FRRBF" is an undefined name. SQLSTATE=42704
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0204N "FRRBF" is an undefined name. SQLSTATE=42704

Try upgrading to the latest fixpack, or rerun the db2look file (or may just portion with create views). If you rerun the db2look file (or just the create views), and objects that already exist will just give an error than can be ignored.

sorry , I don't understand this idea , do you mind elaborate it ?

he means : run db2look - errors for missing views = ok
re-execute the same file = errors for existing objects - missing objects from previous run are now created

The views are all in one section of the db2look, so you could easily copy them to another file and rerun the views only, which should solve the dependency problem. It is possible that you may need to run them multiple times. You can ignore any errors regarding the views already existing.

Note: If you use this method, you don't want to generate the db2look file with "DROP" option to create drop statements for each object being created.