Re: Continuation character?

if you use IDS/UD 9.1X after open your session, do 'execute procedure ifx_allow_newline('t');' and you can do what yo want to do, else if you use IDS.2000 after set onconfig parameter ALLOW_NEWLINE to 1 and restart engine, you can do what you want to do, Wish this helps you.... David Fishburn wrote: > I want to execute a stored procedure like this: > execute procedure sp_table_script( 'ULOrder', 'upload_cursor',> 'SELECT order_id, cust_id, prod_id, emp_id, disc, quant, notes, status > FROM ULOrder > WHERE order_id = ?' ); > > In this case for formatting reasons, I would like to extend the 3rd > parameter (which is a string) over multiple lines. SQL Editor does not like > this and gives me a syntax error near SELECT. > > If I remove the carriage returns, everything works fine. > > Is there some sort of continuation marker I can use, Oracle uses a dash, so > this works: > execute procedure sp_table_script( 'ULOrder', 'upload_cursor',> 'SELECT order_id, cust_id, prod_id, emp_id, disc, quant, notes, status - > FROM > - > WHERE order_id = ?' ); > > TIA > > -- > David Fishburn > Sybase > Please only post to the newsgroup