Symptom
Loading a Filler( > 512 bytes) seems to be allowed in IQ12.7, comparing returns error in IQ16.
But IQ12.7 & 16 manual both notices that max limit of filler() is 512 bytes.
In IQ12.7 this limitation seems to be ignored when load is fixed format loading using 'ASCII()' syntax.
Now IQ16 treats any Filler( > 512 bytes) is errored.
Following is two repro example.
** Repro
1) create table y1( a char(2), b int, c char(2));
2) Like customer's load pattern, below load worked well in IQ12.7.
It's fixed format loading using ASCII(). But same loading returns error in IQ16.
LOAD table y1
( a ascii(2),
filler(1), -- to skip delimiter
b ascii(3),
filler(1), -- to skip delimiter
filler(600),
c ascii(2) ,
filler(1), -- to skip delimiter
filler(1))
from '/home2/iq127/work/oc_600.dat'
quotes off escapes off
-- delimited by '|'
;
3) Below variable loading using delimiter gets error due to filler( > 512 bytes).
LOAD table y1
( a ,
b ,
filler(600),
c ,
filler(1))
from '/home2/iq127/work/oc_600.dat'
quotes off escapes off
delimited by '|'
;
Error =>
Could not execute statement.
Number of bytes (600) for a column from an input file has exceeded the
maximum allowed (512). -- (db_RecScanner.cxx 412)
SQLCODE=-1013027, ODBC 3 State="HY000" Line 1, column 1
Read more...
Environment
SAP IQ 16.0
Product
Keywords
"Filler more than 512" ; Fixed format ; , KBA , BC-SYB-IQ , Sybase IQ , Problem
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.