<jsp:directive.page pageEncoding="UTF-8" />
<og:query command="{@command}" debug="{@debug}" maxRowCount="0">
		SELECT YOYAKU,
			CASE DBNAME WHEN 'ORACLE'     THEN 'ORA'
						WHEN 'SQLSERVER'  THEN 'MS'
						WHEN 'SQL2008'    THEN '08'
						WHEN 'SQL2003'    THEN '03'
						WHEN 'SQL92'      THEN '92'
						WHEN 'SQL99'      THEN '99'
						WHEN 'MYSQL'      THEN 'MY'
						WHEN 'SQLITE'     THEN 'SQL'
						WHEN 'POSTGRESQL' THEN 'POS'
						WHEN 'FIREBIRD'   THEN 'FB'
						ELSE 'OTR'
			END AS DBNAME,
			CDYOYAKU
		FROM GF19
	<og:where>
		<og:and value = "YOYAKU		like  '{@YOYAKU}%'"		/>
		<og:and value = "CDYOYAKU	=     '{@CDYOYAKU}'"	/>
	</og:where>
		ORDER BY YOYAKU,DBNAME
</og:query>

<og:view
	viewFormType = "HTMLCrossTable"
	command		= "{@command}"
	checked		= "{@checked}"
	startNo		= "{@startNo}"
	pageSize	= "{@pageSize}"
	useParam	= "true"
  >
	<og:crossParam
		cubeXColumn	= "YOYAKU"
		cubeYColumn	= "DBNAME"
	/>
</og:view>
