Is it possible to pass Talend Routine in a SQL Query?

[jtai168]

Hi,

I am wondering if it is possible to pass the value from the Talend Routine as a parameter to my PostgreSQL stored procedure. So the routine I am trying to use is:

"TalendDate.getLastDayOfMonth(TalendDate.addDate(TalendDate.getCurrentDate(),-1,"MM") )".

I need to pass the value into this query:

""CALL <stored procedure>('<date value>')"

Thanks,

J.

[JohnRMK]

Hello,

theoretically it is possible to do it but it is not advised.

Try to have an additional step above with a tSetVarGlobal with the

key = "lastDay ..."

value = TalendDate.getLastDayOfMonth (TalendDate.addDate (TalendDate.getCurrentDate (), - 1, "MM"))

Then, when you call the stored procedure, you're just going to use the global variable

(with a ((datetime)globalMap.get("myKey")))