Run postgresql stored procedure

[Anonymous]

Hi guys!
Could you please help me to figure out if it's possible or not to run a postgresql stored procedure within a Talend Job? And if yes I'll be very grateful for an example.
Thank you a lot in advance!!!

[Anonymous]

Hi,
globalMap is a hashtable which has been declared in Java code.
globalMap.put("key","value"), globalMap.get("key","value").
Best regards
Sabrina

[Anonymous]

thanks really appreciate your support ....
what is PropRow then? and what are the other alternatives of proprow?? if any??
Thanks,
Debashis

[Anonymous]

Hi,
Would you mind giving us your current job design screenshot into forum so that I can get your situation more precisely to see if there is any other alternative solution for your case.
Best regards
Sabrina

[Anonymous]

Here i am attaching the screenshot for my job.
In the component of tpostgresql1 i have mentioned the function query as i have discussed with you earlier.
what is PropRow then? and what are the other alternatives of proprow?? if any??

[Anonymous]

Hi,
It seems the screenshots are missing.
Please click on "post reply" (not through the quick post") and pay more attention on the limitation of Image Upload Box:20 images per post, each image must be less then 1024x768 pixels and 200 KB(.png is preferred).
Best regards
Sabrina

[Anonymous]

hi Sabrina
I am able to complete the job with the requirement.
Now in a second job i want to update one table like
update pricing_group set pricing_group_type='DEBASHIS' where ver_num=10
as you see i am updating the field with all capital letters, now i want to use the system routine
StringHandling.DOWNCASE to make it to lower case.
in my job i am only using a table metadata that's it. How to use the routine for this purpose.

[Anonymous]

Hi sabrina
please treat this one as urgent.
I want to be my database as it is before 10 hours. Is it possible from talend to do so and if it is possible then how to do it.

[_AnonymousUser]

Hi people,
I am new to this and i was making a update procedure, But I am constantly getting syntax error for the set line, and dont know what is wrong. This is the code: 
CREATE FUNCTION update_sba_sales("$IncrementID" numeric, "$EntryID" numeric, "$Soa_selectorID" character varying) RETURNS void AS
$BODY$BEGIN
update sba_sales
set sales_gc= sales_gc*$IncrementID
where entryid=$EntryID 
and soa=$Soa_selectorID;
END;$BODY$
LANGUAGE plpgsql VOLATILE NOT LEAKPROOF;
ALTER FUNCTION public.update_sba_sales(numeric, numeric, character varying)
  OWNER TO mstrwh;
GRANT EXECUTE ON FUNCTION public.update_sba_sales(numeric, numeric, character varying) TO public;

[Anonymous]

You are getting error on Pgsql client or in Talend job? 
Vaibhav

[Anonymous]

Hello guys!
Could you please help me to figure out if it's possible or not to create stored procedure within a Talend Job? and i  am using MySQL server as back end ,in my job i used tsqlscriptparser component is iterated to tmysqlrow component and i fail to create stored procedure in MySQL DB,please help me, I'll be very grateful for an example.
Thank you a lot in advance!!!