topic Re: Is it possible to pass Talend Routine in a SQL Query? in Talend Studio

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

jtai168 — Sat, 16 Nov 2024 01:52:40 GMT

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,

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

JohnRMK — Mon, 20 Jul 2020 12:25:38 GMT

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")))