Sybase IQ error Syntax error near 'SET' on line

Many times you may get Sybase IQ error like Syntax error near 'SET'. Suppose if I am trying to execute below statements

SET TEMPORARY OPTION Temp_Extract_Column_Delimiter =',';

SET TEMPORARY OPTION Temp_Extract_Row_Delimiter = '';

SET TEMPORARY OPTION Temp_Extract_Name1='\\\\XYZServer\\Backup\\test.txt';

SELECT column1, column2, column3 FROM tblTest

SET TEMPORARY OPTION Temp_Extract_Name1='';

commit;

Then Sybase IQ display below error

ERROR[42000][Sybase][ODBC Driver][Sybase IQ]Syntax error near 'SET' on line 5

Solution:

It simply means end SELECT query with semicolon “;”.

Every statement in Sybase IQ should be end with semicolon.

SELECT column1, column2, column3 FROM tblTest;

SET TEMPORARY OPTION Temp_Extract_Name1='';

Please leave your comments or share this tip if it’s useful for you.