declare global temporary table test(i int) on commit preserve rows not logged
DB20000I  The SQL command completed successfully.

insert into session.test values 1
DB20000I  The SQL command completed successfully.

select * from session.test

I          
-----------
          1

  1 record(s) selected.


rollback
DB20000I  The SQL command completed successfully.

select * from session.test
SQL0204N  "SESSION.TEST" is an undefined name.  SQLSTATE=42704