CSV files

As described in "Exporting data to a CSV file," the driver can create a CSV file by exporting data from a table or ResultSet object. For example, suppose you want to export data from a 4-column table named GBMAXTABLE into a CSV file. The contents of the CSV file, named GBMAXTABLE.csv, might look like the following example:

1,0x6263,"bc","bc"
2,0x636465,"cde","cde"
3,0x64656667,"defg","defg"
4,0x6566676869,"efghi","efghi"
5,0x666768696a6b,"fghijk","fghijk"
6,0x6768696a6b6c6d,"ghijklm","ghijklm"
7,0x68696a6b6c6d6e6f,"hijklmno","hijklmno"
8,0x696a6b6c6d6e6f7071,"ijklmnopq","ijklmnopq"
9,0x6a6b6c6d6e6f70717273,"jklmnopqrs","jklmnopqrs"
10,0x6b,"k","k"

In this section:

Bulk load configuration file

Bulk load configuration file schema

Character set conversions

External overflow files

Discard file