Command line processor BIND command

Use the command line processor BIND command to bind DBRMs that are in z/OS® UNIX HFS files to packages.

The following diagram shows the syntax for the command line processor BIND command.


>>-BIND--dbrm-file-name--+----------------------------------+--->
                         |                              (1) |   
                         '--COLLECTION--collection-name-----'   

                  (2)   
>--options-clause----------------------------------------------><

Notes:

If you do not specify a collection, DB2® uses NULLID.
You can specify the options after collection-name in any order.

options-clause:


   .-QUALIFIER(ID that is used during connect)-.   
>>-+-------------------------------------------+---------------->
   '-QUALIFIER(qualifier-name)-----------------'   

   .-OWNER(ID that is used during connect)-.   
>--+---------------------------------------+-------------------->
   '-OWNER(authorization-ID)---------------'   

   .-NODEFER(PREPARE)--------------.   
>--+-------------------------------+---------------------------->
   +-DEFERPREPARE(INHERITFROMPLAN)-+   
   '-DEFER(PREPARE)----------------'   

   .-ACTION--(REPLACE)--------------------------.   
>--+--------------------------------------------+--------------->
   '-ACTION--+-(REPLACE)--REPLVER(version-id)-+-'   
             '-(ADD)--------------------------'     

   .-CURRENTDATA--(YES)---------.  .-DBPROTOCOL(DRDA)----.   
>--+----------------------------+--+---------------------+------>
   '-CURRENTDATA--(--+-NO--+--)-'  '-DBPROTOCOL(PRIVATE)-'   
                     '-ALL-'                                 

   .-DEGREE(1)---.  .-DYNAMICRULES(RUN)--------------.   
>--+-------------+--+--------------------------------+---------->
   '-DEGREE(ANY)-'  '-DYNAMICRULES(-+-BIND-------+-)-'   
                                    +-DEFINEBIND-+       
                                    +-DEFINERUN--+       
                                    +-INVOKEBIND-+       
                                    '-INVOKERUN--'       

>--+-----------------------------+------------------------------>
   '-ENCODING--(--+-ASCII---+--)-'   
                  +-EBCDIC--+        
                  +-UNICODE-+        
                  '-ccsid---'        

   .-EXPLAIN(NO)-------------------------------------.   
>--+-------------------------------------------------+---------->
   '-EXPLAIN(-+-YES------------------------------+-)-'   
              +-ALL------------------------------+       
              '-Start of changeONLYEnd of change-'       

   .-IMMEDWRITE(NO)------------------------------------------------.   
>--+---------------------------------------------------------------+-->
   '-IMMEDWRITE(-+-YES-----------------------------------------+-)-'   
                 +-PH1-----------------------------------------+       
                 '-Start of changeINHERITFROMPLANEnd of change-'       

   .-KEEPDYNAMIC(NO)--.  .-ISOLATION(CS)-------.   
>--+------------------+--+---------------------+---------------->
   '-KEEPDYNAMIC(YES)-'  '-ISOLATION(-+-RR-+-)-'   
                                      +-RS-+       
                                      +-UR-+       
                                      '-NC-'       

                 (1)                                     
   .-REOPT(NONE)-------.  .-RELEASE(COMMIT)----------.   
>--+-------------------+--+--------------------------+---------->
   |               (2) |  +-RELEASE(DEALLOCATE)------+   
   '-REOPT(ALWAYS)-----'  '-RELEASE(INHERITFROMPLAN)-'   

                           .-SQLERROR(NOPACKAGE)------.   
>--+--------------------+--+--------------------------+--------->
   '-OPTHINT('hint-ID')-'  '-SQLERROR(-+-CONTINUE-+-)-'   
                                       '-CHECK----'       

   .-VALIDATE(RUN)--.                    
>--+----------------+--+-------------+-------------------------><
   '-VALIDATE(BIND)-'  '-path-clause-'

Notes:

You can specify NOREOPT(VARS) as a synonym of REOPT(NONE).
You can specify REOPT(VARS) as a synonym of REOPT(ALWAYS).

path-clause:


   .-PATH(  )--------------------.   
>>-+-----------------------------+-----------------------------><
   |       .-,---------------.   |   
   |       V                 |   |   
   '-PATH(---+-schema-name-+-+-)-'   
             '-USER--------'

The following options are unique to this diagram:

CURRENTDATA (ALL): Specifies that for all cursors data currency is required and block fetching is inhibited.
SQLERROR(CHECK): Specifies that the command line processor is to only check for SQL errors in the DBRM. No package is generated.
IMMEDWRITE(PH1): Specifies that normal write activity is done. This option is equivalent to IMMEDWRITE(NO).
EXPLAIN(ALL): Specifies that DB2 is to insert information into the appropriate EXPLAIN tables. This option is equivalent to EXPLAIN (YES).