To Create an utility program for query.

[Former Member]

Hello all,

I have a requirement where I need to develop an utility program which should create a downloadable report with more or less the following content.

System

Client

Query name

Query description

Creation timestamp

Creator

Infoset

Tables involved

If possible, we would like to know how many times they were run and when was the last time it ran.

Can you please let me know where are the queries saved? And from where can we get the details for these above mentioned fileds? ( Except system and Client).

Do feel free to add any other information you may consider relevant.

Thanks in Advance,

Rachana.

[Former Member]

Hi ,

You can use AQGQCAT table to retrieve query details.

Further tables on query are AQG*

Hope this Helps

Nag