[ DB2.View - Sample ]
SET SCHEMA PRD;
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","PRD";
CREATE VIEW PRD.Z_USER_VIEW
(USER_ID,
USER_NM,
USER_NO,
CO_CD,
CO_NM,
DEPT_CD,
DEPT_NM,
GUBUN,
SEG_CD,
SEG_NM,
INTER_PHON,
HAND_PHON,
E_MAIL
)
AS SELECT USER_ID, USER_NM, USER_NO ,CO_CD, CO_NM , DEPT_CD, DEPT_NM , 'I' AS
GUBUN ,SEG_CD, SEG_NM ,INTER_PHON, HAND_PHON, E_MAIL
FROM COM.COM_USER_TBL
WHERE 1=1
AND DEL_FLAG <> 'Y'
AND STOP_FLAG <> 'Y'
UNION ALL
SELECT USER_ID, USER_NM, '' AS USER_NO ,CO_CD, CO_NM , DEPT_CD, DEPT_NM, 'O'
AS GUBUN ,SEG_CD, SEG_NM ,INTER_PHON, HAND_PHON, E_MAIL
FROM COM.COM_OUTUSER_TBL;
