Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Data Integration SQL queries are not validating anymore — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Integration SQL queries are not validating anymore

Received Response
11
Views
1
Comments

Summary:

Data Integration queries are not validating anymore

Content (required):

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!