IQ Load table command fails while loading into data from a quoted strig

[Karthik]

Hi Folks,

I'm having troubles while loading the data from a quoted string into IQ, the load fails with the error even when I specify QUOTES ON option.  

Could not execute statement.

  Non-space text found after ending quote character for an enclosed field.

  -- (db_RecScanner.cxx 2246)

  SQLCODE=-1005014, ODBC 3 State="HY000"

Can some one pls suggest ?

For example, data file (

"empid", "empname"

"1", "ABC"

Table def:

create table example(

empid int,

empname varchar(8)

)

SET TEMPORARY OPTION ON_ERROR=EXIT;

SET TEMPORARY OPTION DATE_ORDER='MDY';

set temporary option ESCAPE_CHARACTER='ON';

LOAD TABLE t_stg_ifi_patent_class

(

empid       ',' ,

empname            '\n' )

FROM 'testfile'

SKIP 1

WITH CHECKPOINT ON

BLOCK SIZE 50000

NOTIFY 1000

ESCAPES OFF

QUOTES ON

ON FILE ERROR ROLLBACK

[Mark Mumy]

Which version of IQ?

I’m running IQ 16 SP10 PL03 and it works without issue.  Is this IQ 15?  I ask because the BLOCK SIZE is no longer valid syntax. 

Mark

[Karthik]

Hi Mark, 

Here is the sybase verison, Sybase IQ/15.4.0.3027/130221/P/ESD 3/Enterprise Linux64 - x86_64 - 2.6.18-194.el5/64bit/2013-02-21 10:52:34

So are you saying the above syntax is correct, if so why does my process fail, I dont understand :(

[Mark Mumy]

It is likely a bug that was patched in the past 4+ years.  Considering that IQ 15.4 is no longer supported, I would strongly recommend working a plan to move to IQ 16 SP11 soon.

https://wiki.scn.sap.com/wiki/display/SYBIQ/SAP+IQ+15+End+of+Maintenance+Report

Per the PAM, it was confirmed as 2016-11-30.

https://service.sap.com/sap/support/pam?hash=pvnr%3D67837800100900006860%26pt%3Dg%257Cd%26ainstnr%3D67838200104900016656

Mark

-- 
You received this message because you are subscribed to the Google Groups "iqug" group.
To unsubscribe from this group and stop receiving emails from it, send an email to iqug+uns...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Karthik]

thanks for the info, does it mean there is no workaround for me ? so I have to strip off quotes from the strings?

[Mark Mumy]

I have no idea if there’s a workaround or not.  I don’t have IQ 15 installed anywhere to test.  You could try opening a case to see if support has a known workaround other than upgrading.

Mark

[Karthik]

Thank you so much Mark, will raise a case with Sybase