As400 Truncate Table. Truncate table DestTable Using truncate table is better then using delete as it ignores all the indexes and just removes everything. SanjayRs Member Posts.
Delete table is a row based operation this means that each row is deleted. I know you can do it from a command prompt using the command clrpfm but can this be accomplished from sql. Does anyone know how this can be done on the AS400.
The DELETE statement without a WHERE clause allows you to delete all rows from a table.
Import from multiple AS400 tables and place into one SQL Table Forum. Mar 26 2009 327PM. Often used to empty tables that are used during ETL cycles after the data has been copied to another table for the next stage of. Truncate table on iSeries.
