Reload at each row

[Anonymous]

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

[Anonymous]

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)

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

hai

[Anonymous]

"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

[Anonymous]

but it is showing error at globalmap