5.5.1

4 Provide the required information, and click Next.
a Type the first name of the user entry to be deleted.
b Type a user name to access the database.
c Type a JDBC connection URL.
d Type the last name of the user entry to be deleted.
e Type a password to access the database.
5 Type an SQL delete statement.
An example syntax is:
DELETE FROM "table_name" where ("column1" = ?, "column2" = ?)
6 Click Submit to run the workflow.
Delete All Entries from a JDBC Table
You can run a workflow from the Orchestrator client to delete all entries from a JDBC table.
Prerequisites
Log in to the Orchestrator client as a user who can run JDBC workflows.
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
delete all from table example workflow.
3 Right-click the JDBC delete all from 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 delete statement.
An example syntax is:
DELETE FROM "table_name"
6 Click Submit to run the workflow.
Drop a JDBC Table
You can run a workflow from the Orchestrator client to test the dropping of a JDBC table.
Prerequisites
Log in to the Orchestrator client as a user who can run JDBC workflows.
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 drop
table example workflow.
3 Right-click the JDBC drop table example workflow and select Start workflow.
Chapter 6 Using the SQL Plug-In
VMware, Inc. 53