Skip to Content
0
Former Member
Apr 14, 2016 at 01:52 AM

multiple lines in dbisql

472 Views

Hi, experts

Q1>

I tried to execute a SQL (like below).

but error occurs.

--------------- sql (bof)----------------

begin

declare x int;

set x=1;

if x=1 then

print 'x_value is 1';

endif

end

-----------------(eof) -------------------

#### sybase IQ 15.4

dbisql -nogui

(DBA)> begin

Could not execute statement.

Syntax error near '(end of line)' on line 1

SQLCODE =-131, ODBC 3 State="42000"

Q2>

how to print output(for example, x_value is 1)

after executing batch sql like above sql ?

What is the option seems like "set serverouput on" in oracle ?

Unfortunately , I cannot access sap note....

please just a little comments...

Thanks in advance...