topic Re: Context variable in SQL Querry ToracleInput in Talend Studio

Context variable in SQL Querry ToracleInput

Anonymous — Mon, 11 Jun 2012 14:24:20 GMT

Hello,
I want to use parameter into a query for a ToracleInput component.

"SELECT....
FROM ....
WHERE DATECLOTURE <
(CASE WHEN " + context.Periode + "='MOIS_PASSE'
THEN LAST_DAY(ADD_MONTHS(TRUNC(SYSDATE),-1))
ELSE SYSDATE
END)"
i have an error "non valid constant character"..
Thanks for your help..
Louis

Re: Context variable in SQL Querry ToracleInput

Anonymous — Mon, 11 Jun 2012 14:28:18 GMT

Hi Louis,
This is because the conevrted sql statement now contains your context.Periode as a constant. If you change your tOracleInput to the following it should work:

"SELECT....
   FROM ....
   WHERE DATECLOTURE <
            (CASE WHEN '" + context.Periode + "'='MOIS_PASSE' 
                  THEN LAST_DAY(ADD_MONTHS(TRUNC(SYSDATE),-1))
                  ELSE SYSDATE 
             END)"

Regards,
Arno

Re: Context variable in SQL Querry ToracleInput

Anonymous — Mon, 11 Jun 2012 14:57:45 GMT

Thank you Arno !!! it's Ok !!
Regards,
Louis