Unable to use the Global map ((String)globalMap.get("row1.column1")) in SQL query

[Anonymous]

Hi Team,

I am not sure what I doing wrong but I am unable to use the ((String)globalMap.get("row1.column1")) variable in SQL query.

Please find the below design in TOS. Also, below is the query used after the tflowToIterate to process the each row from Input.

SELECT
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_CD,
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_YEAR,
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_PERIOD,
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_WORKNG_DAYS,
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_UPDTD_BY,
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_UPDTD_DT,
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_UPDTD_BY_ROLE
FROM VMRCTTA1.VMRRCNTRY_WORKNG_DAYS
where CNTRY_CD= ' ((String)globalMap.get("row1. EXTRT_CNTRY_CD"))'

Please suggest.

[Anonymous]

Sure, I want to use each row from input as table column in Select query .

Like we have already used global variable in the Where clause of query based on our input row iterate over similarly, at the same time I would like to add same global variable as additional column to table.

Example:

IF 1st row of input is like:-

Year Period 

2019  9

Then in Postgresrow component, we will have something like that in Select query but

we are unable to use same Global variable in SELECT query which we used in WHERE clause.

SELECT

<Need to use here Global variable same as in Where clause like '" +((String)globalMap.get("out1.EXTRT_CNTRY_CD")) + ">,

VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_CD,
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_YEAR,
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_PERIOD,
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_WORKNG_DAYS,
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_UPDTD_BY,
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_UPDTD_DT,
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_UPDTD_BY_ROLE
FROM VMRCTTA1.VMRRCNTRY_WORKNG_DAYS
where CNTRY_CD='" +((String)globalMap.get("out1.EXTRT_CNTRY_CD")) + "'
and CNTRY_YEAR= " + ((Integer)globalMap.get("out1.EXTRT_YEAR"))

Please let me know if you need more details, per my previous comment above, the error details are given while using Global variable in Select command.

[Anonymous]

Can someone please update on this.

[Anonymous]

Hi
It is a compilation error, can you show us the schema of output table on tMap1?

Regards
Shong

[Anonymous]

Could you please send here a screenshot (or the whole content) of your database input component query.

We actually do not know what went wrong here because all hints so far are correct.

[Anonymous · Accepted solution]

Thanks for all inputs.

Finally this worked.

"SELECT " + ((String)globalMap.get("out1.EXTRT_CNTRY_CD")) + ",
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_YEAR,
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_PERIOD,
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_WORKNG_DAYS,
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_UPDTD_BY,
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_UPDTD_DT,
VMRCTTA1.VMRRCNTRY_WORKNG_DAYS.CNTRY_UPDTD_BY_ROLE
FROM VMRCTTA1.VMRRCNTRY_WORKNG_DAYS
where CNTRY_CD='" +((String)globalMap.get("out1.EXTRT_CNTRY_CD")) + "'
and CNTRY_YEAR= " + ((Integer)globalMap.get("out1.EXTRT_YEAR"))