DB2 Server for VSE & VM: Quick Reference

Preprocessing the Program

Program Preparation Command - VM Users

>>-SQLPREP----+-ASM-----+--PrepParm----------------------------->
              +-C-------+
              +-COBol---+
              +-FORTran-+
              '-PLI-----'
 
>----(--PREPname=--+----------------+--package_id--------------->
                   '-collection_id.-'
 
>-----+----------------------------------+---------------------->
      +-,PrepFile=--(--| fileparms |--)--+
      '-| prepparms |--------------------'
 
>-----+----------------------------------------+--)------------->
      '-,USERid=--authorization_name/password--'
 
>-----+----------------------------------+---------------------->
      '-sysIN--(--+-| fileparms |-+---)--'
                  '-Reader--------'
 
>-----+-------------------------------------+------------------->
      '-sysPRint--(--+-| fileparms |-+---)--'
                     +-Printer-------+
                     '-Terminal------'
 
>-----+-------------------------------------+------------------->
      '-sysPUnch--(--+-| fileparms |-+---)--'
                     '-Punch---------'
 
                                     (2)  (1)
>-----+-| multiple-user-mode-parms |-----------+---------------><
      |                            (1)         |
      '-| single-user-mode-parms |-------------'

Notes:

  1. Valid for DB2 Server for VM only.

  2. Optional for multiple-user-mode. 

 
fileparms
 
|--filename----+-------------------------+----------------------|
               '-filetype--+----------+--'
                           '-filemode-'
 


 
prepparms
 
   .-,APOST------.   .-,NOBIND----.   .-,NOBLocK-----.
|--+-------------+---+------------+---+--------------+---------->
   |        (1)  |   |       (4)  |   +-,BLocK-------+
   '-,Quote------'   '-,BIND------'   |         (2)  |
                                      '-,SBLocK------'
 
>-----+---------------------------+----------------------------->
      '-,CCSIDGraphic--(integer)--'
 
>-----+-------------------------+---+------------------------+-->
      '-,CCSIDMixed--(integer)--'   '-,CCSIDSbcs--(integer)--'
 
                                         .-,NOCHECK--.
>-----+------------------------------+---+-----------+---------->
      '-,CHARSUB--(--+-Sbcs--+---)---'   +-,CHECK----+
                     +-Mixed-+           '-,ERROR----'
                     '-Bit---'
 
>----+------------+---+-------------+--------------------------->
     |       (1)  |   |        (1)  |
     '-,COB2------'   '-,COBRC------'
 
      .-,CTOKEN--(NO)------------.
>-----+--------------------------+------------------------------>
      '-,CTOKEN--(--+-NO--+---)--'
                    '-YES-'
 
                                     .-,NOEXIST--.
>-----+--------------------------+---+-----------+-------------->
      '-,DATE--(--+-EUR---+---)--'   '-,EXIST----'
                  +-ISO---+
                  +-JIS---+
                  +-LOCAL-+
                  '-USA---'
 
      .-,EXPLAIN--(NO)------------.
>-----+---------------------------+--+-------------+------------>
      '-,EXPLAIN--(--+-NO--+---)--'  |        (3)  |
                     '-YES-'         '-,NOFOR------'
 
>----+--------------+-------------------------------------------|
     |         (5)  |
     '-,DYNALC------'

Notes:

  1. COBOL only.

  2. Not meaningful for DB2 Server for VSE.

  3. Implied if STDSQL(89) is specified.

  4. Valid for DB2 Server for VSE only.

  5. COBOL, PL/I, C and ASSEMBLER only. 

 
prepparms (continued)
 
   .-,NOGRaphic----.   .-,ISOLation--(RR)----------------.
|--+---------------+---+---------------------------------+------>
   |          (1)  |   '-,ISOLation--(--+-CS------+---)--'
   '-,GRaphic------'                    +-RR------+
                                        |    (2)  |
                                        +-RS------+
                                        +-UR------+
                                        '-USER----'
 
      .-,KEEP---.
>-----+---------+---+-----------------------+------------------->
      '-,REVOKE-'   '-,LABEL--(label_text)--'
 
      .-,LineCount--(60)------.
>-----+-----------------------+--------------------------------->
      '-,LineCount--(integer)-'
 
>-----+------------------------------------+-------------------->
      |                             (2)    |
      '-,OWner--(authorization_name-----)--'
 
      .-,PACKAGE--------.   .-,PERiod-----.   .-,PRint---.
>-----+-----------------+---+-------------+---+----------+------>
      |            (7)  |   |        (2)  |   '-,NOPRint-'
      '-,NOPACKAGE------'   '-,COMma------'
 
      .-,PUnch---.
>-----+----------+---+-----------------------------------+------>
      '-,NOPUnch-'   |                            (2)    |
                     '-,QUALifier--(collection_id-----)--'
 
      .-,RELease--(COMMIT)--------------------.   .-,REPLACE--.
>-----+---------------------------------------+---+-----------+->
      '-,RELease--(--+-COMMIT----------+---)--'   '-,NEW------'
                     |            (2)  |
                     '-DEALLOCATE------'
 
      .-,SEQuence--------.   .-,SQLApost-----------.
