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: PGHBOUG: Oct 19.

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
Shazin
Principal Member
Principal Member



Joined: 19 Jul 2011

Posts: 284
Location: India


flag
PostPosted: Wed Jun 27, 2018 10:45 pm 
Post subject: Re: use global variables in sql transform of Data services 4

You can use global variable in SQL transform but from what I can see you have a space between $ and variable name which is not allowed.

The below script should work:

select column1, column2, ..., column3 from TABLE where field = {$variable_global} (if global variable is a alphanumeric)

select column1, column2, ..., column3 from TABLE where field = [$variable_global] (if global variable is a numeric)

Regards. S
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.0297 seconds using 17 queries. (SQL 0.0026 Parse 0.0009 Other 0.0263)
CCBot/2.0 (https://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