Db2 command line processor BIND command

Use the Db2 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 Db2 command line processor BIND command.
Read syntax diagramSkip visual syntax diagramBINDdbrm-file-name-COLLECTIONcollection-name1options-clause2
Notes:
  • 1 If you do not specify a collection, Db2 uses NULLID.
  • 2 You can specify the options after collection-name in any order.

options-clause:

Read syntax diagramSkip visual syntax diagramQUALIFIER( 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)CURRENTDATA(NOALL)DBPROTOCOL(DRDA)DBPROTOCOL(PRIVATE)DEGREE(1)DEGREE(ANY)DYNAMICRULES(RUN)DYNAMICRULES(BINDDEFINEBINDDEFINERUNINVOKEBINDINVOKERUN)ENCODING(ASCIIEBCDICUNICODEccsid)EXPLAIN(NO)EXPLAIN(YESALLONLY)IMMEDWRITE(NO)IMMEDWRITE(YESPH1INHERITFROMPLAN)KEEPDYNAMIC(NO)KEEPDYNAMIC(YES)ISOLATION(CS)ISOLATION(RRRSURNC)REOPT(NONE)1REOPT(ALWAYS)2RELEASE(COMMIT)RELEASE(DEALLOCATE)RELEASE(INHERITFROMPLAN)OPTHINT(' hint-ID')SQLERROR(NOPACKAGE)SQLERROR(CONTINUECHECK)VALIDATE(RUN)VALIDATE(BIND)path-clause
Notes:
  • 1 You can specify NOREOPT(VARS) as a synonym of REOPT(NONE).
  • 2 You can specify REOPT(VARS) as a synonym of REOPT(ALWAYS).

path-clause:

Read syntax diagramSkip visual syntax diagramPATH(  )PATH(,schema-nameUSER)
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 Db2 command line processor 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).