You can run a workflow from the Orchestrator client to test the deletion of an entry from a JDBC table.

Log in to the Orchestrator client as a user who can run JDBC workflows.

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 entry from table example workflow.

3

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

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.