During CONNX import procedures, your user ID requires read-only (SELECT) access to the following system metadata views:
SYSCAT.INDEXES
SYSCAT.PACKAGES
SYSCAT.PROCEDURES
SYSCAT.PROCPARMS
SYSCAT.TABLES
To retrieve column descriptor information for tables and views, your user ID must be authorized to issue a DYNAMIC PREPARE
of the following SQL statement:
SELECT * from schema.table
where
schema.table is the table/view selected for importing into the CDD.
