View previous topic :: View next topic |
Author |
Message |
programmer1 Beginner
Joined: 18 Feb 2004 Posts: 138 Topics: 14
|
Posted: Fri Sep 16, 2005 6:39 am Post subject: QMF Temporary Storage |
|
|
Hi,
I am using QMF to list all the stored QUERIES & PROCS.
Can someone please help me with the temporary dataset name, where QMF would store the result set.
When I list all the queries, it throws somewhere around 6000 queries, I need to export all these queries into a dataset for further analysis.
(One way is to do an export on individual queries but that would be very time consuming)
Any help would be highly appreciated _________________ Regards,
Programmer |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
kolusu Site Admin
![Site Admin Site Admin](images/ranks/adminpic.jpg)
Joined: 26 Nov 2002 Posts: 12369 Topics: 75 Location: San Jose
|
Posted: Fri Sep 16, 2005 7:35 am Post subject: |
|
|
Programmer1,
The QMF objects are all stored in the tables namely Q.OBJECT_DIRECTORY, Q.OBJECT_DATA ...
See if you can run this query
Code: |
SELECT *
FROM Q.OBJECT_DIRECTORY WHERE OWNER = 'your T-id'
or
SELECT *
FROM Q.OBJECT_DATA WHERE OWNER = 'your T-id'
|
Hope this helps...
Cheers
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
programmer1 Beginner
Joined: 18 Feb 2004 Posts: 138 Topics: 14
|
Posted: Fri Sep 16, 2005 9:13 am Post subject: |
|
|
Thanks Kolusu,
Unfortunately, none of our user id's have access to browse these tables.
I tried running a proc query through batch "LIST QUERIES (OWNER=ALL" but then it failed suggesting that this can only be run with an interactive session.
Can there be any other way that I can retrieve the result set of all the QUERIES in QMF into a dataset instead of having it displayed on the screen ? _________________ Regards,
Programmer |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
kolusu Site Admin
![Site Admin Site Admin](images/ranks/adminpic.jpg)
Joined: 26 Nov 2002 Posts: 12369 Topics: 75 Location: San Jose
|
Posted: Fri Sep 16, 2005 10:04 am Post subject: |
|
|
Prograrammer1,
Well there is another way around.
since you are getting all the queries from all the users, you need to make sure that the queries are not restricted.
Code: |
SELECT *
FROM Q.QUERY_LIST
WHERE RESTRICTED = 'Y'
|
Now you will get names of all queries now.
Now you can customize this and generate the EXPORT commands and save it as a proc and run that proc which would export all the queries
i.e
Code: |
SELECT CHAR('EXPORT QUERY ')
,OWNER
,CHAR('.')
,CHAR(NAME)
,CHAR( '''')
,CHAR('YOUR PDS. QMF.QUERIES(')
,CHAR(NAME,8)
,CHAR(')')
,CHAR('''')
FROM Q.QUERY_LIST
WHERE RESTRICTED = 'Y'
;
|
Hope this helps...
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
|
|