Skip to Content
0

unable to update the schema with SQL transform in Data Services 4.2

May 24, 2017 at 01:35 PM

246

avatar image
Former Member

Hi All,

I implemented one complex query it includes joins,cast ,replace and few more filter conditions. the same query i am able to execute from hana data base.

When i am trying to use with SQL transform in Data services schema is not updating and i am getting the error odbc data source error operation -BODI1130199 and i am able to see the all the tables existing and imported in data store ,am able to view the data in that tables

Kindly suggest me the possible alternative solutions

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Jun 13, 2017 at 02:30 PM
0

Hello Chandra.

Are you sure that you are not using variables into query.

I have been in a similiar situation and I accidentally changued the datastore or database, even I left global variables.

Check it and let us know!

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 22, 2017 at 01:39 PM
0

its resolved

Share
10 |10000 characters needed characters left characters exceeded
Denys Lopez Jun 07 at 12:07 PM
0

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} 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..

Share
10 |10000 characters needed characters left characters exceeded