You can run a workflow from the Orchestrator client to delete all entries 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, expand 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.
    1. Type a database connection URL.
    2. Type a user name to access the database.
    3. 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.