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.