The general format of a load request document looks as follows:
<rowsets>tag. This is the root element of a load request document. Its children are the actual loaded table and the statement to perform during the load process:<rowset>and<statement>.<rowset>tag. This tag includes the connection-pool attribute indicating the pool into which to load the data. The value of the connection-pool attribute should always be "pw".
The<rowset>tag also includes the mandatory object attribute, which indicates the name of the loaded object (such as a table name or a view name if the view is loadable), and other optional attributes described later.<statement>tag. This tag is used to issue SQL commands during the load process, such as performing an update on a control table or an additional insert that is not part of the load process.
DO NOT enter blanks, nor new lines between the tags.
<rowsets> tag
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><row>
<statement> tag
Holds the actual SQL command to perform.