Schema | wc-dataload.xsd |
Target Namespace | http://www.ibm.com/xmlns/prod/commerce/foundation/config |
Namespace Table | http://www.ibm.com/xmlns/prod/commerce/foundation/config http://www.w3.org/2001/XMLSchema |
include wc-dataload-common.xsd |
DataLoadConfiguration |
DataLoadConfiguration DataLoadEnvironment DataSourceLocation LoadItem LoadOrder |
DataLoadMode |
Complex Type DataLoadConfiguration | |||||||||||||||||||||||||||||||||||
Namespace | http://www.ibm.com/xmlns/prod/commerce/foundation/config | ||||||||||||||||||||||||||||||||||
Diagram | |||||||||||||||||||||||||||||||||||
Inheritance Hierarchy | anyType {http://www.w3.org/2001/XMLSchema} DataLoadConfiguration {http://www.ibm.com/xmlns/prod/commerce/foundation/config} |
||||||||||||||||||||||||||||||||||
Content Details |
|
||||||||||||||||||||||||||||||||||
Documentation | |||||||||||||||||||||||||||||||||||
Source | <xsd:complexType name="DataLoadConfiguration"> <xsd:sequence> <xsd:element name="DataLoadEnvironment" type="_config:DataLoadEnvironment" minOccurs="1" maxOccurs="1"> </xsd:element> <xsd:element name="LoadOrder" type="_config:LoadOrder" minOccurs="1" maxOccurs="1"> </xsd:element> </xsd:sequence> </xsd:complexType> |
Complex Type DataLoadEnvironment | |||||||||||
Namespace | http://www.ibm.com/xmlns/prod/commerce/foundation/config | ||||||||||
Diagram | |||||||||||
Inheritance Hierarchy | anyType {http://www.w3.org/2001/XMLSchema} DataLoadEnvironment {http://www.ibm.com/xmlns/prod/commerce/foundation/config} |
||||||||||
Content Details | |||||||||||
Documentation |
Attribute | Type | Required | Default Setting | Description |
configFile | String | Yes | N/A |
The location of the environment configuration file. An XML file that validates successfully against the XSD file wc-dataload-env.xsd. An absolute path, or relative path, to the file. The relative path is relative to the location of this load order configuration file. |
<xsd:complexType name="DataLoadEnvironment"> <xsd:attribute name="configFile" use="optional" form="unqualified" type="xsd:string"> </xsd:attribute> </xsd:complexType>
Complex Type DataSourceLocation | |||||||||||
Namespace | http://www.ibm.com/xmlns/prod/commerce/foundation/config | ||||||||||
Diagram | |||||||||||
Inheritance Hierarchy | anyType {http://www.w3.org/2001/XMLSchema} DataSourceLocation {http://www.ibm.com/xmlns/prod/commerce/foundation/config} |
||||||||||
Content Details |
|
||||||||||
Documentation |
Attribute | Type | Required | Default Setting | Description |
location | String | No | N/A |
The location of the data required by the data reader. An absolute path, or relative path, to the file. The location relative path should be relative to the dataInputFilePath in the FilePath defined in the dataload environment configuration file. If the dataInputFilePath is not defined in the data load environment configuration file, the location relative path should be relative to the load order configuration file. |
<xsd:complexType name="DataSourceLocation"> <xsd:sequence> <xsd:element name="property" type="_config:NameValuePair" minOccurs="0" maxOccurs="unbounded"> </xsd:element> </xsd:sequence> <xsd:attribute name="location" type="xsd:string" use="optional" form="unqualified"> </xsd:attribute> </xsd:complexType>
Complex Type LoadItem | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Namespace | http://www.ibm.com/xmlns/prod/commerce/foundation/config | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Diagram | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Inheritance Hierarchy | anyType {http://www.w3.org/2001/XMLSchema} LoadItem {http://www.ibm.com/xmlns/prod/commerce/foundation/config} |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Content Details |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Documentation |
Attribute | Type | Required | Default Setting | Description |
name | String | Yes | N/A |
The name of the load item. This is a required attribute that captures load summary and error information. |
businessObjectConfigFile | String | Yes | N/A |
The location of the business object configuration file. An XML file that validates successfully against the XSD file wc-dataload-businessobject.xsd. An absolute path, or relative path, to the file. The value for businessObjectConfigFile relative path should be relative to the boConfigFilePath in the FilePath defined in the dataload environment configuration file. If the boConfigFilePath is not defined in the dataload environment configuration file, businessObjectConfigFile relative path should be relative to the load order configuration file. |
dataLoadMode | String | No | Replace |
This attribute the mode the data should be loaded in. If defined at the load order level, all load items inherit this value. The value can be overridden at the load item level. Data load utility modes:
|
commitCount | nonNegativeInteger | No | 1 |
Specifies how many lines to process before calling database commit. The default setting is 1. If the commitCount is 0, it means it will not commit until this load item finishes processing all of its input data. If defined at the load order level, all load items inherit this value. The value can be overridden at the load item level. |
batchSize | nonNegativeInteger | No | 1 |
The batch size specifies how many lines of records to process when using JDBC batch. The default value is 1, JDBC batch update is not used. If the batchSize is 0, batches all of processed input data for the entire load item. If defined at the load order level, all load items inherit this value. The value can be overridden at the load item level. |
maxError | nonNegativeInteger | No | 1 |
This attribute is a setting for the error tolerance during the data load process for a load item. If defined at the load order level, all load items inherit this value. The value can be overridden at the load item level. The utility continues to load data for a load item until the error tolerance level is reached; then the utility exits. For configuration and system errors, the utility ends before it reaches the tolerance level. |
retry | boolean | No | false |
A flag indicating that if an error occurs during the data load process, the utility retries to load the data. If configuration errors or system errors occur the utility ends. If defined at the load order level, all load items inherit this value. The value can be overridden at the load item level. |
startKey | long | No | N/A |
This attribute combined with the attribute endKey defines which primary key range to use when the object does not exist in the database and it requires a new generated key. |
endKey | long | No | N/A |
This attribute combined with the attribute startKey defines which primary key range to use when the object does not exist in the database and it requires a new generated key. |
<xsd:complexType name="LoadItem"> <xsd:sequence> <xsd:element name="property" type="_config:NameValuePair" minOccurs="0" maxOccurs="unbounded"> </xsd:element> <xsd:element name="DataSourceLocation" type="_config:DataSourceLocation" minOccurs="0" maxOccurs="1"> </xsd:element> <xsd:element name="BusinessContext" type="_config:BusinessContext" minOccurs="0" maxOccurs="1"> </xsd:element> </xsd:sequence> <xsd:attribute name="name" type="xsd:string" use="required" form="unqualified"> </xsd:attribute> <xsd:attribute name="businessObjectConfigFile" type="xsd:string" use="required" form="unqualified"> </xsd:attribute> <xsd:attribute name="dataLoadMode" type="_config:DataLoadMode" use="optional" form="unqualified"> </xsd:attribute> <xsd:attribute name="commitCount" type="xsd:nonNegativeInteger" use="optional" form="unqualified"> </xsd:attribute> <xsd:attribute name="batchSize" type="xsd:nonNegativeInteger" use="optional" form="unqualified"> </xsd:attribute> <xsd:attribute name="maxError" type="xsd:nonNegativeInteger" use="optional" form="unqualified"> </xsd:attribute> <xsd:attribute name="retry" type="xsd:boolean" use="optional" form="unqualified"> </xsd:attribute> <xsd:attribute name="startKey" type="xsd:long" use="optional" form="unqualified"> </xsd:attribute> <xsd:attribute name="endKey" type="xsd:long" use="optional" form="unqualified"> </xsd:attribute> <xsd:attribute name="loadSequence" type="xsd:double" use="optional" form="unqualified"> </xsd:attribute> </xsd:complexType>
Complex Type LoadOrder | |||||||||||||||||||||||||||||||
Namespace | http://www.ibm.com/xmlns/prod/commerce/foundation/config | ||||||||||||||||||||||||||||||
Diagram | |||||||||||||||||||||||||||||||
Inheritance Hierarchy | anyType {http://www.w3.org/2001/XMLSchema} LoadOrder {http://www.ibm.com/xmlns/prod/commerce/foundation/config} |
||||||||||||||||||||||||||||||
Content Details |
|
||||||||||||||||||||||||||||||
Documentation |
Attribute | Type | Required | Default Setting | Description |
dataLoadMode | String | No | Replace |
This attribute the mode the data should be loaded in. If defined at the load order level, all load items inherit this value. The value can be overridden at the load item level. Data load utility modes:
|
commitCount | nonNegativeInteger | No | 1 |
Specifies how many lines to process before calling database commit. The default setting is 1. If the commitCount is 0, it means it will not commit until this load item finishes processing all of its input data. If defined at the load order level, all load items inherit this value. The value can be overridden at the load item level. |
batchSize | nonNegativeInteger | No | 1 |
The batch size specifies how many lines of records to process when using JDBC batch. The default value is 1, JDBC batch update is not used. If the batchSize is 0, batches all of processed input data for the entire load item. If defined at the load order level, all load items inherit this value. The value can be overridden at the load item level. |
maxError | nonNegativeInteger | No | 1 |
This attribute is a setting for the error tolerance during the data load process for a load item. If defined at the load order level, all load items inherit this value. The value can be overridden at the load item level. The utility continues to load data for a load item until the error tolerance level is reached; then the utility exits. For configuration and system errors, the utility ends before it reaches the tolerance level. |
retry | boolean | No | false |
A flag indicating that if an error occurs during the data load process, the utility retries to load the data. If configuration errors or system errors occur the utility ends. If defined at the load order level, all load items inherit this value. The value can be overridden at the load item level. |
<xsd:complexType name="LoadOrder"> <xsd:sequence> <xsd:element name="property" type="_config:NameValuePair" minOccurs="0" maxOccurs="unbounded"> </xsd:element> <xsd:element name="LoadItem" type="_config:LoadItem" minOccurs="1" maxOccurs="unbounded"> </xsd:element> </xsd:sequence> <xsd:attribute name="dataLoadMode" use="optional" type="_config:DataLoadMode" form="unqualified"> </xsd:attribute> <xsd:attribute name="commitCount" type="xsd:nonNegativeInteger" use="optional" form="unqualified"> </xsd:attribute> <xsd:attribute name="batchSize" type="xsd:nonNegativeInteger" use="optional" form="unqualified"> </xsd:attribute> <xsd:attribute name="maxError" type="xsd:nonNegativeInteger" use="optional" form="unqualified"> </xsd:attribute> <xsd:attribute name="retry" use="optional" form="unqualified" type="xsd:boolean"> </xsd:attribute> </xsd:complexType>
Simple Type DataLoadMode | |||||||
Namespace | http://www.ibm.com/xmlns/prod/commerce/foundation/config | ||||||
Diagram | |||||||
Inheritance Hierarchy | string {http://www.w3.org/2001/XMLSchema} DataLoadMode {http://www.ibm.com/xmlns/prod/commerce/foundation/config} |
||||||
Allowable Values |
|
||||||
Documentation | |||||||
Source | <xsd:simpleType name="DataLoadMode"> <xsd:restriction base="xsd:string"> <xsd:enumeration value="Insert"> </xsd:enumeration> <xsd:enumeration value="Replace"> </xsd:enumeration> <xsd:enumeration value="Delete"> </xsd:enumeration> </xsd:restriction> </xsd:simpleType> |
Element DataLoadConfiguration | |
Namespace | http://www.ibm.com/xmlns/prod/commerce/foundation/config |
Diagram | |
Type | DataLoadConfiguration {http://www.ibm.com/xmlns/prod/commerce/foundation/config} |
Documentation | |
Source | <xsd:element name="DataLoadConfiguration" type="_config:DataLoadConfiguration"> </xsd:element> |