Integration Server 10.5 | Built-In Services Reference Guide | Db Folder | Summary of Elements in this Folder | pub.db:insert
 
pub.db:insert
WmDB. Inserts one or more rows into the specified table. As an alternative to this service, consider using the services provided with the webMethods Adapter for JDBC.
Input Parameters
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 insert rows into 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 insert rows into 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 in which you want to insert rows.
$dbRollbackOnFail
String Optional. Flag that determine whether changes are committed if a failure occurs while processing multiple inserts. Set to:
*true to undo changes on failure.
*false to commit changes on failure. This is the default.
$data
Document or Document List Optional. Data to insert.
Output Parameters
$updateCount
String Number of rows the service inserted.
$failCount
String Number of rows the service failed to insert.
$errors
Document Conditional. Error messages generated during service execution.
$dbMessage
String Conditional. Message indicating the success or failure of the operation.
Usage Notes
This service accepts input from a web browser or HTML form.