The Data Loader is a PMDB utility that enables you to efficiently load data into the database structure defined by the DDML document. To improve the load performance, the Data Loader uses JDBC (Java Database Connectivity) batches (similar to array batching in PRO*C). The Data Loader processes data structured in XML. To load this data, you must run the psin_http_requestor utility.
The Data Loader can only process tables defined in the DDML document.
Load request document format
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.