Hi,

DB2 UDB V 8.1 (windows 2k)

I am facing this issue in a stored procedure

1)

CALL ndat.los_lyr_sp(10);

GET DIAGNOSTICS v_ret_status = RETURN_STATUS;

If am getting -3 as return status i.e the value in v_ret_status = -3

I searched web and documentation could not find .As per DB2 documentation
return status can be 0 or 1 only.
what does return status -3 indicate when using GET DIAGNOSTICS


2)

I am able to compile & run a procedure succesfully in db2 command
center,procedural builder when i call the procedure through a DOT NET
APPLICATIONS it raises the following error.


"[DB2/NT] SQL0444N Routine \"*river_sp\" (specific name
\"SQL041126150036100\") is implemented with code in library or path
\"...er_sp\", function \"ndat.nlp_cln_drv_sp\" which cannot be accessed.
Reason code: \"4\". SQLSTATE=42724"

The above error occurs only when i call the SP through the DOT NET
APPLICATIONS. The SP in dot net is run with the same user as in DB2 .
is there any restrictins in dot net while calling a db2 sp with 6 parameters

NDAT.nlp_cln_drv_sp parameters

IN v_from_o_num_id INT,
IN tmp_v_from_pln_lst VARCHAR(100),
IN v_clne_lvl_i CHAR(6),
IN tmp_v_dest_o_num_id INT,
IN v_pin_id CHAR(8),
INOUT v_dest_o_num_id INT )


Thanks In adv
thirumaran



DB2 & UDB email list listserv db2-l LazyDBA home page