The syntax diagram should appear as follows:
>>-db2look---d--DBname----+--------------+---+-----+---+-----+--> '--u--Creator--' '--s--' '--g--' >-----+-----+---+-----+---+-----+---+-----+---+-----+-----------> '--a--' '--h--' '--r--' '--c--' '--p--' >-----+------------+---+-------------------+--------------------> '--o--Fname--' '--e--+----------+--' '--t Tname-' >-----+-------------------+---+-----+---+-----+-----------------> '--m--+----------+--' '--l--' '--x--' '--t Tname-' >-----+---------------------------+---+-----+------------------>< '--i--userid---w--password--' '--f--'
|The -td x parameter has been added following the -c parameter. |Its definition is as follows:
|Specifies the statement delimiter for SQL statements generated |by db2look. If this option is not specified, the defaults is the semicolon |';'. It is recommened that this option be used if the -e option is specified. |In this case, the extracted objects may contain triggers or SQL routines.
|The following example will also be added:
|Generate the DDL statements for objects created by all users |in the database DEPARTMENT. The db2look output is sent to file db2look.sql:
|db2look -d department -a -e -td % -o db2look.sql |db2 -td% -f db2look.sql