SAP Knowledge Base Article - Preview

1986248 - LOAD TABLE cannot recognize the row delimiter - SAP IQ

Symptom

  • LOAD TABLE statement may get a wrong position of row delimiter on Windows environment.
  • This problem may occur when a fixed width file has many rows.
  • This problem is not reproduced in SAP IQ 16.0 or later.
  • From IQMSG log you can see the following messages:

--------------------------
I... 0000000320 [20748]: Offset 0, Length 10, 0 nulls, A->varchar col1
I... 0000000320 [20748]: Offset 0, Length 10, 0 nulls, A->varchar col2
I... 0000000320 [20585]: Row Delimiter: \x0d\x0a
I... 0000000320 [20571]: *** Record size: variable, Block size: 500000
I... 0000000320 Insert Started:
I... 0000000320 TESTTAB
I... 0000000320 Exception Thrown from db_sqlins.cxx:11995, Err# 139, tid 155 origtid 155
I... 0000000320 O/S Err#: 0, ErrID: 4098 (db_sqlexception); SQLCode: -1013061, SQLState: 'QCA61', Severity: 14
I... 0000000320 [20631]: Missing row delimiter detected during a row delimited insert.
-- (db_sqlins.cxx 11995)
I... 0000000320 Exception Thrown from db_sqlins.cxx:11995, Err# 139, tid 2 origtid 155
I... 0000000320 O/S Err#: 0, ErrID: 4098 (db_sqlexception); SQLCode: -1013061, SQLState: 'QCA61', Severity: 14
I... 0000000320 [20631]: Missing row delimiter detected during a row delimited insert.
-- (db_sqlins.cxx 11995)


Read more...

Environment

  • SAP IQ 15.x
  • SAP IQ 16.x

Product

SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

row_delimiter, CR667051, -101306, 667051 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.