Bulk load configuration file
- Last Updated: April 12, 2023
- 1 minute read
- DataDirect Connectors
- JDBC
- Salesforce 6.0
- Documentation
Each time data is exported to a CSV file, a bulk load configuration file is created. This file has the same name as the CSV file, but with an .xml extension (for example, GBMAXTABLE.xml).
In its metadata, the bulk load configuration file defines the names and data
types of the columns in the CSV file based on those in the table or ResultSet
object. It also defines other data properties, such as the source code page for character data
types, precision and scale for numeric data types, and nullability for all data types. The
format of GBMAXTABLE.xml might look like the following
example.
Note: If the driver cannot read a bulk load configuration file (for example, because it was
inadvertently deleted), the driver reads all data as character data. The character set used by
the driver is UTF-8.
<?xml version="1.0" encoding="utf-8"?>
<table codepage="UTF-8" xsi:noNamespaceSchemaLocation=
"http://media.datadirect.com/download/docs/ns/bulk/BulkData.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<row>
<column datatype="DECIMAL" precision="38" scale="0" nullable="false">
INTEGERCOL</column>
<column datatype="VARBINARY" length="10"
nullable="true">VARBINCOL</column>
<column datatype="VARCHAR" length="10" sourcecodepage="Windows-1252"
externalfilecodepage="Windows-1252"
nullable="true">VCHARCOL</column>
<column datatype="VARCHAR" length="10" sourcecodepage="Windows-1252"
externalfilecodepage="Windows-1252"
nullable="true">UNIVCHARCOL</column>
</row>
</table>