pfx-sql:truncate
Truncates an entire database table.
Properties
Option | Type | Default | Description |
---|---|---|---|
| string |
| Defines a Data Source name. |
| string | Â | Defines a DB table. |
Examples
Truncates a table defined in the URI parameter of the pfx-sql component.
<routes xmlns="http://camel.apache.org/schema/spring">
<route>
<from uri="direct:sql-truncate"/>
<to uri="pfx-sql:truncate?dataSource=dataSource&table=QUOTE_WORKFLOW_HISTORY"/>
</route>
</routes>
Â
IntegrationManager version 5.8.0