BulkLoadFieldDelimiter and loadTableFromFile

Posted by AhJian324 on 23-Jul-2014 02:34

Hi all,

I'm using loadTableFromFile (C++ function) to load data to a table. 

I would like to set delimiter as pipe, instead of command.

I try to set in /opt/Progress/DataDirect/Connect_for_ODBC/odbc.ini, BulkLoadFieldDelimiter=|

But the function failed to import data into table. The error message is

 

Row: 1; column: -1; warning: Error at offset 80 in file (/home/xxxx/XXXXX.txt).

All Replies

Posted by Brody on 23-Jul-2014 10:56

Can you post the first couple lines from the file you're attempting to load?

This thread is closed