You may specify the connection parameters in one of the following ways: $dbAlias $dbURL, $dbUser, $dbPass, $dbDriver $dbConnection | |
$dbAlias | String Optional. Database alias. |
$dbURL | String Optional. JDBC URL that identifies the database resource. |
$dbUser | String Optional. User name to use to log into the database. |
$dbPass | String Optional. Password for the user. |
$dbDriver | String Optional. Name of the JDBC driver to use. |
$dbConnection | com.wm.app.b2b.server.DBConnection Optional. Connection object returned by pub.db:connect. |
$dbCatalog | String Optional. Name of the database's system catalog. Include this parameter if your DBMS supports distributed databases and you want to query a table that is not in the database to which you are connected. If you are not using a distributed database system or if you want to query a table in the database to which you are connected, you do not need to specify this parameter. If you are running against DB2, use this parameter to specify the database location. |
$dbSchemaPattern | String Optional. Name of the schema to which the table belongs. If your database supports pattern-matching on schemas, you may specify the schema name with a pattern-matching string, where _ represents a single character and % represents any string of characters. For example, the value HR% would represent any schema beginning with the characters HR. If you are running against DB2, you use this parameter to specify the table's AuthID. |
$dbTable | String Name of table to query. |
$data | Document Optional. Criteria that the rows to retrieve must meet. |
results | com.wm.util.Table Conditional. Results of the query. The Integration Server recognizes and treats this parameter as a Document List at run time. |
$dbMessage | String Conditional. Message indicating the success or failure of an operation. |
$rowCount | String Conditional. Number of rows for the table that meet the criteria specified in $data. |