Using the command line

The command line interface allows QMF for Workstation users to connect to a repository and run objects by submitting commands using their operating command line rather than the application interface.

1. Create a procedure.
   For example:

   run query ObjectTracking (form=ObjectTrackingForm
        export form to c:\dqtrack.frm

   This example executes a query called ObjectTracking using the form called ObjectTrackingForm for form generation. The procedure exports the form to a file called dqtrack.frm in the c:\ directory.

2. Save the procedure in a secured repository with the name proc12, save the procedure in a QMF catalog with the name DB2INST1.Procedure1, and save as a local file with the name of Procedure1.prc.
3. There are several parameters that you can specify when you create your run command.
   The following examples use some of the parameters and illustrate how to run a procedure object that has been saved in a repository, a QMF catalog and a local file:

   • Type the following command in the operating system command line to connect to a secured repository when the login and password for the repository storage are saved in the repository connection named Connection1; the repository user ID repuserid; and the password reppassword and run a procedure named proc12 that resides in the repository against the data source DB2AIX using the user ID db2inst1 and password db2inst1 to access the data source:

     "C:\Program Files\IBM\QMF Analytics for Multiplatforms\
     qmfdev.exe" 
     /RConnection:Connection1 /RUser:repuserid /RPassword:reppassword 
     /RObject:rsbi:/.workspaces/Default/proc12 /IServer:DB2AIX /Run 
     /IUserID:db2inst1 /IPassword:db2inst1

   • Type the following command in the operating system command line to connect to a secured repository when the login and password for the repository storage are not saved in the repository connection named Connection1 and the repository storage user ID repuserid and password reppassword and the repository storage user ID rdbuserID and password rdbpassword and run a procedure named DB2INST1.Procedure1 that has been saved in a QMF catalog against the data source DB2AIX using the user ID db2inst1 and password db2inst1 to access the data source:

     "C:\Program Files\IBM\QMF Analytics for Multiplatforms\
     qmfdev.exe" /RConnection:Connection1 /RUser:repuserid /RPassword:reppassword 
     /RDBUser:rdbuserID /RDBPassword:rdbpassword/IObject:DB2INST1.Procedure1 
     /IServer:DB2AIX /Run /IUserID:db2inst1/IPassword:db2inst1

   • Type the following command in the operating system command line to connect to a repository with database-based security when the login and password for the repository storage are not saved in the repository connection named Connection1 and the repository storage user ID rdbuserID and password rdbpassword and run a procedure that contains a global variable named DB2INST1.Procedure1 that has been saved in a QMF catalog against the data source DB2AIX using the user ID db2inst1 and password db2inst1 to access the data source:

     "C:\Program Files\IBM\QMF Analytics for Multiplatforms\qmfdev
     .exe" /RConnection:Connection1 /RDBUser:rdbuserID 
     /RDBPassword:rdbpassword 
     /IObject:DB2INST1.Procedure1 /IServer:DB2AIX /Run /IUserID:db2inst1 
     /IPassword:db2inst1 

   • Type the following command in the operating system command line to connect to a personal repository when the login and password for the repository storage are not required using the repository connection named Connection1 and run a procedure named Procedure1.prc that has been saved locally against the data source DB2AIX using the user ID db2inst1 and password db2inst1 to access the data source:

     "C:\Program Files\IBM\QMF Analytics for Multiplatforms\
     qmfdev.exe" 
     /RConnection:Connection1 c:\Procedure1.prc /IServer:DB2AIX 
     /Run /IUserID:db2inst1 /IPassword:db2inst1