[FAQ000142]When saving an action set using an SQL action, the message "SQL is incorrect." appears

Q

When I enter a SQL statement in a SQL action and try to save the action set,

I get the error message "SQL is incorrect." and I cannot save it.

What are the possible causes?

A

"CELF SQL Action" can only use SQL that conforms to the SQL standard

This error message will be displayed when a SQL statement that does not conform to SQL standard is entered.

For example, the following is possible.

・Some RDBMS-specific syntaxes are used, such as Oracle and DB2

・Table names and column names contain characters such as "$" that cannot be used in SQL standard

・Functions with names that overlap with SQL standard reserved words, such as LEFT and RIGHT functions, are being used