binary format

[Former Member]

Hi,

I am trying to extract the table in binary format in sybase iq using

SET TEMPORARY OPTION Temp_Extract_Name1 ='D:\data\test.inp';

SET TEMPORARY OPTION Temp_Extract_Name2 = '';

SET TEMPORARY OPTION Temp_Extract_Binary = 'on';

SET TEMPORARY OPTION Temp_Extract_Swap = 'off';

SET TEMPORARY OPTION Temp_Extract_Column_Delimiter = '|';

SET TEMPORARY OPTION Temp_Extract_Row_Delimiter = '\n';

SELECT * FROM test;

--SET TEMPORARY OPTION Temp_Extract_Name1 = ''

but it is extracting in ascii format only...

Can anyone tel me extract the table in binary format in sybase iq.

Thanks

Santosh Negalur

[tayeb_hadjou]

Hi Santosh,

Options Temp_Extract_Column_Delimiter and Temp_Extract_Row_Delimiter are used for ASCII extract format. Not needed for Binary extraction.

Check if you are not in extract restriction list :

Extraction Limitations

What is the exact IQ version you are testing on ?

Regards,

Tayeb.

[Former Member]

Hi Tayeb.,

I am using sybase IQ 15.4.

Tell me how to extract table data in binary format.

And tell me extracting the table data in binary format is fast or ascii format.

Thanks,

Santosh Negalur

[tayeb_hadjou]

Hi Santosh,

If the table is not subject to restrictions mentioned above, then

SET TEMPORARY OPTION Temp_Extract_Binary = 'on';

SET TEMPORARY OPTION Temp_Extract_Swap = 'off'

SET TEMPORARY OPTION Temp_Extract_Name1 ='D:\data\test.inp';

SELECT * FROM test;

SET TEMPORARY OPTION Temp_Extract_Name1 = '' ;

You can validate it with an import (load table ... format binary ..) .

See example in SAP Sybase IQ manual here :

Moving Data Between Systems with Different Endian Formats

Regards,
Tayeb.

[Former Member]

Thank You Tayeb.