Invoke SQL Statement Page

Enter the SQL statement properties.

Note:

• Do not use schema/database names in SQL queries. Configure the details in the connection. For example:

  Update HR.employee set HR.employee.first_name = 'Name' where HR.employee.employee_id='1' 

  can be changed to a simple query, such as:

  Update employee set first_name = 'Name' where employee_id='1' 

  where HR is used in the connection details. This restricts a user with specific privileges to a particular schema/database.

• When configuring the adapter as an invoke connection, ensure that proper spaces are provided between key words for a pure SQL statement. For example, the following statement fails during integration activation because there is no blank space between VALUES and (#.

  INSERT INTO table_name VALUES(#EMPNO, #EMPNAME) 

  Add a blank space between VALUES and (#, and the statement is successfully processed.

  INSERT INTO table_name VALUES (#EMPNO, #EMPNAME) 

Element	Description
SQL Query	Identifies the SQL query.
Validate SQL Query	Validates the SQL query syntax.
Status	Displays the SQL query syntax validation status. When syntax validation is successful, the message Success! appears.