Step 14--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 14A--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 7.2 sample library, QMF720.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 QMF720. If this is not your prefix, change QMF720 to match your prefix wherever it appears in the DSQ1nSQD procedure.

IMPORT PROC FROM 'QMF720.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, you can proceed to the next step.

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

To install the National Language sample queries and procedures, import and run the QMF procedure in QMF720.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 QMF720. If this is not your prefix, change QMF720 to match your prefix wherever it appears in the DSQ1nSQI procedure.

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

If you are not the user Q, see Step 34--Install the QMF application queries and application objects (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.

[ Previous Page | Next Page | Contents | Index ]