Skip to Content
0
Former Member
Sep 07, 2014 at 06:31 PM

binary format

70 Views

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