Design

Back Next

Configuring multiple SQL queries

Perform the following steps to add and edit SQL queries:

On the

SQL Binding

tab, click the

icon to add an SQL entry.

An SQL entry is added to the table.

Click the

Edit

icon to edit the SQL query.

The

Create SQL

page appears. The following image shows the

Create SQL

page where you can configure multiple SQL queries:

In the

Create SQL

page, configure the SQL query properties such as the SQL name, SQL query, column case of the query, query type, maximum rows, and maximum wait time.

You can use SQL queries to perform various data manipulation operations such as SELECT, INSERT, DELETE, and UPDATE. You can parameterize an input field in an SQL query. Use the following syntax to parameterize an input field at run time:

'{$<input_field_name>}'

For example, if empId is the name of an input field, enter the following SQL query to parameterize the empId field:

select * from employee.contact where id = '{$empid}'

Click

Create

Defining Actions

Download Guide

Watch

Comments

Cloud Application Integration Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Design

Design

Configuring multiple SQL queries

Configuring multiple SQL queries