zOs/TX/PER03VW

  SET CURRENT SQLID='GDB0351';
  SET CURRENT SCHEMA='F383353';
  SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","F383353" ;
  CREATE VIEW GDB0351.VFI027A1 AS
    SELECT *
      FROM GDB0351.TFI027A1
      WHERE TKKEY < 1700001
  UNION ALL
    SELECT *
      FROM GDB0351.TFI027B1
      WHERE TKKEY BETWEEN 1700001 AND 3200000
  UNION ALL
    SELECT *
      FROM GDB0351.TFI027C1
      WHERE TKKEY BETWEEN 3200001 AND 4500000
  UNION ALL
    SELECT *
      FROM GDB0351.TFI027D1
      WHERE TKKEY BETWEEN 4500001 AND 5000000
  UNION ALL
    SELECT *
      FROM GDB0351.TFI027E1
      WHERE TKKEY BETWEEN 5000001 AND 6980000
  UNION ALL
    SELECT *
      FROM GDB0351.TFI027F1
      WHERE TKKEY BETWEEN 6980001 AND 9200000
  UNION ALL
    SELECT *
      FROM GDB0351.TFI027G1
      WHERE TKKEY BETWEEN 9200001 AND 10000000
  UNION ALL
    SELECT *
      FROM GDB0351.TFI027H1
      WHERE TKKEY BETWEEN 10000001 AND 10500000
  UNION ALL
    SELECT *
      FROM GDB0351.TFI027I1
      WHERE TKKEY BETWEEN 10500001 AND 11000000
  UNION ALL
    SELECT *
      FROM GDB0351.TFI027J1
      WHERE TKKEY > 11000000 ;
  COMMIT;