DB2 graphic  QMF Version 8

Step 8--Installing the national language sample queries and procedures

After the QMF NLF is installed and verified, use it to install the translated versions of the sample queries and procedures. Do this in two steps:

Step 8A--Deleting the existing sample queries and procedures

Skip this step if you do not have a previous release of the QMF NLF with the same language identifier installed at your location.

To delete the existing sample queries and procedures, import and run the QMF procedure DSQ1nSQD (from the QMF Version 8.1 sample library, QMF810.SDSQSAPn), using translated QMF commands where appropriate. This procedure (DSQ1nSQD) imports a query from the QMF English sample library (prefix.SDSQSAPE), where prefix is the prefix for the QMF data sets.

The procedures were written assuming that this prefix is QMF810. If this is not your prefix, change QMF810 to match your prefix wherever it appears in the DSQ1nSQD procedure.

IMPORT PROC FROM 'QMF810.SDSQSAPn(DSQ1nSQD)'
RUN PROC

You may see the Database Status panel when you perform this step. You are not required to perform any action because of it.

DB2 authorization

If you are the user Q, you already have the necessary authority.

If you are not the user Q, run the following query to give you the necessary authority:

GRANT UPDATE ON Q.OBJECT_DIRECTORY TO authid
GRANT UPDATE ON Q.OBJECT_REMARKS TO authid
GRANT UPDATE ON Q.OBJECT_DATA TO authid

where authid is your primary authorization ID.

Restarting this step

If the job fails, proceed to the next step.

Step 8B--Installing the national language sample queries and procedures

To install the national language sample queries and procedures, import and run the QMF procedure in QMF810.SDSQSAPn (DSQ1nSQI), using translated QMF commands where appropriate. This procedure (DSQ1nSQI) imports a query from the QMF English sample library (prefix.SDSQSAPE), where prefix is the prefix for the QMF data sets.

The procedures were written assuming that this prefix is QMF810. If this is not your prefix, change QMF810 to match your prefix wherever it appears in the DSQ1nSQI procedure.

IMPORT PROC FROM 'QMF810.SDSQSAPn(DSQ1nSQI)'
RUN PROC

If you are not the user Q, see Install the QMF application queries and procedures (TSO) for the necessary GRANT queries you must run.

This step also installs the batch mode IVP and sample application procedures.

DB2 authorization

If you are the user Q, you already have the necessary authority.

If you are not the user Q, run the following query to give you the necessary authority:

GRANT UPDATE ON Q.OBJECT_DIRECTORY TO authid
GRANT UPDATE ON Q.OBJECT_REMARKS TO authid
GRANT UPDATE ON Q.OBJECT_DATA TO authid

where authid is your primary authorization ID.

Restarting this step

If a failure occurs during this job, correct the error and run procedure DSQ1nSQD which deletes any previously created sample queries. Then rerun procedure DSQ1nSQI.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004