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.

[manodwhb]

@rohitatcs ,where you have row1 connection in your job screenshot?

[TRF]

Should be:

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

[Anonymous]

Sorry I am new in this.So, I think it should be row7 instead row1 right as row7 is there on link.
Please confirm.

[TRF]

((String)globalMap.get("out1. EXTRT_CNTRY_CD"))
as out1 is the input flow for the tFlowToIterate component

[manodwhb]

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= out1.EXTRT_CNTRY_CD

[Anonymous]

Thank you guys.

Here, is the solution for this.

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("out1.EXTRT_CNTRY_CD")) + "'
and CNTRY_YEAR= " + ((Integer)globalMap.get("out1.EXTRT_YEAR"))

@TRF @manodwhb - can you guys suggest, how can we use these same global variable in Select query. We are now facing issue in this as compile error.

[TRF]

It seems that the variable "out1.EXTRT_YEAR" is declared as String not Integer

[Anonymous]

So can u suggest how to use same Global Variable in Select query.

Means, same in Where clause filter as well as in Select query.

[TRF]

Can you give some more details?