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.