How to input null parameter for stored procedure

bbfung · #1 (**permalink**) 01-07-04, 14:27

Here is my store procedure:
CREATE PROCEDURE mysp
(
IN piRptCode VARCHAR(5),
IN piFilter VARCHAR(100),
OUT poMthFilter VARCHAR(10000),
OUT poPortFilter VARCHAR(10000),
OUT poType1 VARCHAR(100),
OUT poType2 VARCHAR(100),
OUT poCondition1 VARCHAR(100)
)
LANGUAGE SQL

How can I call my store procedure from the command line with piFilter as null?
I have tried
db2 call mysp('L005',,?,?,?,?,?)
or
db2 call mysp('L005','',?,?,?,?,?)
but both calls give me SQL0104N
db2 call mysp('L005',' ',?,?,?,?,?)
This works fine.

Thx in advance.

nidm · #2 (**permalink**) 01-07-04, 16:33

could you please try:
db2 call mysp('L005',NULL,?,?,?,?,?)

Quote:

Originally posted by bbfung
Here is my store procedure:
CREATE PROCEDURE mysp
(
IN piRptCode VARCHAR(5),
IN piFilter VARCHAR(100),
OUT poMthFilter VARCHAR(10000),
OUT poPortFilter VARCHAR(10000),
OUT poType1 VARCHAR(100),
OUT poType2 VARCHAR(100),
OUT poCondition1 VARCHAR(100)
)
LANGUAGE SQL

How can I call my store procedure from the command line with piFilter as null?
I have tried
db2 call mysp('L005',,?,?,?,?,?)
or
db2 call mysp('L005','',?,?,?,?,?)
but both calls give me SQL0104N
db2 call mysp('L005',' ',?,?,?,?,?)
This works fine.

Thx in advance.

bbfung · #3 (**permalink**) 01-07-04, 16:40

It works. thx.

Internet Services

Web Development

Digital Marketing

Consumer Tech