Skip to Content
0
Jun 07, 2018 at 04:42 AM

I can use global variables in "sql transform data services 4.2"?

543 Views

hello good afternoon, you can use global variables in "sql transform data services 4.2" because I have already tried brackets, keys, parentheses .. if nothing and I do not recognize the global variable, I want to do this:

1) select * from TABLE where field = {$ variable_global}

2) select * from TABLE where campo =[BOBJ:$variable_global]

3) select * from TABLE where field = [$ variable_global]

4) select * from TABLE where field = '[$ variable_global]'

5) select * from TABLE where field = $ variable_global

6) select * from TABLE where field = variable_global

7) select * from TABLE where field = ($ variable_global)


and what I get is the error odbc data source error operation -BODI1130199, Help please.

I just want to know if you can use the global variables or not, what else can I do to pass the value of a variable?

Thank you..