Invoke SQL Statement Properties
Enter the SQL statement parameters. The Create a SQL Statement page is the wizard page that is displayed if you selected Run a SQL Statement as the operation type on the Basic Info page.
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:
whereUpdate employee set first_name = 'Name' where employee_id='1'
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 |
Enter a SQL query. |
Status |
Display the results of the SQL query validation. The Status field displays |