SAP Knowledge Base Article - Preview

2374483 - Expected 'column' delimiter but encountered a row delimiter instead error. Quotes on/off LOAD parameter. BCP vs. ASCII FORMAT.

Symptom

  • Load fails with error:
Exception Thrown from db_sqlins.cxx:2233, Err# 55, tid 6 origtid 295
O/S Err#: 0, ErrID: 4098 (db_sqlexception); SQLCode: -1013062, SQLState: 'QCA62', Severity: 14
Expected 'column' delimited column type on input, but encountered a row delimiter instead.
Probable cause is a mismatch between the specified column delimiter and the column delimiter used in the input file.
-- (db_sqlins.cxx 2233)


Read more...

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , HAN-DYT , SAP HANA Dynamic Tiering , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.