DROP PACKAGE with hex zeroes

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Frank Swarbrick

    DROP PACKAGE with hex zeroes

    I accidentally created a package with a VERSION string that contains hex
    zeroes in it.

    Specifically:

    SELECT hex(pkgversion) as hexver
    FROM SYSCAT.PACKAGES
    where pkgschema = 'VSEUSER'
    and pkgname = 'CICSDD18';


    HEXVER
    ----------------------------------------------------------------------------
    ------------------------
    323030383036303 231363231313037 340000000000000 000000000000000 000000000000000 0
    000000000000000 000000000

    What might be the best way to remove it?

    I can't seem to use
    DROP PACKAGE vseuser.cicsdd1 8 VERSION "20080602162110 74"
    because of the hex zeroes, but I'm not sure how to get hex zeroes in the
    version string.

    Thanks,
    Frank

Working...