BulkLoadFieldDelimiter and loadTableFromFile - Forum - DataDirect Connect - Progress Community

BulkLoadFieldDelimiter and loadTableFromFile

 Forum

BulkLoadFieldDelimiter and loadTableFromFile

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

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