CREATE PROCEDURE SCM.UPD_DATA(
    IN IN_T_ID INTEGER
    , IN IN_DATA XML
    )
DYNAMIC RESULT SETS  1 
------------------------------------------------------------------------
P1: BEGIN

	IF EXISTS(
		SELECT T_ID
		FROM TP
		WHERE T_ID = IN_T_ID
	) THEN
	    UPDATE TP
	    SET DATA = IN_DATA
		WHERE ID = IN_T_ID;
	ELSE 
		INSERT INTO TP (
		        T_ID
		        , DATA
		    ) VALUES (
		        IN_T_ID
		        , IN_DATA
		    );--
	END IF;	--
END P1;

CREATE TABLE "SCM"."TP"  (
		  "TP_ID" BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (  
		    START WITH + 1   
		    INCREMENT BY + 1   
		    MINVALUE + 1   
		    MAXVALUE + 9223372036854775807   
		    NO CYCLE  
		    CACHE  20   
		    NO ORDER ) , 
		  "T_ID" INTEGER NOT NULL , 
		  "DATA" XML )   
		 IN "USERSPACE1" ; 

ALTER TABLE TP 
	ADD CONSTRAINT P_P_TP_ID PRIMARY KEY
		("P_TP_ID");

ALTER TABLE TP 
	ADD CONSTRAINT "F_Reference_33" FOREIGN KEY
		("T_ID")
	REFERENCES STP
		("T_ID")
	ON DELETE RESTRICT
	ON UPDATE RESTRICT
	ENFORCED
	ENABLE QUERY OPTIMIZATION;

select COLCARD, HIGH2KEY, LOW2KEY, AVGCOLLEN, NUMNULLS 
from SYSSTAT.COLUMNS 
WHERE TABNAME ='TP' AND COLNAME = 'TP_ID' AND TABSCHEMA='SCM';

COLCARD     HIGH2KEY      LOW2KEY     AVGCOLLEN      NUMULLS
 2710         3918          21             8                 0 

select max(TP_ID) from SCM.TP

insert into TP(T_ID, data)
values( 1184 ,'<root xmlns:xf="http://www.w3.org/2002/xforms" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:ev="http://www.w3.org/2001/xml-events"></root>')

com.ibm.db2.jcc.b.lm: Одно или несколько значений в операторе INSERT, в операторе UPDATE или при обновлении внешнего ключа, вызванном оператором DELETE, недопустимы, поскольку первичный ключ, ограничение уникальности или индекс уникальности "3" запрещают повторение значений для этого ключа индекса в таблице "SCM.TP".. SQLCODE=- 803 , SQLSTATE= 23505 , DRIVER= 3 . 50 . 152 

SELECT INDNAME
  FROM SYSCAT.INDEXES
  WHERE IID =  3 
  AND TABSCHEMA = 'SCM'
  AND TABNAME = 'TP'

select s.LASTASSIGNEDVAL
from sysibm.syscolumns as c, sysibm.sysdependencies as d, sysibm.syssequences as s  
where c.tbcreator = d.dschema and c.tbname = d.dname 
and d.bname = s.seqname and d.bschema = s.seqschema 
and c.identity = 'Y' and d.dtype = 'T' and d.btype =  'Q' and s.seqtype = 'I' 
and C.name='TP_ID' and C.tbname='TP'

ALTER TABLE SCM.TP ALTER COLUMN TP_ID RESTART WITH  4000 ;