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

Before you begin

Verify that the user account you are logged in with has the necessary permissions to 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 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.
    1. Type the first name of the user entry to be deleted.
    2. Type a user name to access the database.
    3. Type a JDBC connection URL.
    4. Type the last name of the user entry to be deleted.
    5. 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.