<?xml version='1.0' encoding='UTF-8'?>
<ROWSET tableName='GE62'>
/****************************************************************************/
/* GE62 ( 伝送定義ﾏｽﾀ )                                                     */
/*                                                                          */
/* Created : 2017/01/05 15:19:11                                            */
/****************************************************************************/
<EXEC_SQL>
CREATE TABLE GE62 (
   SYSTEM_ID    VARCHAR (  10 )                 NOT NULL                
 , KBREAD       VARCHAR (  20 )                 NOT NULL                
 , READOBJ      VARCHAR ( 200 )                 NOT NULL                
 , READPRM      VARCHAR ( 200 )                                         
 , KBEXEC       VARCHAR (  20 )                 NOT NULL                
 , EXECDBID     VARCHAR ( 100 )                                         
 , EXECOBJ      VARCHAR ( 200 )                 NOT NULL                
 , EXECPRM      VARCHAR ( 200 )                                         
 , DMN_GRP      VARCHAR (  20 )                 NOT NULL                
 , DMN_TIME     INTEGER             DEFAULT 60  NOT NULL                
 , ERROR_SENDTO VARCHAR ( 200 )                                         
 , UNIQ         BIGINT                          NOT NULL                
 , FGJ          VARCHAR (   1 )     DEFAULT '1' NOT NULL                
 , DYSET        VARCHAR (  14 )                                         
 , PGSET        VARCHAR (  10 )                                         
 , PGPSET       VARCHAR (  10 )                                         
 , USRSET       VARCHAR (  10 )                                         
 , DYUPD        VARCHAR (  14 )                                         
 , PGUPD        VARCHAR (  10 )                                         
 , PGPUPD       VARCHAR (  10 )                                         
 , USRUPD       VARCHAR (  10 )                                         
)
</EXEC_SQL>

<EXEC_SQL>
CREATE SEQUENCE GE62S00 
</EXEC_SQL>

<EXEC_SQL>
CREATE TRIGGER GE62T00 FOR GE62
  BEFORE INSERT AS 
  BEGIN 
    NEW.UNIQ = GEN_ID( GE62S00,1 );
  END; 
</EXEC_SQL>
</ROWSET>
