Subject | SPs using IBOConsole - newbie |
---|---|
Author | EilselPsipher <eilselpsipher@yahoo.com> |
Post date | 2002-12-16T20:49:03Z |
Hi
can anyone tell me how to write a stored Proc using IBOConsole.
when
ever I try I get the following error:
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Unexpected end of command
Statement: create procedure new_procedure
as
begin
suspend
even using a simple SP like the one below. Do I need to put it in
quotes or
some thing
create procedure new_procedure
as
begin
suspend;
end
Many thanks
Leslie
can anyone tell me how to write a stored Proc using IBOConsole.
when
ever I try I get the following error:
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Unexpected end of command
Statement: create procedure new_procedure
as
begin
suspend
even using a simple SP like the one below. Do I need to put it in
quotes or
some thing
create procedure new_procedure
as
begin
suspend;
end
Many thanks
Leslie