View previous topic :: View next topic |
Author |
Message |
vani Beginner
Joined: 28 May 2003 Posts: 51 Topics: 30
|
Posted: Thu Nov 13, 2003 9:57 am Post subject: QMF |
|
|
In QMF, we can use the LIST command to get a list of QMF objects in the QMF Objects list panel. Is there any way in which this list can be saved or exported to a data set?
Alternatively, can the list of QMF objects belonging to a particular owner be extracted from any QMF internal table? |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
|
Back to top |
|
 |
SureshKumar Intermediate
Joined: 23 Jan 2003 Posts: 211 Topics: 21
|
Posted: Fri Nov 14, 2003 8:52 am Post subject: |
|
|
Vani,
As Kolusu said this is a cumbersome process, it depends on how much of effort you want to put in. Maybe somebody has done this on this board. We can write a QMF batch process to take in the Owner Id and run it in a loop thru a Cobol program. Pass the Owner Id, read the relevant Q tables - Q_OBJECT_DIRECTORY, and EXPORT + QTYPE + QOWNER '.' QNAME-TEXT. Keep exporting all the Queries for a particular owner is finished. I am not a rexx expert, but you can also do it in rexx. Following is the information from the Q.OBJECT_DIRECTORY
NAME TBNAME TBCREATOR COLNO COLTYPE LENGTH
------------------ ------------------ --------- ------ -------- ------
MODIFIED OBJECT_DIRECTORY Q 9 TIMESTMP 10
LAST_USED OBJECT_DIRECTORY Q 10 TIMESTMP 10
OWNER OBJECT_DIRECTORY Q 1 CHAR 8
NAME OBJECT_DIRECTORY Q 2 VARCHAR 18
TYPE OBJECT_DIRECTORY Q 3 CHAR 8
SUBTYPE OBJECT_DIRECTORY Q 4 CHAR 8
OBJECTLEVEL OBJECT_DIRECTORY Q 5 INTEGER 4
RESTRICTED OBJECT_DIRECTORY Q 6 CHAR 1
MODEL OBJECT_DIRECTORY Q 7 CHAR 8
CREATED OBJECT_DIRECTORY Q 8 TIMESTMP 10 |
|
Back to top |
|
 |
|
|