Something is weird here... a small test:
$ db2 -td@ -vf inoutsp2.db2
CREATE PROCEDURE inoutsp2
(INOUT str VARCHAR(32) for bit data)
RESULT SETS 0
LANGUAGE SQL
BEGIN
SET str = 'GOOD JOB';
END
DB20000I The SQL command completed successfully.
$ db2 "call inoutsp2('x')"
Value of output parameters
--------------------------
Parameter Name : STR
Parameter Value : x'474F4F44204A4F42'
Return Status = 0
Worked!
Yet when I try to run my SP I get
SQL0469N The parameter mode (IN, OUT, or INOUT) is not valid for a
parameter
in procedure "READ_RECORD" with specific name "READ_RECORD" (parameter
number
"0", name "P1"). SQLSTATE=42886
Quite confused.
"Serge Rielau" <sr*****@ca.eye-be-em.com> wrote in message
news:c1**********@hanover.torolab.ibm.com...
Hmm, the message doesn't make much sense in this context.
I would expect a -469 to appear if you attempted to assign to an IN or
select from an OUT parameter.
You are not doing a dynamic CREATE PROCEDURE in the body by any chance?
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab