topic Re: Reload at each row in Talend Studio

Reload at each row

Anonymous — Fri, 05 Aug 2016 08:11:20 GMT

Whether reload at each row supports for postgresql.It is showing sysntax error at globalMap.get()

Re: Reload at each row

Anonymous — Fri, 05 Aug 2016 10:39:10 GMT

Reload each row is an option of the tMap. It has nothing to do with PostgreSQL and works with every lookup.
The call to the globalMap are always Java code. To be able to help you you must show us the code which fails or the job design including the settings of the affected components.
A call to the globalMap should looks like this:
globalMap.get("your_key_as_string")
or
globalMap.put("your_key_as_string", anyvalue)

Re: Reload at each row

Anonymous — Fri, 05 Aug 2016 11:16:18 GMT

select xyz from abc
where "xyz"."id"='' + (String)globalMap.get("ID")
here it is saying that syntax erro at or near by global map

Re: Reload at each row

Anonymous — Fri, 05 Aug 2016 11:19:31 GMT

It must be:
where \"xyz\".\"id\"=" + (String)globalMap.get("ID")

Re: Reload at each row

Anonymous — Fri, 05 Aug 2016 11:58:30 GMT

I tried with same but is showing the error.Can you plaese expalin with example using load at each row using tPostgreSqlInput

Re: Reload at each row

Anonymous — Fri, 05 Aug 2016 12:03:10 GMT

It is simple impossible after applying my suggestion to get the same error. If you want help, show the real error messages and the component configuration.

Re: Reload at each row

Anonymous — Fri, 05 Aug 2016 13:52:28 GMT

hai

Re: Reload at each row

Anonymous — Fri, 05 Aug 2016 13:53:48 GMT

Re: Reload at each row

Anonymous — Mon, 08 Aug 2016 07:30:41 GMT

"SELECT \"OSD_SURG_ID\",\"OSD_SURG_START_DT_TIME\",\"OSD_SURG_END_DT_TIME\",\"OSD_CRT_DT\",\"OSD_CRT_UID\",\"OSD_UPD_DT\", \"OSD_UPD_UID\", \"OSD_MR_NUM\", \"OSD_AUTH_UID\", \"OSD_AUTH_DT\"
FROM\"OT_SURGERY_DETAILS\" where \"OSD_MR_NUM\"='' + (String)globalMap.get(\"row1.OAD_MR_NUM\")"

this is my syntax

Re: Reload at each row

Anonymous — Mon, 08 Aug 2016 07:56:01 GMT

but it is showing error at globalmap

Re: Reload at each row

Anonymous — Mon, 08 Aug 2016 08:08:41 GMT

Hi,
for me, your query should be :
"SELECT OSD_SURG_ID,OSD_SURG_START_DT_TIME,OSD_SURG_END_DT_TIME,OSD_CRT_DT,OSD_CRT_UID,OSD_UPD_DT, OSD_UPD_UID, OSD_MR_NUM, OSD_AUTH_UID, OSD_AUTH_DT
FROM OT_SURGERY_DETAILS where OSD_MR_NUM = '"+ (String)globalMap.get("row1.OAD_MR_NUM") +"'"

or "+ (String)globalMap.get("row1.OAD_MR_NUM") if it's a number

Assuming that row1.OAD_MR_NUM is the variable that comes from tMap as i explain it here

Re: Reload at each row

Anonymous — Tue, 09 Aug 2016 09:58:40 GMT

hai
It is working but the data is not validating means it showing as zero rows while reload at each row

Re: Reload at each row

Anonymous — Tue, 09 Aug 2016 10:27:21 GMT

All database input components provides a return value QUERY . Checkout the Outline view. This return value contains the actual fired statement and here you will find the problem.