User Guide

10.4.0
- 10.5.3
- 10.5.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Example 3: SQL INSERT Using Query Parameters

In the previous example, the entire 'myData' RowSet variable was inserted into a SQL database. On some occasions, you may only want to add selected columns from the RowSet variable into the database. To add specific columns, you must use a Parameter element for each column you wish to insert.

Follow the steps below to insert columns one and six from the 'myData' RowSet variable into the database.

From within the Project Designer page, expand the Database folder in the Component Library, and then drag the SQL task to the Project Outline.

On the Basic tab of the SQL task, select the database server resource from the drop-down list. If not already defined, click the

Create

button to define a new database server resource.

Click the

Add

button to Add a Query to the SQL task.

Type in your SQL Insert Statement on the page. In this example, only two placeholder '?' are used for the Indexes referenced in the 'myData' RowSet.

Specify the RowSet variable name '${myData}' into the Input RowSet Variable field. The specified SQL Statement will be executed once per each row in this RowSet.

Click the

Add

button to Add a Parameter to the SQL query.

Enter '1' in the Parameter Index field. The '1' represents the first '?' placeholder position in the SQL Statement.

Enter '1' in the Map From field. This inserts data from column 1 of the 'myData' RowSet variable into the first column of the database.

Click the

Add

button and choose Add Same to add another Parameter to the SQL query.

Enter '2' in the Parameter Index field. The '2' represents the second '?' placeholder in the SQL Statement.

Enter '6' in the Map From field. This inserts data from column 6 of the 'myData' RowSet variable into the database.

Click the

Save

button when complete. When the Project is executed, data from columns 1 and 6 from the 'myData' RowSet variable are inserted into the SQL Database.

The following image illustrates the Project Outline for the SQL Query INSERT task which uses two Query Parameter elements:

Rename Saved Search

Table of Contents

User Guide

User Guide

Example 3: SQL INSERT Using Query Parameters

Example 3: SQL INSERT Using Query Parameters