5.1

Table Of Contents

5 Type an SQL create statement.

An example syntax is:

CREATE TABLE "table_name"

("column1" "data_type_for_column1",

"column2" "data_type_for_column2")

6 Click Submit to run the workflow.

Insert a Row into a JDBC Table

You can run a workflow from the Orchestrator client to test the insertion of a row into a JDBC table.

Prerequisites

Procedure

1 Click the Workflows view in the Orchestrator client.

2 In the workflows hierarchical list, open Library > JDBC > JDBC Examples to navigate to the JDBC insert

into table example workflow.

3 Right-click the JDBC insert into table example workflow and select Start workflow.

4 Provide the required information, and click Next.

a Type a database connection URL.

b Type a user name to access the database.

c Type a password to access the database.

5 Type an SQL insert statement, and click Next.

An example syntax is:

INSERT INTO "

table_name

" ("column1", "column2")

VALUES ("value1", "value2")

6 Type the values to insert into the row.

7 Click Submit to run the workflow.

Select Rows from a JDBC Table

You can run a workflow from the Orchestrator client to select rows from a JDBC table.

Prerequisites

Procedure

1 Click the Workflows view in the Orchestrator client.

2 In the workflows hierarchical list, open Library > JDBC > JDBC Examples to navigate to the JDBC select

from table example workflow.

3 Right-click the JDBC select from table example workflow and select Start workflow.

Chapter 4 Using the SQL Plug-In

VMware, Inc. 39