mfhco and cobmfhco bindall commands

Syntax

Windows:

mfhco bindall db=databasename [qualifier=schema] [collection=collection-id]
    [datetime=format] [isolation=isolation-level] [blocking=row-blocking] 
       [sqlwarn=compile-option] [id=logon-id] [pass=password]

UNIX:

cobmfhco bindall db=databasename [qualifier=schema] [collection=collection-id]
    [datetime=format] [isolation=isolation-level] [blocking=row-blocking] 
       [sqlwarn=compile-option] [id=logon-id] [pass=password]

Parameters

bindall Parameter to invoke BindAll command line processor. Parameter is positional.
databasename Name of the database to connect to.
schema Name of the schema to use for table qualification.
collection-id A 128-byte collection identifier for the package.
format One of the following datetime formats to return when executing the application:
  • USA
  • ISO
  • JIS
  • EUR
  • LOC
  • DEF
isolation-level Determines how far a program bound to this package can be isolated from the effect of other executing programs. Valid values are:
  • CS
  • RR
  • RS
  • UR
row-blocking The type of row blocking for cursors. Valid values are:
  • UNAMBIG
  • ALL
  • NO

The blocking of row data that contains references to LOB column data types is also supported in partitioned database environments.

compile-option Indicates whether warnings are returned from the compilation of dynamic SQL statements via PREPARE or EXECUTE IMMEDIATE, or from describe processing via PREPARE...INTO or DESCRIBE. Valid values are:
  • YES
  • NO
logon-id Logon ID required to connect to the server where the database resides.
password Password required to connect to the server where the database resides.

Comments

You must execute the BindAll Packages tool either from a command prompt in the directory that contains your .bnd files, or from your project as a post-build event. For more information on build events, see Setting Project-Wide Build Properties and Compiler Directives.

The BindAll Packages tool generates a log file, bindall.txt, that summarizes the results for all packages bound. Individual results are written to programName.txt.

Log files are written to the current directory.

Examples

Windows:

mfhco bindall db=db2demo qualifier=DEMO datetime=usa isolation=cs sqlwarn=no

UNIX:

cobmfhco bindall db=db2demo qualifier=DEMO datetime=usa isolation=cs sqlwarn=no