DROP VIEW QTEMP/MYDSPJRN4V
;
CREATE VIEW QTEMP/MYDSPJRN4V AS
  SELECT
         JOENTL, JOSEQN, JOCODE,
         JOENTT, JOTSTP, JOJOB, JOUSER,
         JONBR, JOPGM, JOOBJ, JOLIB, JOMBR,
         JOCTRR, JOFLAG, JOCCID, JOUSPF,
         JOSYNM, JOJID, JORCST, JOTGR,
         JOINCDAT, JOIGNAPY, JOMINESD,
         JORES, JONVI
 FROM
         MYDSPJRN4
;