DataStage TD Connector Stage - Lookup -Stage

UDA
Teradata Employee

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=?