<?xml version='1.0' encoding='UTF-8'?>
<ROWSET tableName='xxx'>
<EXEC_SQL>
CREATE OR REPLACE VIEW GEA10V01
AS
SELECT
	 SYSTEM_ID
	,USERID
	,PASSWD
	,LANG
	,NAME_JA
	,ROLES
	,DROLES
	,FGJ
	,FGDEFAULT
FROM GEA10
WHERE FGJ  = '1'
AND   DYVALID >= TO_CHAR(SYSDATE,'YYYYMMDD')
</EXEC_SQL>
</ROWSET>
