Querying CorpDocs' SQL?

system · May 11, 2004, 3:39pm

Hi all–

Ok, since we don’t have Auditor or Data Integrator… I’m trying to do a query against the repository to see in which CorpDocs certain objects/columns are used, but I’m not sure where to look. I’m supposing that it’s OBJ_X_DOCUMENTS, and that the SQL is somehow stored in the BLOB column – anyone been through this before? Any recommendations?

Thanks,
Amy

Amy Miller (BOB member since 2002-06-07)

system · May 11, 2004, 4:17pm

Idea:
Import all Corporate Documents to your local PC, then use VBA to open the documents and look at the SQL code of each dataprovider.

Look at List Objects Used in a set of Documents in BOB’s Download section.

Andreas (BOB member since 2002-06-20)