problem with DB2 stage
Posted: Thu Feb 17, 2005 10:50 pm
I have the following query in DB2
-------------------------------------------------------------------------------------
COLUMN NAME DATA TYPE LENGTH
--------------------------------------------------------------------------------------
TSS_CUST_ID InTEGER 8
RPS_ACCT_ID_14 InTEGER 16
LMT_VAL DECIMAL 15,2
CLR_BAL DECIAML 15,2
LST_CR_TRAN_DT DATE 10
The values of the date Parameters are as follows
pFUTURETS = 9999-12-31-23.59.59.999999
pFUTEDT = 9999-12-31
SELECT
A3.TSS_CUST_ID,
A1.RPS_ACCT_ID_14,
A4.LMT_VAL,A5.CLR_BAL,
CHAR(A6.LST_CR_TRAN_DT,ISO),
CHAR(A6.LST_DR_TRAN_DT,ISO)
FROM
#pUKDWSCHEMA#.DWH_ARRG_XREF AS A1
INNER JOIN
#pUKDWSCHEMA#.DWH_IP_ARRG_RELN AS A2
ON A1.ARRG_ID=A2.ARRG_ID
INNER JOIN
#pUKDWSCHEMA#.DWH_IP_XREF AS A3
ON A2.IP_ID = A3.IP_ID
INNER JOIN
#pUKDWSCHEMA#.DWH_PRAR_LMT AS A4
ON A1.ARRG_ID=A4.ARRG_ID
INNER JOIN
#pUKDWSCHEMA#.DWH_DLY_ACCT_BAL AS A5
ON A1.ARRG_ID=A5.ARRG_ID
INNER JOIN
#pUKDWSCHEMA#.DWH_ACCT_ARRG AS A6
ON A1.ARRG_ID=A6.ARRG_ID,
#pUKDWSCHEMA#.DWH_DS_CNTL_RUN AS A7
WHERE
A3.TSS_CUST_ID IS NOT NULL
AND
(A1.REC_TS >A7.CNTL_JOB_END_TS
AND
A1.REC_TS <='#pFUTURETS#')
AND
A6.REC_EDT='#pFUTEDT#'
AND
A4.PRAR_LMT_TYCD='1'
This query is working fine in DB2 environment.But in the DS when I am trying to view the data thro' DB2 stage for the same query,It is giving some junk values.Also it is giving some error:Error calling subroutine:DSR_EXECJOb(Action=5).
Please do let me know what is the problem ? Your help would be appreciated ASAP.
-------------------------------------------------------------------------------------
COLUMN NAME DATA TYPE LENGTH
--------------------------------------------------------------------------------------
TSS_CUST_ID InTEGER 8
RPS_ACCT_ID_14 InTEGER 16
LMT_VAL DECIMAL 15,2
CLR_BAL DECIAML 15,2
LST_CR_TRAN_DT DATE 10
The values of the date Parameters are as follows
pFUTURETS = 9999-12-31-23.59.59.999999
pFUTEDT = 9999-12-31
SELECT
A3.TSS_CUST_ID,
A1.RPS_ACCT_ID_14,
A4.LMT_VAL,A5.CLR_BAL,
CHAR(A6.LST_CR_TRAN_DT,ISO),
CHAR(A6.LST_DR_TRAN_DT,ISO)
FROM
#pUKDWSCHEMA#.DWH_ARRG_XREF AS A1
INNER JOIN
#pUKDWSCHEMA#.DWH_IP_ARRG_RELN AS A2
ON A1.ARRG_ID=A2.ARRG_ID
INNER JOIN
#pUKDWSCHEMA#.DWH_IP_XREF AS A3
ON A2.IP_ID = A3.IP_ID
INNER JOIN
#pUKDWSCHEMA#.DWH_PRAR_LMT AS A4
ON A1.ARRG_ID=A4.ARRG_ID
INNER JOIN
#pUKDWSCHEMA#.DWH_DLY_ACCT_BAL AS A5
ON A1.ARRG_ID=A5.ARRG_ID
INNER JOIN
#pUKDWSCHEMA#.DWH_ACCT_ARRG AS A6
ON A1.ARRG_ID=A6.ARRG_ID,
#pUKDWSCHEMA#.DWH_DS_CNTL_RUN AS A7
WHERE
A3.TSS_CUST_ID IS NOT NULL
AND
(A1.REC_TS >A7.CNTL_JOB_END_TS
AND
A1.REC_TS <='#pFUTURETS#')
AND
A6.REC_EDT='#pFUTEDT#'
AND
A4.PRAR_LMT_TYCD='1'
This query is working fine in DB2 environment.But in the DS when I am trying to view the data thro' DB2 stage for the same query,It is giving some junk values.Also it is giving some error:Error calling subroutine:DSR_EXECJOb(Action=5).
Please do let me know what is the problem ? Your help would be appreciated ASAP.