<og:query command="{@command}" debug="{@debug}" maxRowCount="10000" stopZero="true">
	select	TABLE_NAME,SEQNO,CLM,NAME_JA,CLS_NAME,
			USE_LENGTH,RENDERER,EDITOR,DBTYPE,
			NOT_NULL,DATA_DEFAULT,BIKO,SYSTEM_ID,FGJ,UNIQ
	from GF05
	where SYSTEM_ID  = '{@SYSTEM_ID}'
	and   TBLSYU     = '{@TBLSYU}'
	and   TABLE_NAME like '{@TABLE_NAME}%'
	and   CLM        like '{@CLM}%'
	and   FGCOM     != '9'
	and   FGJ in ('0','1')
	and (
			(
				(
						RENDERER not in ( 'MENU','DBMENU','CHBOX' )
					or	EDITOR   not in ( 'MENU','DBMENU','CHBOX' )
				)
				and   TO_NUMBER(REPLACE(NVL(USE_LENGTH,'0'),',','.'),999.9) < 3
				and	(
						CLM like 'FG%'
					or  CLM like 'CD%'
					or  CLM like 'KB%'
				)
			)
		or
			(
				CLS_NAME  != 'NUMBER'
				and	(
						CLM like 'SU%'
					or  CLM like 'KN%'
					or  CLM like 'TK%'
					or  CLM like 'SEQ%'
				)
			)
		or
			(
				CLS_NAME  != 'VARCHAR2'
				and	(
						CLM like 'NM%'
					or  CLM like 'KJ%'
					or  CLM like 'FG%'
					or  CLM like 'KB%'
					or  CLM like 'CD%'
					or  CLM like 'DY%'
				)
			)
		or
			(
				(
						RENDERER not in ( 'YMD','YMDH','MD','YM','DATE' )
					or	EDITOR   not in ( 'YMD','YMDH','MD','YM','DATE' )
					or	DBTYPE   not in ( 'YMD','YMDH','MD','YM','DATE' )
				)
				and	(
						CLM like 'DY%'
				)
			)
		)
	order by SYSTEM_ID,CLM,TABLE_NAME
</og:query>

<og:hidden name="SQL" >
	UPDATE GF05 SET
			SEQNO			= [SEQNO],
			CLM 			= [CLM],
			NAME_JA 		= [NAME_JA],
			CLS_NAME		= [CLS_NAME],
			USE_LENGTH		= [USE_LENGTH],
			NOT_NULL		= [NOT_NULL],
			RENDERER		= [RENDERER],
			EDITOR			= [EDITOR],
			DBTYPE			= [DBTYPE],
			DATA_DEFAULT	= [DATA_DEFAULT],
			BIKO			= [BIKO],
			SYSTEM_ID		= [SYSTEM_ID],
			CDKH			= 'C',
			FGJ				= '1',
			DYUPD			= '{@USER.YMDH}',
			USRUPD			= '{@USER.ID}',
			PGUPD			= '{@GUI.KEY}'
	WHERE UNIQ  = [UNIQ]
</og:hidden>

<og:hidden name="noWritable">SYSTEM_ID,TABLE_NAME</og:hidden>