>-----+------------------+---+---------------------+------------>
      |             (3)  |   |           (2)  (4)  |
      '-,NOSEQuence------'   '-,SQLQuote-----------'
 
>----+---------------+------------------------------------------>
     |          (5)  |
     '-,NOSQLCA------'
 
>-----+--------------------------------------------+------------>
      '-,SQLFLAG--(--+-SAA-----------------+---)---'
                     '-89--+------------+--'
                           '-(COMPLETE)-'
 
      .-,STDSQL--(NO)----------------.
>-----+------------------------------+-------------------------->
      '-,STDSQL--(--+-NO------+---)--'
                    |    (6)  |
                    '-89------'
 
>-----+---------------------------+-----------------------------|
      '-,TIME--(--+-EUR---+---)---'
                  +-ISO---+
                  +-JIS---+
                  +-LOCAL-+
                  '-USA---'

Notes:

  1. COBOL and PL/I only.

  2. Only meaningful for a non-DB2 Server for VM or -DB2 Server for VSE application server.

  3. C only.

  4. COBOL only.

  5. Implied if STDSQL(89) is specified.

  6. 86 is a synonym for 89.

  7. Valid for DB2 Server for VSE only. 

 
multiple-user-mode-parms
 
|--+------------------------------------+-----------------------|
   +-DBFile--(--| fileparms |--)--------+
   |            .----------------.      |
   |            V                |      |
   '-DBList--(-----server_name---+---)--'
 
single-user-mode-parms
 
|---Dbname----(server_name)---+--------------------+------------>
                              '-dcssID--(dcss_id)--'
 
>-----+---------------------------------------------------+-----|
      '-LOGmode--(--+-A-+---)----+---------------------+--'
                    +-L-+        '-PARMID--(filename)--'
                    +-N-+
                    '-Y-'

Program Preparation Command - VSE Users

Multiple User Mode

                         (1)
>>-//--EXEC--PGM=ARIPRPx-------+------------+------------------->
                               '-,SIZE=AUTO-'
 
>----,PARM=--'--PREPname=--+----------------+--package_id------->
                           '-collection_id.-'
 
>----,USERid=--authorization_name/password---------------------->
 
>----+----------------------------+----------------------------->
     |                      (2)   |
     '-DBNAME=--server_name-------'
 
>----+------------------------------------------------+--'-----><
     |                           .-.A----------.      |
     +-PrepFile=--(--membername--+-------------+---)--+
     |                           '-.membertype-'      |
     |               (3)                              |
     '-| prepparms |----------------------------------'

Notes:

  1. The x represents A for assembler, B for C, C for COBOL, F for FORTRAN, and P for PL/I.

  2. From 1 to 18 characters, and identifies the DBNAME for the application server.

  3. Same as prepparms for VM on page Program Preparation Command - VM Users.

Single User Mode

>>-//--EXEC--PGM=ARISQLDS--,SIZE=AUTO--------------------------->
 
             .----------------------------------.
             V                                  |
>----,PARM=-----+---------------------------+---+--------------->
                '-initialization_parameter,-'
 
                      (1)
>----PROGNAME=ARIPRPx-------,PARM=--'--------------------------->
 
>----PREPname=--+----------------+--package_id------------------>
                '-collection_id.-'
 
>----,USERid=--authorization_name/password---------------------->
 
>-----+----------------------------+---------------------------->
      |                      (3)   |
      '-DBNAME=--server_name-------'
 
>----+------------------------------------------------+--'-----><
     |                           .-.A----------.      |
     +-PrepFile=--(--membername--+-------------+---)--+
     |                           '-.membertype-'      |
     |               (3)                              |
     '-| prepparms |----------------------------------'

Notes:

  1. x represents A for assembler, B for C, C for COBOL, F for FORTRAN and P for PL/I.

  2. Same as prepparms for VM on page Program Preparation Command - VM Users.

  3. From 1 to 18 characters, and identifies the DBNAME for the application server.

Program BIND Command - VSE Users

>>-CBND----PACKAGE(-+----------------+--+------------+--+---+--->
                    '-collection_id.-'  '-package_id-'  '-)-'
 
>-----+---------------------------------+----------------------->
      '- INfile--(--private_file_id--)--'
 
>-----+--------------------------------------------------------+-><
      |  .---------------------------------------------------. |
      |  V                                                   | |
      +----+-+-NEW-----------------+----------------------+--+-+
      |    | '-REPLACE--+--------+-'                      |    |
      |    |            +-KEEP---+                        |    |
      |    |            '-REVOKE-'                        |    |
      |    +-OWner--(--authorization_name----)------------+    |
      |    +-QUALifier--(--collection_id----)-------------+    |
      |    +-+-NOCHECK-+----------------------------------+    |
      |    | +-CHECK---+                                  |    |
      |    | '-ERROR---'                                  |    |
      |    |            .----------------.                |    |
      |    |            V                |                |    |
      |    +-DBList--(-----server_name---+---)------------+    |
      |    +-USERid--(--authorization_name/password----)--+    |
      |    '-MSGQueue--(--name----)-----------------------'    |
      '-QRY----------------------------------------------------'

Note:For any options not specified on the CBND transaction, the default option will be the option specified when the package was preprocessed, unless otherwise noted.

[ Top of Page | Previous Page | Next Page | Table of Contents ]