zOs/SQL/GUBLDBAF

  SET CURRENT SQLID='VDPS2';
  SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F281992" ;
  CREATE VIEW VDPS2.XPS_VISID001 AS
    SELECT T1.IDSYMBOL, T1.SCHEMESYMBOL, T3.IDSYMBOL IDSYMBOL_ID,
           T3.SCHEMESYMBOL SCHEMESYMBOL_ID, T1.INSTITUTIONID,
           T1.CREATETIMESTAMP, T1.UPDATETIMESTAMP, T1.VALIDFROMDATE,
           T1.VALIDUNTILDATE, T3.CREATETIMESTAMP CREATETIMESTAMP_ID,
           T3.UPDATETIMESTAMP UPDATETIMESTAMP_ID,
           T3.VALIDFROMDATE VALIDFROMDATE_ID,
           T3.VALIDUNTILDATE VALIDUNTILDATE_ID
      FROM VDPS2.VTINSTIIDENT T1
           INNER JOIN
           VDPS2.VTINSTITUTION T2
           ON T2.INSTITUTIONID = T1.INSTITUTIONID AND (T2.ROWSTATUS
           IS NULL  OR T2.ROWSTATUS <> 2)
           INNER JOIN
           VDPS2.VTINSTIIDENT T3
           ON T3.INSTITUTIONID = T1.INSTITUTIONID AND T3.ROWSTATUS = 1
      WHERE T1.ROWSTATUS = 1 ;
  COMMIT;