IBM Support

IDCAMS DELETE using generic level qualifiers (asterisks) gives unexpected results

Question & Answer


Question

Examples of how the generic level DELETE works given the following data sets: 1) AAA.BBB.CCC.DDD 2) AAA.BBB.CCZ.DDD 3) AAA.BBB.CCC.DDD.EEE 4) AAA.BBB.CCC DELETE AAA.

Answer

      • Description:


        Examples of how the generic level DELETE works given the following data sets:
        1) AAA.BBB.CCC.DDD
        2) AAA.BBB.CCZ.DDD
        3) AAA.BBB.CCC.DDD.EEE
        4) AAA.BBB.CCC

        DELETE AAA.* results in the deletion of no data sets.
        DELETE AAA.BBB.* results in the deletion of data set #4.
        DELETE AAA.BBB.*.DDD results in the selection of data sets #1 and #2.
        DELETE AAA.BBB.*.DDD.EEE results in the deletion of data set #3.

        The command:

        DELETE AAA.BBB.*.*

        Will fail with:
        IDC3203I ITEM ' AAA.BBB.*.* ' DOES NOT ADHERE TO RESTRICTIONS

        DELETE AAA.*.CCC.*

        Will fail with:
        IDC3203I ITEM ' AAA.*.CCC.* ' DOES NOT ADHERE TO RESTRICTIONS


        Resolution:

        When a generic level name is specified, only one qualifier can replace the asterisk ( * ) . The number of level qualifiers (generic + specific) specified with the DELETE command must match the number of level qualifiers of the data set to be deleted.

        NOTE: A reader's comment has been submitted to include this in the manual:
        'Access Method Services for the Integrated Catalog Facility'

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG90","label":"z\/OS"},"Component":"5695DF103 - DFSMS ACCESS METHOD SERVICES","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"1.1;1.2;1.3;1.4;1.5;1.6;1.7;1.8;1.9;1.10;1.11;1.12;1.13;2.1;2.2;2.3;2.4","Edition":"","Line of Business":{"code":"LOB56","label":"Z HW"}}]

Historical Number

8424027

Document Information

Modified date:
03 September 2021

UID

isg3S1000208