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. The name should follow the naming convention specified in Naming conventions. |
The following mandatory columns should not be sent in the load request:
<table shortcut>_PWHG_ID<table shortcut>_RECEIVED_TIMESTAMP<table shortcut>_MINUTES_COUNT_SUM
These columns are populated by the PMDB FocalPoint during the load process.
<row> tag
Holds one row of loaded data. Where X is a one-digit number indicating the length of the value's length, Y is the actual length of the value, and value is the actual value. For example:
212ABCDEFGHIJKL^141234^15RT123
The first column value's length is 2, the column value's length is 12, and the column value is ABCDEFGHIJKL; the second column value's length is 1, the column value's length is 4 and the column value is 1234; and so on.
| Attribute | Definition |
|---|---|
rownum | Required. Holds the ordinal number of the row. |
<statement> tag
Holds the actual SQL command to perform.