when you call it put {} around the call

so {call sp('x','s')}


Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]




"thirumaran "
<db2udbdba-ezmlms
hield-x72355877.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
11/26/2004 10:25
AM Subject
db2 GET DIAGNOSTICS + STORED
PROCEDURES










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




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



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