| 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 |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12376
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 |
|
|
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 |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12376
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 |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
