SAP Knowledge Base Article - Preview

2559997 - Iqunload generates load table scripts without double quotes of some columns.

Symptom


Iqunload utility generates the load statement of NLS table without double quotes.
It causes the syntax error like below.

[Error]
Could not execute statement.Syntax error near '/' on line 8SQLCODE=-131, ODBC 3 State="42000"Line 17559
You can continue executing or stop.
---- Reload data for table "dnladm"."/BIC/TEST"-- Bytes per row: 265---- Stats: Row group: Rows -- 1: 7269--
LOAD TABLE "dnladm"."/BIC/TEST" (..., /BIC/col1 NULL('NULL'), /BIC/col2 NULL('NULL'),...))
FROM '/usr/sap/.../BIC/TEST_DATA_1.inp'
ROW DELIMITED BY '\r\n' QUOTES ON ESCAPES OFF DEFAULTS OFF FORMAT ASCII CHECK CONSTRAINTS OFF


Read more...

Environment

  • SAP IQ 16.1
  • SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

"double quotes", "Syntax error near '/' ", "Schema and Data Export", 811844, CR#811844, CR 811844, CR811844 , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem

About this page

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

Search for additional results

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