<?xml version='1.0' encoding='UTF-8'?>
<ROWSET tableName='GF43'>
/****************************************************************************/
/* GF43 ( 集計表ｻﾝﾌﾟﾙ )                                                     */
/*                                                                          */
/* Created : 2022/11/10 17:41:31                                            */
/****************************************************************************/
<EXEC_SQL exists="0">
SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME=LOWER('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>
