Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

binary format

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

Former Member
Not what you were looking for? View more on this topic or Ask a question