Step 5--Install QMF NLF sample objects and application objects: DSQ2nSQD and DSQ2nSQI

After the QMF NLF is installed and verified, you can use the NLF to import the sample queries and procedures for the NLF.

If you have any previous version of this QMF NLF installed, you must delete the previous sample queries and procedures before installing QMF NLF V7.2 queries and procedures.

Perform the following steps to install the sample queries and procedures:

1. Start QMF if not already logged on.
2. Issue the command (if not done earlier):

   CONNECT Q (PASSWORD=xxx

   where "xxx" is the QMF CONNECT password of "Q".

   If you are running these jobs to any database other than DB2 for VM, the connect ID at that server must have DBA or SYSADM authority.

3. Delete previous sample queries and procedures. (Run this step only if you have a previous version of this QMF NLF installed.)

   Import and run the procedure DSQ2nSQD as follows:

   IMPORT PROC FROM DSQ2nSQD PROC *
   RUN PROC

4. Install NLF sample queries and procedures, by importing and running procedure DSQ2nSQI with the following commands:

   IMPORT PROC FROM DSQ2nSQI PROC *
   RUN PROC

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

Restarting the procedure

If a failure occurs during this procedure, you can correct the error and run procedure DSQ2nSQD, which deletes any previously created sample queries. Then import and rerun procedure DSQ2nSQI to install sample queries and procedures.