You can run a workflow from the Orchestrator client to delete all entries from a JDBC table.

Before you begin

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.
    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.