All Forums UDA
Diecorp 14 posts Joined 06/12
01 Aug 2012
DataStage TD Connector Stage - Lookup -Stage

Hi,

How can I parametizer a TD Connector Stage when this use a Lookup Stage?

I had the sentence:

SELECT
CRNCY_CDE_ORIG,
SRCE_SYS_CDE,
CRNCY_CDE
   FROM ETLD001.EQL_GPO_CRNCY
  WHERE CRNCY_CDE_ORIG=ORCHESTRATE.CRNCY_CDE
   AND SRCE_SYS_CDE=ORCHESTRATE.SRCE_SYS_CDE
;

The log shows: Object 'ORCHESTRATE' does not exist

I imagine that the TD Connector Stage interpret the word 'ORCHESTRATE' as a DataBase in Teradata.

I tryed with the next options, but none the them work. Please anyone knows the right way?:

SELECT
CRNCY_CDE_ORIG,
SRCE_SYS_CDE,
CRNCY_CDE
   FROM ETLD001.EQL_GPO_CRNCY
  WHERE CRNCY_CDE_ORIG=:CRNCY_CDE
   AND SRCE_SYS_CDE=:SRCE_SYS_CDE

USING CRNCY_CDE(SMALLINT), SRCE_SYS_CDE(CHAR(6))

SELECT
CRNCY_CDE_ORIG,
SRCE_SYS_CDE,
CRNCY_CDE
   FROM ETLD001.EQL_GPO_CRNCY
  WHERE CRNCY_CDE_ORIG=:CRNCY_CDE
   AND SRCE_SYS_CDE=:SRCE_SYS_CDE

 SELECT
CRNCY_CDE_ORIG,
SRCE_SYS_CDE,
CRNCY_CDE
   FROM ETLD001.EQL_GPO_CRNCY
  WHERE CRNCY_CDE_ORIG=?
   AND SRCE_SYS_CDE=?

You must sign in to leave a comment.