INSERT INTO TMSDTAMML/DSCC00P (C5CN,C5CTYP,C5CODE,C5EFDT)
      SELECT C1CN, 'CC-SMORD', 'SMI', '2008-07-25'
                                 FROM
TMSDTAMML/DSCM00P WHERE C1CN NOT IN (SELECT C5CN FROM DSCC00P
WHERE C5CTYP = 'CC-SMORD') AND C1CCLS = 'EXP' AND C1CAR = 'JU' AND C
1OCON = 'Y'