Hello All,
I've extracted a table from IQ server using the following query:
set temporary option Temp_Extract_Name1 = '\\\\machine11\\binary_product_item.bin';
set temporary option Temp_Extract_Binary = 'on';
set temporary option Temp_Extract_Column_Delimiter = ' ';
select
column1
, column2
, column3
, column4
, column5
FROM product_item
>>#junkfile
And load it into a temp table with the load query:
LOAD TABLE #temp_product_item
(
column1 '\x09'
, column2 '\x09'
, column3 '\x09'
, column4 '\x09'
, column5 '\x0d\x0a'
)
FROM
'\\\\machine11\\binary_product_item.bin'
ESCAPES OFF
QUOTES OFF
FORMAT binary
DELIMITED BY '\x09'
ON FILE ERROR FINISH
DELIMITED BY '\x09'
WITH CHECKPOINT ON
I'm constantly getting error while loading - "Number of bytes (512) for a column from and input file as exceeded the maximum allowed(9)". Has anybody done binary extract and load that not having a problem?
Many Thanks,
Is there any possibility you have TAB characters in your data?