Passing a value out from a SYBASE Stored Procedure

[Guest_imported]

My SP outputs 2 values as follows : -
exec sp "1","2","3"
X Y
-- --
abc 0 where "1" "2" & "3" are the run-time variables.

I want to use the value of Y(always either 0 or 1) in
a subsequent query.
I cannot amend the SP to declare an extra variable with
OUTPUT option set.
My on-line SYBASE SQL manual suggests : -
declare @pset char(1)
exec sp "1","2","3", @Y = @pset output
but this doesn't work.
Can anyone help ?

 

[tdatgod]

Hi,
this question maybe better asked in one of the SYBASE forums.

Sybase: Power ++
Sybase: PowerBuilder
Sybase: PowerJ
Sybase: PowerDesigner
Sybase: Adaptive Server
Sybase: SQL Server
Sybase: PowerSite
Sybase solutions

Unless of course SYBASE stored procedures are ANSI compliant.