Data Integration SQL queries are not validating anymore
Data Integration queries are not validating anymore
In Data Integration, when I try to insert or update a SQL query that previously validated, now it is not validating anymore. There were no changes to the query. To test it, I just added a space character, and it says that the query is invalid. But it was valid in the previous PBCS version.
In PBCS, to change a SQL query, I go to:
Application -> Data Exchange -> Actions -> Query
The query is valid only when I remove SQL commands like DROP and CREATE.
But before, the query was validating using these commands.