Skip to Content
0
Former Member
Jan 18, 2016 at 02:33 PM

SQL TRANSFORM LOSE ALL THEIR SQL CODE ( SQL text)

63 Views

Hi everyone ,

When I started to use different datastore configurations, I discovered another anomaly in dataservices.

When I move my ATL to the live environment and change the datastore configuration (set a new default), then all SQL transforms that are using this datastore will go empty, the SQL text appears blank. Thats really weird(I had to refill all my SQL transforms manually!), can somebody explain it?

The SQL text of the transform is dependent on the configuration. This way you have one kind of SQL statement for e.g. Oracle 11 and another for Oracle 10. Could that be the reason?


I am using Oracle 11 and Oracle 10 ( live environment )


How can I solve it ?

Thanks in advance.

Best Regards

Antonio