Hi all,
I am doing sparse lookup in my job with 6 key fields with db2 database.
I gave the lookup query like this
SELECT
INTRACT_KEY_MAP_ID,CSS_FLD_ORGAN_ID,CSS_CLL_DT,CSS_CLL_TM,CSS_CLL_MICRO_SEC,CSS_PROV_ID_CLLR,CSS_PROV_ID_SEQ_CLLR,CCA_CNTCT_ID,CCA_INTRACT_NUM,CCA_REQSTR_INTRACT_CNTCT_ID,ERR_CNT,WARN_CNT
FROM
#$DMSYNC_SCH_NAME#.INTRACT_KEY_MAPNG
WHERE
CSS_FLD_ORGAN_ID= ORCHESTRATE.FLD_ORGAN_ID And
CSS_CLL_DT=ORCHESTRATE.CLL_DT And
CSS_CLL_TM=ORCHESTRATE.CLL_TM And
CSS_CLL_MICRO_SEC=ORCHESTRATE.CLL_MICRO_SEC And
CSS_PROV_ID_CLLR=ORCHESTRATE.PROV_ID_CLLR And
CSS_PROV_ID_SEQ_CLLR=ORCHESTRATE.PROV_ID_SEQ_CLLR
even though i am having matching records in the source and the reference table ,lookup is failing ,but the same thing is working with normal lookup.
can't we use more than on key column in the sparse lookup
if any one knows please help me
Thanks for your help
Sparse lookup with more than one key field
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 48
- Joined: Fri Feb 29, 2008 1:09 am
- Location: Bangalore
Sparse lookup with more than one key field
Thanks&Regards
S.Swathi
S.Swathi