DROP TABLE IF EXISTS tmp_01;
CREATE TEMPORARY TABLE tmp_01(
col01 char(32) not null
, col02 varchar(100)
, primary key(col01)
);
CREATE GLOBAL TEMPORARY TABLE tmp_01(
col01 char(32) not null
, col02 varchar(100)
, session_id char(32) not null
)
ON COMMIT PRESERVE ROWS;
ALTER TABLE tmp_01
ADD PRIMARY KEY (col01, session_id);
CREATE TABLE #tmp_01(
col01 char(32) not null
, col02 varchar(100)
, primary key(col01)
) ;
-- DB2
DECLARE GLOBAL TEMPORARY TABLE session.tmp_01(
col01 char(32) not null
, col02 varchar(100)
, primary key(col01)
) NOT LOGGED WITH REPLACE;