Skip to Content
0
Nov 12, 2012 at 12:18 PM

Truncate a database table

538 Views

Hi Team,

i have a sceanrio JDBC to JDBC. now my requirement is, i have to insert data from source DB (full extract) to target DB.

So in receiver side before insert data, i have to truncate the target table and then insert data every time. So how can i achieve this with JDBC receiver

please suggest.

do we have any document format for Truncate in JDBC? apart from INSERT, UPDATE, UPDATE_INSERT, DELETE, or SELECT

Best Regards,vasu.