Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
jcpreaux
Contributor II
Contributor II

Variables, globalmap and built job

Hello,

I've a job in which i use a tJava component to produce variables whom i put in globalmap.

tJava :
String moisPrec = TalendDate.formatDate("yyyyMM", TalendDate.addDate(TalendDate.getCurrentDate(), -1, "MM"));
globalMap.put("moisPrec",moisPrec);
...
And i get it in a sql query (tmysqlinput) :
"SELECT * FROM mytable
 WHERE field = "+((String)globalMap.get("moisPrec"))+ " AND ..."
My trouble is when i launch the job from the studio the value of "moisPrec" is well resolved but when i launch the job from the standalone bult job (.bat), the value is "null".
(The snapshot below show the tJava and the tMysqlInput.)
I don't know where is my mistake, any help welcome.

Thanks

JCPreaux

Labels (2)
2 Replies
Anonymous
Not applicable

Hi,
We can't see the screenshot on our side. Could you attach it on the forum, please? That would be great.
Best regards
Sabrina
jcpreaux
Contributor II
Contributor II
Author

With the screenshot...
0683p000009MGAD.png