Changed syntax for the TRUNCATE statement
A TRUNCATE statement does not require that the IMMEDIATE keyword to be specified explicitly. The truncate operation is processed immediately regardless of whether IMMEDIATE is specified. If the TRUNCATE statement is not the first statement in the logical unit of work, an implicit commit operation is performed before the TRUNCATE statement is run. This capability does not apply to the Entry plan of the Db2® Warehouse on Cloud managed service.
Otherwise, the TRUNCATE statement behaves as described in TRUNCATE statement.