hi,
I have used teradata connnector as a lookup. I want to give the below used defined sql query in the SELECT clause.
pRUN_STRM_PROS_D=20100101
SELECT PRTY,MSGE_PRTY_C FROM MAP_CSE_MSGE_PRTY_BM WHERE CAST('#pRUN_STRM_PROS_D#' as date format 'yyyymmdd') BETWEEN EFFT_D (date, format 'yyyymmdd') AND EXPY_D (date, format 'yyyymmdd');
Please help me out.
teradata connector stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I don't think what you're trying to do (BETWEEN) is possible - when you use a Lookup stage DataStage pre-loads the entire reference data set into memory and performs "=" (or range) comparisons against that.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
i have given below query inside the teradata connector stage.
SELECT MAP_CSE_MSGE_PRTY_BM.PRTY,MAP_CSE_MSGE_PRTY_BM.MSGE_PRTY_C FROM
#pGDW_TECH_DB#.MAP_CSE_MSGE_PRTY_BM as MAP_CSE_MSGE_PRTY_BM
WHERE CAST('#pRUN_STRM_PROS_D#' as date format 'yyyymmdd')
BETWEEN MAP_CSE_MSGE_PRTY_BM.EFFT_D (date, format 'yyyymmdd') AND MAP_CSE_MSGE_PRTY_BM.EXPY_D (date, format 'yyyymmdd');
My jobs is running fine. I am getting the results what I expected.
But inside the stage it is showing below warning.
expecting : A conditon expression.
it is showing warning symbol. In the log there is no warning messages.
Can you please let me know why it is showing warning in the stage instead of datastage log. Is there any problem once code is moved to produciton?
SELECT MAP_CSE_MSGE_PRTY_BM.PRTY,MAP_CSE_MSGE_PRTY_BM.MSGE_PRTY_C FROM
#pGDW_TECH_DB#.MAP_CSE_MSGE_PRTY_BM as MAP_CSE_MSGE_PRTY_BM
WHERE CAST('#pRUN_STRM_PROS_D#' as date format 'yyyymmdd')
BETWEEN MAP_CSE_MSGE_PRTY_BM.EFFT_D (date, format 'yyyymmdd') AND MAP_CSE_MSGE_PRTY_BM.EXPY_D (date, format 'yyyymmdd');
My jobs is running fine. I am getting the results what I expected.
But inside the stage it is showing below warning.
expecting : A conditon expression.
it is showing warning symbol. In the log there is no warning messages.
Can you please let me know why it is showing warning in the stage instead of datastage log. Is there any problem once code is moved to produciton?