Skip to Content
avatar image
Former Member

Tables and fields used in a query

Hi there,

I'm trying to find a way to get an output that is able to list all the tables and fields that are used in all the local queries accessed by SQ01. I've found that table AQLQCAT can provide me the user group, query name and infoset but I've not been able to find anything that would give me the details of the queries in mass.

Can someone point me in the direction of how I may achieve this?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 28 at 03:28 PM

    Hello - please try using table AQLDB

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Tammy,

      Thank you very much for that, it's an interesting read and has given me some ideas as to where I need to go.

      Thanks.

  • Mar 29 at 12:58 PM

    You have to perform some where-used search on this table to find how to IMPORT correct data from this table,

    example:

    " LAQIEXQF01
    IMPORT headqu clogqu
           dbop dbsn dbfr dblf dblc dbld dbse dbsq
           dbgr dbli dbff dbfm
           dbvh dbvs dbrh dbrl
           dbpt dbct
           maxqu_tindx
           FROM DATABASE aqgdb(aq) ID l_qukey
           IGNORING CONVERSION ERRORS.
    

    Look at the provided include to find defintions of those field/itab.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Raymond,

      Thank you very much for your input. I've used the where-used function to increase my understanding and move in the right direction.

      Thanks.