Marcus,
I always use this options to get all the DDL's plus the RI without any problem,
Try it!
Regards
Miguel Celi
db2look -d DBNAME -a -e -l -x -c -o DBNAME.ddl
Subj: [DB2EUG] db2look to OS/390: no RI
Date: 5/27/2003 6:56:23 AM Eastern Daylight Time
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Sent from the Internet
Hi.
I'm trying to create a database on DB2 UDB for NT 7.2 fixpak 9, basing it on a database on DB2 for OS/390 6.1, however, the DDL that db2look creates does not create any RI between the tables. Is this a feature or am I doing something wrong? My command input is this:
db2look -d DB2TPRIM -u FIGDBA -z FIGDBA -e -x -l
There's loads of RI which I don't want to type in manually. I have to automate the creation of tablespaces and indexspaces as it is!
Cheers.
i
---------------------------------------------------------------------------------------------------------------
This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.
evolvebank.com is a division of Lloyds TSB Bank plc.
Lloyds TSB Bank plc, 25 Gresham Street, London, EC2V 7HN. Registered in
England, number 2065. Telephone No: 020 7626 1500
Lloyds TSB Scotland plc, Henry Duncan House, 120 George Street,
Edinburgh EH2 4LH. Registered in Scotland, number 95237. Telephone
No: 0131 225 4555
Lloyds TSB Bank plc and Lloyds TSB Scotland plc are regulated by the
Financial Services Authority and represent only the Scottish Widows
and Lloyds TSB Marketing Group for life assurance, pensions and
investment business.
Signatories to the Banking Codes.
---------------------------------------------------------------------------------------------------------------
Miguel Celi
Senior IBM DB2 DBA - Expert Solutions Certified
SYSDBA-USA, Inc.
8351 Johnson Street
Hollywood, Florida 33024
www.sysdbausa.com
