What tables hold Discoverer SQL?
CornellJan 9 2013 — edited Jan 14 2013I have to run queries that are the basis for some Discoverer reports. I don't have access to Discoverer itself, so I'm trying to find them in the database. (we have EUL5* as well, and three owners, for a total of 5 sets of tables).
I have found references to EUL4_OBJS joined to EUL4_SEGMENTS:
SELECT O.OBJ_NAME, S.SEG_CHUNK1 ||S.SEG_CHUNK2 ||S.SEG_CHUNK3 ||S.SEG_CHUNK4
FROM DISCOVERER.EUL4_OBJS O
LEFT OUTER JOIN DISCOVERER.EUL4_SEGMENTS S ON O.OBJ_ID = S.SEG_CUO_ID
WHERE UPPER(O.OBJ_NAME) LIKE '%PROMO%'
OR UPPER(O.OBJ_DEVELOPER_KEY) LIKE '%PROMO%'
OR UPPER(O.OBJ_DESCRIPTION) LIKE '%PROMO%'
ORDER BY O.OBJ_NAME, S.SEG_SEQUENCE
But some of the names of Discoverer reports aren't in EUL4_OBJS (or EUL5_OBJS, with any of our owners)
I can find them in EUL4.DOCUMENTS:
SELECT *
FROM DISCOVERER.EUL4_DOCUMENTS
WHERE UPPER(DOC_NAME) LIKE '%PROMO%';
How can I get from EUL4.DOCUMENTS to the related SQL code?
Thanks for reading
Cornell