SQL Statement Page
Enter the SQL statement parameters. The Run a SQL Statement page is the wizard page that is displayed if you selected SQL statements 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 |
Identifies the SQL query. |
Status |
After you click Validate SQL Query, ensure the Status field displays |