zOs/TX/MFNVZDD0

  SET CURRENT SQLID='S100447';
--
  SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","$creator" ;
--
  drop   VIEW $creator.$'$'VMF150Hash;
  CREATE VIEW $creator.$'$'VMF150Hash
      as select t.*,
  smallint(mod(
      month(MF150013) * 100000
      + int(translate(
          translate('08642', hex(substr(MF150023, 8,5)), '1234567890')
          , '024579', 'ABCDEF'))
      , 11047)) mf150Hash
  from $creator.tmf150A1 t
;
commit;