INSERT INTO ?CREATOR?.ICMSTNLSKEYWORDS (KEYWORDCLASS,
   LANGUAGECODE,KEYWORDCODE,KEYWORDNAME,KEYWORDDESCRIPTION)
   SELECT 10 , LANGUAGECODE, 149 , 'ItemSetDeleteHold',
   CASE WHEN LANGUAGECODE='ENU' THEN '' ELSE '*' END    ||
  'Create and delete hold relationships.'
   FROM ?CREATOR?.ICMSTNLSLANGUAGES A
   WHERE NOT EXISTS (SELECT 1 FROM ?CREATOR?.ICMSTNLSKEYWORDS B
   WHERE B.LANGUAGECODE = A.LANGUAGECODE AND
         B.KEYWORDCLASS = 10 AND B.KEYWORDCODE = 149)
;

INSERT INTO ?CREATOR?.ICMSTNLSKEYWORDS (KEYWORDCLASS,
   LANGUAGECODE,KEYWORDCODE,KEYWORDNAME,KEYWORDDESCRIPTION)
   SELECT 10 , LANGUAGECODE, 150 , 'ItemtypeRetentionAdmin',
   CASE WHEN LANGUAGECODE='ENU' THEN '' ELSE '*' END    ||
  'Perform retention administrative operations.'
   FROM ?CREATOR?.ICMSTNLSLANGUAGES A
   WHERE NOT EXISTS (SELECT 1 FROM ?CREATOR?.ICMSTNLSKEYWORDS B
   WHERE B.LANGUAGECODE = A.LANGUAGECODE AND
         B.KEYWORDCLASS = 10 AND B.KEYWORDCODE = 150)
;

INSERT INTO ?CREATOR?.ICMSTNLSKEYWORDS (KEYWORDCLASS,
   LANGUAGECODE,KEYWORDCODE,KEYWORDNAME,KEYWORDDESCRIPTION)
   SELECT 10 , LANGUAGECODE, 151 , 'ItemtypeSetHoldAdmin',
   CASE WHEN LANGUAGECODE='ENU' THEN '' ELSE '*' END    ||
  'Administrative privilege to perform hold operations.'
   FROM ?CREATOR?.ICMSTNLSLANGUAGES A
   WHERE NOT EXISTS (SELECT 1 FROM ?CREATOR?.ICMSTNLSKEYWORDS B
   WHERE B.LANGUAGECODE = A.LANGUAGECODE AND
         B.KEYWORDCLASS = 10 AND B.KEYWORDCODE = 151)
;

INSERT INTO ?CREATOR?.ICMSTNLSKEYWORDS (KEYWORDCLASS,
   LANGUAGECODE,KEYWORDCODE,KEYWORDNAME,KEYWORDDESCRIPTION)
   SELECT 10 , LANGUAGECODE, 152 , 'ItemtypeDeleteExpiredAdmin',
   CASE WHEN LANGUAGECODE='ENU' THEN '' ELSE '*' END    ||
  'Administrative privilege to perform delete utility operations.'
   FROM ?CREATOR?.ICMSTNLSLANGUAGES A
   WHERE NOT EXISTS (SELECT 1 FROM ?CREATOR?.ICMSTNLSKEYWORDS B
   WHERE B.LANGUAGECODE = A.LANGUAGECODE AND
         B.KEYWORDCLASS = 10 AND B.KEYWORDCODE = 152)
;

COMMIT
;

INSERT INTO ?CREATOR?.ICMSTPRIVDEFS (PRIVDEFCODE)
   SELECT 149
   FROM SYSIBM.SYSDUMMY1
   WHERE NOT EXISTS (SELECT 1 FROM ?CREATOR?.ICMSTPRIVDEFS
    WHERE PRIVDEFCODE =     149)
;

INSERT INTO ?CREATOR?.ICMSTPRIVDEFS (PRIVDEFCODE)
   SELECT 150
   FROM SYSIBM.SYSDUMMY1
   WHERE NOT EXISTS (SELECT 1 FROM ?CREATOR?.ICMSTPRIVDEFS
    WHERE PRIVDEFCODE =     150)
;

INSERT INTO ?CREATOR?.ICMSTPRIVDEFS (PRIVDEFCODE)
   SELECT 151
   FROM SYSIBM.SYSDUMMY1
   WHERE NOT EXISTS (SELECT 1 FROM ?CREATOR?.ICMSTPRIVDEFS
    WHERE PRIVDEFCODE =     151)
;

INSERT INTO ?CREATOR?.ICMSTPRIVDEFS (PRIVDEFCODE)
   SELECT 152
   FROM SYSIBM.SYSDUMMY1
   WHERE NOT EXISTS (SELECT 1 FROM ?CREATOR?.ICMSTPRIVDEFS
    WHERE PRIVDEFCODE =     152)
;

COMMIT
;

INSERT INTO ?CREATOR?.ICMSTPRIVSETS (PRIVSETCODE, PRIVDEFCODE)
      SELECT 1 , 149
      FROM SYSIBM.SYSDUMMY1
WHERE NOT EXISTS (SELECT 1 FROM ?CREATOR?.ICMSTPRIVSETS
WHERE PRIVSETCODE = 1 AND PRIVDEFCODE =     149)
;

INSERT INTO ?CREATOR?.ICMSTPRIVSETS (PRIVSETCODE, PRIVDEFCODE)
      SELECT 1 , 150
      FROM SYSIBM.SYSDUMMY1
WHERE NOT EXISTS (SELECT 1 FROM ?CREATOR?.ICMSTPRIVSETS
WHERE PRIVSETCODE = 1 AND PRIVDEFCODE =     150)
;

INSERT INTO ?CREATOR?.ICMSTPRIVSETS (PRIVSETCODE, PRIVDEFCODE)
      SELECT 1 , 151
      FROM SYSIBM.SYSDUMMY1
WHERE NOT EXISTS (SELECT 1 FROM ?CREATOR?.ICMSTPRIVSETS
WHERE PRIVSETCODE = 1 AND PRIVDEFCODE =     151)
;

INSERT INTO ?CREATOR?.ICMSTPRIVSETS (PRIVSETCODE, PRIVDEFCODE)
      SELECT 1 , 152
      FROM SYSIBM.SYSDUMMY1
WHERE NOT EXISTS (SELECT 1 FROM ?CREATOR?.ICMSTPRIVSETS
WHERE PRIVSETCODE = 1 AND PRIVDEFCODE =     152)
;

COMMIT
;