<?xml version='1.0' encoding='UTF-8'?>
<ROWSET tableName='GF43'>
/****************************************************************************/
/* GF43 ( 集計表ｻﾝﾌﾟﾙ )                                                     */
/*                                                                          */
/* Created : 2022/11/10 17:41:47                                            */
/****************************************************************************/
<EXEC_SQL exists="0">
SELECT COUNT(*) FROM SYS.SYSTABLES WHERE TABLENAME=UPPER('GF43');
CREATE TABLE GF43 (
   YYYY     VARCHAR (  4 )                  NOT NULL                
 , MM       VARCHAR (  2 )                  NOT NULL                
 , BLOCK    VARCHAR ( 60 )                  NOT NULL                
 , BRANCH   VARCHAR ( 60 )                  NOT NULL                
 , SALES    INTEGER             DEFAULT 0   NOT NULL                
 , AMOUNT   INTEGER             DEFAULT 0   NOT NULL                
);
</EXEC_SQL>
</ROWSET>
