Calling a stored procedure question - FOLLOW UP

Dave Schaeffer

Calling a stored procedure question - FOLLOW UP
Thanks to everyone that has offered suggestions.

The error I'm getting now is: CLI0100E

My call looks like: {CALL STO99C (?)}

The LINKAGE SECTION in the program is:
LINKAGE SECTION.
01 REC-OUT PIC X(18).

The SYSPROCEDURE table is setup like:
('STO99C', -- PROCEDURE
' ', -- AUTHID
' ', -- LUNAME
'STO99C', -- LOADMOD
' ', -- LINKAGE
'PACKAGES', -- COLLID
'COBOL ', -- LANGUAGE
0, -- ASUTIME
' ', -- STAYRESIDENT
'N', -- IBMREQD
' ', -- RUNOPTS
'CHAR(18) OUT', -- PARMS
0, -- RESULT SETS
'D2TFTEST', -- WLM ENV
'M', -- PROGRAM TYPE
'N', -- EXTERNAL SECURITY
'N'); -- COMMIT ON RETURN

I have other stored procedures that are behaving just
fine. The difference is that this is the first
procedure that is passing data back through the LINKAGE
SECTION instead of using the WITH RETURN in a SQL
statement. We are on v5.1 of DB2. Any ideas on
getting this to work? Or should I just bite the
bullet and use Global Temporary Tables?


Dave Schaeffer
IT Database Leader
Bendix CVS
E-Mail: [login to unmask email]



Craig Theisen

Re: Calling a stored procedure question - FOLLOW UP
(in response to Dave Schaeffer)
Not familiar with that exact code, but if it may be the same as 0100E
which equates to SQLCODE:
+464 PROCEDURE proc RETURNED num QUERY RESULT SETS, WHICH EXCEEDS THE
DEFINED LIMIT integer


Craig Theisen
DBA
Guideone Ins.


-----Original Message-----
From: Schaeffer, Dave [mailto:[login to unmask email]
Sent: Friday, November 30, 2001 4:08 PM
To: [login to unmask email]
Subject: Calling a stored procedure question - FOLLOW UP


Thanks to everyone that has offered suggestions.

The error I'm getting now is: CLI0100E

My call looks like: {CALL STO99C (?)}

The LINKAGE SECTION in the program is:
LINKAGE SECTION.
01 REC-OUT PIC X(18).

The SYSPROCEDURE table is setup like:
('STO99C', -- PROCEDURE
' ', -- AUTHID
' ', -- LUNAME
'STO99C', -- LOADMOD
' ', -- LINKAGE
'PACKAGES', -- COLLID
'COBOL ', -- LANGUAGE
0, -- ASUTIME
' ', -- STAYRESIDENT
'N', -- IBMREQD
' ', -- RUNOPTS
'CHAR(18) OUT', -- PARMS
0, -- RESULT SETS
'D2TFTEST', -- WLM ENV
'M', -- PROGRAM TYPE
'N', -- EXTERNAL SECURITY
'N'); -- COMMIT ON RETURN

I have other stored procedures that are behaving just
fine. The difference is that this is the first
procedure that is passing data back through the LINKAGE
SECTION instead of using the WITH RETURN in a SQL
statement. We are on v5.1 of DB2. Any ideas on
getting this to work? Or should I just bite the
bullet and use Global Temporary Tables?


Dave Schaeffer
IT Database Leader
Bendix CVS
E-Mail: [login to unmask email]








Russell Collins

Stored Procedure Question
(in response to Craig Theisen)
I have a working stored procedure sitting on the database. I am having
problems calling the stored procedure using javabeans. If there is any
suggestions or examples of where I can look and find this information, I
would greatly appreciate it. Thank you for your help.