Hello.

During some experimentation with DB2 decimal numbers representations, I
have discovered very unexpected  behaviour of the global temporary
table. Consider this example.
Such I had executed the example: # db2 -td@ -f FILENAME.

When an single Insert into table fails, the table gets empty. Could
anybody shed some light on this ?

----( code )----------------------
   DECLARE GLOBAL TEMPORARY TABLE #r
   (
        res decimal(31) not null
    )
       ON COMMIT  PRESERVE  ROWS
       NOT LOGGED
@
   insert into session.#r values( 1 ) @
   insert into session.#r values( 2 ) @
   insert into session.#r values( 3 ) @

   select * from session.#r
-- here is expected result: 3 rows with consecutive values : 1,2,3
@
BEGIN ATOMIC
   declare m_fact decimal(15) default 1;

   FOR X AS
       select
              m_fact * 9999999999999999999999999999999. +
.0000000000000000000000000000001 as val
       from sysibm.sysdummy1
   DO
-- next line FIRES THE ERROR: SQL0802N
       insert into session.#r values( X.val );
   END FOR;
END
@
   select * from session.#r
-- HERE the table "session.#r" is empty: 0 rows returned. WHY ?
@