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 >= date_format(current_date(),"%Y%m%d")
;