DECLARE GLOBAL TEMPORARY TABLE SESSION.GPS_AUTOINC (NAME VARCHAR(10), VALUE INT) WITH REPLACE ON COMMIT PRESERVE ROWS NOT LOGGED;
INSERT INTO SESSION.GPS_AUTOINC values ('Test1', -1);

WITH VT (NAME, VALUE) AS (
SELECT NAME, VALUE
FROM TABLE(VALUES ('Test1', 1), ('Test2', 2)) T (NAME, VALUE)
)
, U AS (
SELECT *
FROM FINAL TABLE (
UPDATE SESSION.GPS_AUTOINC MT
SET VALUE=(SELECT VT.VALUE FROM VT WHERE VT.NAME=MT.NAME)
WHERE EXISTS (SELECT 1 FROM VT WHERE VT.NAME=MT.NAME)
)
)
, I AS (
SELECT *
FROM FINAL TABLE (
INSERT INTO SESSION.GPS_AUTOINC
SELECT VT.NAME, VT.VALUE FROM VT
WHERE NOT EXISTS (SELECT 1 FROM SESSION.GPS_AUTOINC MT WHERE MT.NAME=VT.NAME)
)
)
SELECT 'UPDATED' TYPE, U.* FROM U
  UNION ALL
SELECT 'INSERTED' TYPE, I.* FROM I;