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 2: SQL INSERT

A 'myData' RowSet variable contains the following data that will be inserted into a SQL database:

${myData} RowSet Variable
${myData[1]}	${myData[2]}	${myData[3]}	${myData[4]}	${myData[5]}	${myData[6]}
Employee ID	First Name	Last Name	Hire Date	Dept. Code	Salary
34594	Heather	Banks	1998-01-19	BB001	72000
34593	Tina	Young	2010-04-01	BB001	65000
34590	Kathy	Harris	2007-09-30	KH001	105000
34592	Mark	Walker	2012-11-15	KH001	87500
34591	John	Davis	2001-06-15	KH001	85000

Follow the steps below to perform an SQL INSERT statement using data from a RowSet:

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, a '?' is used as a place holder for each Index in the 'myData' RowSet. The 'myData' RowSet contains six columns, therefore six '?' placeholders will be used in the query.

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

Save

button when complete. When the Project is executed, data from the 'myData' RowSet variable will be inserted into the database.

Rename Saved Search

Table of Contents

User Guide

User Guide

Example 2: SQL INSERT

Example 2: SQL INSERT