Hi,

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?

[...snip...]

> tblcountry,tbltaxcountry WHERE tblcountry.countryid =
> tbltaxcountry.countryid AND tbltaxcountry.taxid=:taxno)
> SUSPEND;
> END

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. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)