create sequence PRD_ID
	maxvalue 999999999
	order
/

create sequence PUBSBSP
	minvalue 0
	maxvalue 9999999999
	cycle
	cache 200
/

create sequence PUBSIDN
	minvalue 0
	maxvalue 999999999999999999
	cycle
	cache 100
/

create sequence PUBSJRN
	minvalue 0
	maxvalue 9999999999
	cycle
	cache 2000
/

create sequence SEQ_JOURNAL_NO
	maxvalue 9999999999
	cycle
	cache 100
/

create sequence SEQ_PARM_ID
	cache 10
/

create sequence SEQ_RUTTRURC
	minvalue 1000000001
	maxvalue 99999999999999
/

create sequence SEQ_URMTMINF
	cache 60
/

create sequence SEQ_URMTOPPR
	minvalue 1000000001
	maxvalue 99999999999999
/

create sequence SEQ_USER_INFO
/

create sequence S_DATA_ID
	maxvalue 9999999999
	cycle
	nocache
/

create sequence S_LOG_NO
	minvalue 0
	maxvalue 999999999999999999
	cache 100
/

create sequence USENO_ID
	minvalue 100000000000
	maxvalue 999999999999
	order
/

create sequence JRN_NO_SEQUENCE
	maxvalue 9999999999
	cycle
	cache 100
/



create sequence CK_SEQUENCE
	maxvalue 99999999
	cycle
	cache 100
/

create sequence ICBC_CAP_SEQUENCE
	maxvalue 9999
	cycle
	cache 100
/

create sequence ICBCCORGBUSTYP
	maxvalue 999
	cycle
	cache 100
/

CREATE SEQUENCE UPOP_BATNO_SEQUENCE 
    INCREMENT BY 1 
    START WITH 1 
    MAXVALUE 9999  
    CACHE 100 ORDER CYCLE
/

CREATE SEQUENCE UPOP_SEQUENCE 
    INCREMENT BY 1
    START WITH 1 
    MAXVALUE 99999999  
    CACHE 200 ORDER CYCLE
/

CREATE SEQUENCE PAB_CHECK_SEQUENCE
    INCREMENT BY 1 
    START WITH 1 
    MAXVALUE 999999   
    CACHE 100 ORDER CYCLE
/