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]
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]
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:
|
isolation-level | Determines how far a program bound to this package can be isolated from the effect of other executing programs. Valid values
are:
|
row-blocking | The type of row blocking for cursors. Valid values are:
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:
|
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. |
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.
mfhco bindall db=db2demo qualifier=DEMO datetime=usa isolation=cs sqlwarn=no
cobmfhco bindall db=db2demo qualifier=DEMO datetime=usa isolation=cs sqlwarn=no