CALL Procedure with OUTPUT parameters

[serge]

I am a little confused. If i have an SP like:

CREATE PROCEDURE ABC (IN ID Integer,
OUT TEST1 Integer,
OUT TEST2 Integer)
....

How do you call this SP?

CALL ABC(varID, varTEST1, varTEST2);
This is compiling without error for me.

or

CALL ABC(varID, ?, ?);
However this is compiling with an error, yet IBM online help refers to using
this.

Am i doing something wrong?
Also, right now the DB2 database is on a Windows Server. I notice that the
Stored procedures have TABS in them. Will this cause any problem if we move
the database to a UNIX box?
Thank you

[Thiru C via DBMonster.com]

Hi,
If SP is compiled successfully, then you call it as follows.
CALL ABC(50, ?, ?)

Chears,
Thiru
WantedToBeDBA.

--
Message posted via http://www.dbmonster.com

[Serge Rielau]

serge wrote:

I am a little confused. If i have an SP like:

CREATE PROCEDURE ABC (IN ID Integer,
OUT TEST1 Integer,
OUT TEST2 Integer)
...

How do you call this SP?

CALL ABC(varID, varTEST1, varTEST2);
This is compiling without error for me.

or

CALL ABC(varID, ?, ?);
However this is compiling with an error, yet IBM online help refers to using
this. What's the error you get? How to you invoke the CALL.
From the command line it shoudl work as is.
Embedded (i.e. inside another stored procedure) you will need to return
the result into some variable.
I think EXECUTE and EXECUTE IMMEDIATE supply an INTO clause for this
puprose.
Am i doing something wrong?
Also, right now the DB2 database is on a Windows Server. I notice that the
Stored procedures have TABS in them. Will this cause any problem if we move
the database to a UNIX box?

No problem.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab