Root element of the load document.
| Attribute | Definition |
|---|---|
connection-pool | Required. Holds the name of the connection-pool to load. Must have the value pw. |
continue-on-error | Optional. Indicates whether to continue to the next rowset if an error occurs. Default value is FALSE. If the value is TRUE, the load process continues. |
The <rowsets> tag can have the following children:
<rowset> tag
Holds the request for a specific rowset.
| Attribute | Definition |
|---|---|
object | Required. Holds the table name. The name should follow the naming convention specified in Naming conventions. |
delete | Optional. Indicates whether to perform a delete on the table. Default value is FALSE. If the value is TRUE, all data is deleted from the object (do not perform commit). |
truncate | Optional. Indicates whether to truncate all the data in the table. Default value is FALSE. If the value is TRUE, all data in the object is truncated (perform commit). |
The <rowset> tag can have the following children:
<columns> tag
Holds a tag list of all the columns to load in this rowset.
| Child | Definition |
|---|---|
<column> | Required. Holds the name of one column to load. |
<row> tag
...
<statement> tag
Holds the actual SQL command to perform.