4 Replies Latest reply on Jan 14, 2013 2:15 PM by Rod West

    What tables hold Discoverer SQL?

    Cornell
      I 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