BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: BI & HANA 2018 Prague: Jun 29.

use global variables in sql transform of Data services 4.2


 
Search this topic... | Search DI: SAP-specific ERP/BW... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: SAP-specific ERP/BW  Previous TopicPrint TopicNext Topic
Author Message
denysl
Forum Member
Forum Member



Joined: 07 Jun 2018

Posts: 1



PostPosted: Thu Jun 07, 2018 9:05 am 
Post subject: use global variables in sql transform of Data services 4.2

Hello good afternoon, you can use global variables in "sql transform dataservices 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:

select * from TABLE where field = {$ variable_global}

I have tried in these ways:
1) select * from TABLE where field = {$ variable_global}
2) select * from TABLE where field = [$ 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 = [BOBJ: $ variable_global]

and of all of them 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 very much..
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: SAP-specific ERP/BW  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0104 seconds using 17 queries. (SQL 0.0023 Parse 0.0002 Other 0.0078)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo