db2look

[andy]

I am compleatly confused - I can issue this command against one
db - and I get the ddl creation script for all the tables,
great - exactly what I wanted.

I can issue it against another db - and all I get is the header -
but no useful info.

I can not find any reason for the difference - any clues anyone ?

Andy

OP from prog - to screen
SQLCA
Size = 136
SQLCODE = -1
Tokens = F:\SQLLIB\bnd\DB2LOOK.BND
RDS fn = sqlajbnd
RC = 0x0000 = 0
Reason = 0x0000 = 0
Reason2 = 0x0000 = 0
Warning flags =

OP in file

-- This CLP file was created using DB2LOOK Version 6.0
-- Timestamp: Sun Mar 05 16:18:37 2000
-- Database Name: XXXXX
-- Database Manager Version: DB2/NT Version 5.2.0
-- Database Codepage: 1252

* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!

[Doug Doole]

You had an error binding the db2look package. I suggest that you bind
the db2look package manually and resolve the errors that are reported.
You can bind the package by:

db2 connect to <db>
db2 bind F:\SQLLIB\bnd\DB2LOOK.BND

Hope this helps.
--
___________________________________________________________________________
Doug Doole
DB2 Universal Database Development
IBM Toronto Labs

[andy]

TVM for that pointer
no progress - but at least I now have a whole raft of error
messages to look up ;-))

These look a little like "DB is very unwell" messages.
Andy
F:\SQLLIB\bnd>db2 bind F:\SQLLIB\bnd\DB2LOOK.BND

LINE MESSAGES FOR DB2LOOK.BND
------ ---------------------------------------------------------
-----------
SQL0061W The binder is in progress.
1306 SQL0206N "SOURCE_TABNAME" is not a column in an inserted
table, updated table, or any table identified
in a FROM
clause or is not a valid transition variable
for the subject
table of a trigger. SQLSTATE=42703
1335 SQL0204N "SYSIBM.SYSINDEXCOLUSE" is an undefined name.
SQLSTATE=42704
4878 SQL0347W The recursive common table
expression "DB2ADMIN.IV"
may contain an infinite loop. SQLSTATE=01605
4937 SQL0347W The recursive common table
expression "DB2ADMIN.IV"
may contain an infinite loop. SQLSTATE=01605
5593 SQL0206N "REVERSE_SCANS" is not a column in an inserted
table, updated table, or any table identified
in a FROM
clause or is not a valid transition variable
for the subject
table of a trigger. SQLSTATE=42703
6722 SQL0347W The recursive common table expression
"DB2ADMIN.RTABLES" may contain an infinite
loop.
SQLSTATE=01605
6854 SQL0347W The recursive common table
expression "DB2ADMIN.RT"
may contain an infinite loop. SQLSTATE=01605
6922 SQL0206N "VOLATILE" is not a column in an inserted
table,
updated table, or any table identified in a
FROM clause or is

not a valid transition variable for the
subject table of a
trigger. SQLSTATE=42703
7034 SQL0206N "SOURCE_TYPESCHEMA" is not a column in an
inserted
table, updated table, or any table identified
in a FROM
clause or is not a valid transition variable
for the subject
table of a trigger. SQLSTATE=42703
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous
errors.
SQL0091N Binding was ended with "7" errors and "4"
warnings.