mfhco bindall command

Syntax

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]

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 .

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.

Example

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