MQSeries.net :: View topic - Problem retrieving Decimal values from DB on calling SP

djeripo · Posted: Fri Jun 18, 2004 7:01 am Post subject:

Hi,
I have a problem retrieving 'Decimal' values from the database on calling a stored procedure . I am using DestinationList to route input messages to multiple Queues from compute node.

In my ComputeNode under 'Advanced' tab 'Compute Mode' is set to 'All'.(I Even tried setting 'Compute Mode' to 'LocalEnvironment and Message')
Under output node 'DetinationMode' is set to 'DestinationList'.

I could retrieve all other Char,Integer fields except these Decimal fields .
I checked with the DB admin to check whether he has any problem retrieving Decimal values from his StoreProcedure builder for the key value.For him he could get everything .

For confirmation,
I tried printing those in Environment tree
SET Environment.Variables.RISK_FACTOR = UT2_ADD_RSK_FTR_515;
As the value was not retrieved RISK_FACTOR did not show up in the tree.

The SP I was calling was ,

CALL CTP1030 ( POLICY_NUMBER,CO_CMPY_CDE_515,HA1_POL_COV_PLN_515,
UT2_COV_SEQ_NUM_515,UT2_RATEBOOK_CD_515,
UT2_FACE_AMT_515,POL_FRM_RDR_CD_515,
PG_EFF_DTE_515,PG_RMOV_DTE_515,UP1_VALN_GRP_CD_515,
UP1_PLAN_CDE_NM_515,UT2_ADD_RSK_FTR_515,
UT2_EXTA_BSC_PM_515,T1_ADMIN_SYS_CD_515,
UT2_SUBCLASS_PC_515, RETURN_CDE_515,
MESSAGE_515);

CREATE PROCEDURE CTP1030 (
IN IC_AR_POL_ACCT_NUM CHAR,
OUT OC_CO_CMPY_CDE CHAR,
OUT OC_HA1_POL_COV_PLN CHAR,
OUT OI_UT2_COV_SEQ_NUM INT,
OUT OC_UT2_RATEBOOK_CD CHAR,
OUT OD_UT2_FACE_AMT DECIMAL,
OUT OC_POL_FRM_RDR_CD CHAR,
OUT OC_PG_EFF_DTE CHAR,
OUT OC_PG_RMOV_DTE CHAR,
OUT OC_UP1_VALN_GRP_CD CHAR,
OUT OC_UP1_PLAN_CDE_NM CHAR,
OUT OD_UT2_ADD_RSK_FTR DECIMAL,
OUT OD_UT2_EXTA_BSC_PM DECIMAL,
OUT OC_T1_ADMIN_SYS_CD CHAR,
OUT OI_UT2_SUBCLASS_PC INT,
OUT OI_RETURN_CDE INT,
OUT OC_MESSAGE CHAR

) EXTERNAL NAME "PCTP001.CTP1030";

I am running on WMQI2.1 CSD6

Any pointers would be appreciated
Thanks