https://community.qlik.com/t5/Talend-Studio/using-global-map-in-sql-query/m-p/2361126#M125558 <P>Hello,<BR />I am trying to use a&nbsp; global variable defined in a tJavaFlex in a SQL query in the tNetezaInput. However, I am not able to retrieve schema every time I click on&nbsp;"guess schema" in the tNetezzaInput component after writing my query&nbsp;(see job and error in screenshot attached).<BR />Just for information, I was able to run a similar job with another query in which I use global variables and the job runs without any problem. Could you please help ? I am really blocked on this issue and I can't find any solution. I don't get what I am doing wrong.<BR />Thanks in advance.</P> Fri, 31 Mar 2017 10:59:40 GMT Anonymous 2017-03-31T10:59:40Z https://community.qlik.com/t5/Talend-Studio/using-global-map-in-sql-query/m-p/2361126#M125558 <P>Hello,<BR />I am trying to use a&nbsp; global variable defined in a tJavaFlex in a SQL query in the tNetezaInput. However, I am not able to retrieve schema every time I click on&nbsp;"guess schema" in the tNetezzaInput component after writing my query&nbsp;(see job and error in screenshot attached).<BR />Just for information, I was able to run a similar job with another query in which I use global variables and the job runs without any problem. Could you please help ? I am really blocked on this issue and I can't find any solution. I don't get what I am doing wrong.<BR />Thanks in advance.</P> Fri, 31 Mar 2017 10:59:40 GMT https://community.qlik.com/t5/Talend-Studio/using-global-map-in-sql-query/m-p/2361126#M125558 Anonymous 2017-03-31T10:59:40Z https://community.qlik.com/t5/Talend-Studio/using-global-map-in-sql-query/m-p/2361127#M125559 I am not able to see any attachments.&nbsp; Are you trying to use this global variable in the WHERE clause of your input component? <BR /> <BR />Thanks, <BR />Scott Fri, 31 Mar 2017 20:24:25 GMT https://community.qlik.com/t5/Talend-Studio/using-global-map-in-sql-query/m-p/2361127#M125559 TXAggie00 2017-03-31T20:24:25Z