Question Re: unable to update the schema with SQL transform in Data Services 4.2 in Technology Q&A

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

former_member451049 — Wed, 24 May 2017 13:35:23 GMT

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

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

Former Member — Tue, 13 Jun 2017 14:30:15 GMT

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!

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

former_member451049 — Tue, 22 Aug 2017 13:39:06 GMT

its resolved

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

Former Member — Thu, 07 Jun 2018 12:07:38 GMT

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