While am trying to insert into stage table am getting this error, not able to figure out which column and which record is giving this error.

Error Msg:
/opt/scripts/prod/Load_SQL_ECOM_SES_REFL_W_Table.sql
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0420N Invalid character found in a character string argument of the
function "DECFLOAT". SQLSTATE=22018 : DB command output


SQL code:
INSERT INTO ADW.ECOM_SES_REFL_W
(CKIE_SEQ_I,
SES_STRT_TS,
SES_RPT_D,
LNK_I,
REFL_ECOM_BROW_KYWD_I,
REFL_TS,
GST_ENTR_ECOM_BROW_KYWD_I,
REFL_SRC_N,
REFL_KYWD_REF_I,
CMPN_N,
CMPN_REF_N,
AD_GRP_N,
PAID_SRCH_F,
NAT_SRCH_F,
MTCH_TYPE_C,
PMTN_C,
FIND_FNCT_Q,
GOOGLE_AD_CLIK_Q,
CPN_PRTL_CLIK_Q,
EMAIL_SGN_UP_Q,
RGST_SGN_UP_Q,
CLBWD_RGST_SGN_UP_Q,
BABY_RGST_SGN_UP_Q,
WK_AD_VIEW_Q,
OFR_DESC_T,
TGT_LIST_RGST_SGN_UP_Q,
SGL_WBPGE_VIST_F,
REFL_PROF_I,
REC_STAT_C,
CRTE_TS,
UPDT_TS)
SELECT CKIE.CKIE_SEQ_I AS CKIE_SEQ_I,
ECOM.SESSIONSTART_TS AS SES_STRT_TS,
ECOM.DAY AS SES_RPT_D,
ECOM.LID AS LNK_I,
KYWDE.ECOM_BROW_KYWD_I AS REFL_ECOM_BROW_KYWD_I,
ECOM.INSTANCETIMESTAMP AS REFL_TS,
KYWDS.ECOM_BROW_KYWD_I AS GST_ENTR_ECOM_BROW_KYWD_I,
ECOM.AFID AS REFL_SRC_N,
( CASE
WHEN Instr(ECOM.LID, 'p') = 0 OR TRIM(Translate(Substr(ECOM.LID, Instr(ECOM.LID, 'p') + 1),
' ','+-E.0123456789')) > ' ' OR ECOM.LID = '' THEN -1
ELSE Substr(ECOM.LID, Instr(ECOM.LID, 'p') + 1)
END ) AS REFL_KYWD_REF_I,
ECOM.CAMPAIGN AS CMPN_N,
ECOM.REFMARKER AS CMPN_REF_N,
ECOM.ADGROUP AS AD_GRP_N,
ECOM.PAIDSEARCHFLAG AS PAID_SRCH_F,
ECOM.NATURALSEARCHFLAG AS NAT_SRCH_F,
ECOM.MATCHTYPE AS MTCH_TYPE_C,
ECOM.PROMOCODE AS PMTN_C,
ECOM.FIATSCLICKS AS FIND_FNCT_Q,
ECOM.GOOGLEADCLICKS AS GOOGLE_AD_CLIK_Q,
ECOM.COUPONPORTALCLICKS AS CPN_PRTL_CLIK_Q,
ECOM.EMAILSIGNUPS AS EMAIL_SGN_UP_Q,
ECOM.REGISTRYSIGNUPS AS RGST_SGN_UP_Q,
ECOM.CLUBWEDDREGISTRYSIGNUPS AS CLBWD_RGST_SGN_UP_Q,
ECOM.BABYREGISTRYSIGNUPS AS BABY_RGST_SGN_UP_Q,
ECOM.WEEKLYADVIEWS AS WK_AD_VIEW_Q,
ECOM.ADTEXT AS OFR_DESC_T,
ECOM.TARGETLISTSREGISTRYSIGNUPS AS TGT_LIST_RGST_SGN_UP_Q,
ECOM.BOUNCEACTIVITYFLAG AS SGL_WBPGE_VIST_F,
( CASE
WHEN Instr(ECOM.LID, 'p') = 0
OR TRIM(Translate(LEFT(Substr(ECOM.LID, 1, Instr(ECOM.LID, 'p')
),
LENGTH(Substr(ECOM.LID, 1,Instr(ECOM.LID, 'p')))- 1),
' ', '+-E.0123456789')) > ' ' OR ECOM.LID = '' THEN NULL
ELSE LEFT(Substr(ECOM.LID, 1, Instr(ECOM.LID, 'p')), LENGTH(
Substr(ECOM.LID, 1, Instr(ECOM.LID, 'p'))) - 1) END ) AS REFL_PROF_I,
'A' AS REC_STAT_C,
CURRENT TIMESTAMP AS CRTE_TS,
CURRENT TIMESTAMP AS UPDT_TS
FROM ADW.EXTL_BROW_REFL_E ECOM
INNER JOIN ADW.ECOM_CKIE_SRC_KEY_LKUP CKIE
ON ECOM.TRACKINGIDSESSION = CKIE.TRAK_ID_SES_I
INNER JOIN ADW.ECOM_KYWD KYWDE
ON ECOM.LNM = KYWDE.KYWD_T
INNER JOIN ADW.ECOM_KYWD KYWDS
ON ECOM.SEARCHPHRASE = KYWDS.KYWD_T
WITH UR