CREATE TABLE "DB2ADMIN"."ATTRIBUTES"  (
		  "ID" BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (  
		    START WITH + 1207040   
		    INCREMENT BY + 1   
		    MINVALUE + 0   
		    MAXVALUE + 1000000000000   
		    NO CYCLE  
		    CACHE  20   
		    NO ORDER ) , 
		  "ID_VAR" BIGINT NOT NULL , 
		  "ID_PROCESS" BIGINT NOT NULL , 
		  "VALUE_VAR" VARCHAR( 256 ) )   
		 IN "USERSPACE1" ; 

CREATE INDEX "DB2ADMIN"."QQQ" ON "DB2ADMIN"."ATTRIBUTES" 
		("ID_VAR" ASC)
		PCTFREE  10  CLUSTER MINPCTUSED  10 ;
ALTER TABLE "DB2ADMIN"."ATTRIBUTES" 
	ADD CONSTRAINT "CC1195719520266" PRIMARY KEY
		("ID");


CREATE TABLE "DB2ADMIN"."VARIABLES"  (
		  "ID_VAR" BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (  
		    START WITH + 631   
		    INCREMENT BY + 1   
		    MINVALUE + 1   
		    MAXVALUE + 1000000   
		    NO CYCLE  
		    CACHE  20   
		    NO ORDER ) , 
		  "NAME_VAR" VARCHAR( 128 ) , 
		  "TYPE_VAR" VARCHAR( 32 ) , 
		  "ADDITION_VAR" VARCHAR( 2048 ) , 
		  "ID_TYPE_PROCESS" INTEGER NOT NULL WITH DEFAULT  0  , 
		  "VALUE_BY_DEFAULT" VARCHAR( 256 ) , 
		  "IS_ID" SMALLINT NOT NULL WITH DEFAULT  0  , 
		  "IS_MAIN" SMALLINT NOT NULL WITH DEFAULT  0  )   
		 IN "USERSPACE1" ; 

ALTER TABLE "DB2ADMIN"."VARIABLES" 
	ADD CONSTRAINT "PK_VARIABLES" PRIMARY KEY
		("ID_VAR");

SELECT V.NAME_VAR, A.VALUE_VAR, V.TYPE_VAR, V.ADDITION_VAR, V.IS_ID, V.IS_MAIN
FROM DB2ADMIN.ATTRIBUTES AS A, DB2ADMIN.VARIABLES AS V
WHERE A.ID_PROCESS =  123456  AND V.ID_VAR = A.ID_VAR;