Focal Point
Truncate Table

This topic can be found at:

May 21, 2005, 03:32 PM
Truncate Table
i am using iway etl SOURCE IS AS400 to Db2 well when i am using Bulk Load utility and replace table data comes messed up,but when i use insert and commit by like 5 rows its k
2) there no truncate like in db2 how would i handel tht
May 26, 2005, 03:39 PM
Can you be more specific about your problem. What are you trying to do?. Use the iWay ETL tool to poupulate the target. If yes, the truncate table option on the load object should do the truncate for you.