Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

using global map in sql query

Hello,
I am trying to use a  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 "guess schema" in the tNetezzaInput component after writing my query (see job and error in screenshot attached).
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.
Thanks in advance.

Labels (2)
1 Reply
TXAggie00
Contributor III
Contributor III

I am not able to see any attachments.  Are you trying to use this global variable in the WHERE clause of your input component?

Thanks,
Scott