Delete all the rows of a table in a single action.
(In V10.3 and later) Any table truncated using TRUNCATE will have the $DELFLD$ set to 4 bytes despite the size in the original table.
TRUNCATE TABLE [ table_name ]
Specifies a single table to truncate.
The user must have the DBA privilege or SELECT privilege on all the tables in the database. To issue the TRUNCATE TABLE statement for a specific table, the user must be the owner or have UPDATE privilege on the table.
Embedded SQL, interactive SQL, ODBC applications