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

[#1]

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

[Former Member]

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

[former_member451049]

its resolved

[Former Member]

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!