At 08:49 PM 16-12-02 +0000, you wrote:

>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

Leslie,

Try this:

set term ^;
create procedure new_procedure
as
begin
suspend;
end ^
set term ; ^

The reason?
For Create procedure, Create Trigger, Recreate Procedure, Alter Procedure
and Alter Trigger, you need to set an alternative SQL statement terminator
symbol, to enable the parser to accept the semicolon as the statement
terminator *within* the module code.

Read up on this is in the isql documentation...

heLen