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

Using 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"