Using the JDBC Client : Using DataDirect Bulk Load : Using CSV Files : Bulk Load Configuration File

Bulk Load Configuration File

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).

The bulk load configuration file defines in its metadata 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 nullablity for all data types. The format of GBMAXTABLE.xml might look like the following example.

<?xml version="1.0" encoding="utf-8"?>

<table codepage="UTF-8" xsi:noNamespaceSchemaLocation=

"https://www.progress.com/datadirect-connectors" 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>

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.