Subject Re: [firebird-support] Token unknown - SUSPEND/END
Author Daniel Rail

At July 9, 2003, 06:14, Ghanshyam wrote:

> Hello,
> When I'm trying to create a SP (Having union of 3 nested select
> statements) by executing the following code (The entire code is given
> below), it gives me an error -

> "Token unknown - SUSPEND"

> iF SUSPEND is removed, it gives error "Token unknown - END"
> i.e anything written after last SELECT is an error. May be last
> SELECT is having some problem. Or is there any other problem related
> to UNION?
> tblcountry,tbltaxcountry WHERE tblcountry.countryid =
> tbltaxcountry.countryid AND tbltaxcountry.taxid=:taxno)

Adding to what Martijn and Nick already mentioned. You need a
semi-colon(;) at the end of the line above SUSPEND, to indicate
end-of-command. Also, if you want returning values, don't forget to
define your output parameters.

And, as Martijn suggested, read the documentation on how to write SPs.

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (