Migrating from QMF to SAS/ASSIST Software

Generating a QMF Export Procedure

To generate a QMF export procedure, you need READ access to the DB2 table Q.OBJECT_DIRECTORY (or a view of it).(footnote 1) QMF stores information about stored objects in Q.OBJECT_DIRECTORY. Because system or database administrators have access to this file, they usually complete this stage. Users can complete the other steps themselves.

To generate an export procedure, follow these steps.

Follow this selection path:Tasks Data Management Query Query and Reporting SetupFrom the Query and Reporting: Setup window, select Query Migration. The following display shows the Query Migration main menu.

Query Migration Window
Select QMF Export to generate an export procedure. The following display shows the Query Export window.

Query Export Window
Queries are exported from one owner at a time. In the Export queries owned by field, type the user ID of the owner from whom you are exporting queries. Type ? and press ENTER to list the available user IDs.
The Select Queries window opens with a list of all of the queries owned by the specified user ID. You can select all or some of the queries to export. Select END to return to the Query Export window.
In the External file to hold exported queries field, type the name of the external file that you want to hold your QMF export procedure and the exported queries.

The external file does not need to be previously allocated. If the external file does not exist, you are prompted to allocate it. This is the recommended method to allocate the external file because it ensures that the external file has the correct format.

If the external file exists and has the correct format but is not empty, you are prompted to choose whether to delete all of the external file's members or to specify another external file name.
Select Run to write the export procedure to the specified external file. A message appears that indicates the procedure has been successfully written. The message also indicates the procedure name, which is stored in the external file that you just specified.

Query and Reporting actually writes two members to this external file. One member is the export procedure. The other member is used internally by Query and Reporting.
When the two members have been written, exit your SAS session (if necessary) and invoke QMF to export the queries.

FOOTNOTE 1: If you create a DB2 SQL view of the Q.OBJECT_DIRECTORY table to export the QMF queries, make a source entry in the SASUSER.PROFILE catalog named QMFTABLE.SOURCE. On the first line of QMFTABLE.SOURCE, type the name of the new DB2 view that you created (such as SASQR.QMFOBJECT).

Top of Page