We are executing code similar to what is listed below. However, we are not able to identify those queries that Drop or create a DB2 table. Is there something we need to add to our set up of RA? Or any other ideas on how we can identify those queries that Drop or create a DB2 table?


SQL DB2 SET SERVER WRK1
END
-*
SQL
DROP TABLE EDASVR.USER_CAR;
END
-*
TABLE FILE PRODDETL
PRINT ACCT_TYPE AS ACCT_TYPE
OPEN_ID AS OPEN_ID
OPEN_TIME AS OPEN TIME
BY ACCT_NUM AS ACCT_NUM
BY OPEN_DATE AS OPEN_DATE
ON TABLE HOLD AS USERACCT FORMAT DB2
END
-RUN
-*

Hi wdusbank,

This one seems to be an issue to be fixed by programming, so it should be addressed by a case with Information Builders' Customer Support Services. You may either call at 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry