Hi

How do I find all the tables in a schema, are in check pending state?
I don't want to use Load Query on every table. Is there anyway to find
it through a single command.

Thanks

Straight from IBM SQL reference doc
-----------------------------------
Example 1: The following is an example of a query that gives us
information about the check pending state of tables. SUBSTR is used to
extract the first 2 bytes of the CONST_CHECKED column of
SYSCAT.TABLES. The first byte represents foreign key constraints, and
the second byte represents check constraints.

SELECT TABNAME,
SUBSTR( CONST_CHECKED, 1, 1 ) AS FK_CHECKED,
SUBSTR( CONST_CHECKED, 2, 1 ) AS CC_CHECKED
FROM SYSCAT.TABLES
WHERE STATUS = 'C'

Regards,

-- ashok

venkatprakash (AT) hotmail (DOT) com (Prakash) wrote in message news:<78b3b5e2.0308291020.5d655985 (AT) posting (DOT) google.com>...