DDUPDATE -DEL AUTHORIZATION report corrupt

book

Article ID: 125572

calendar_today

Updated On:

Products

CA Datacom CA DATACOM - AD

Issue/Introduction

We are deleting some redundant DataQuery AUTHORIZATION entities for databases/tables where there are no related users via DDUPDATE.
 The control card is... 
-DEL AUTHORIZATION,$DQ-ADDR-$DQ003(001) 

The delete is successful but the DDUPDATE entity report is corrupt after the PRODUCT-ID attribute.

Cause

No ALIAS nor TEXT entities exist. 

Environment

Z/OS
CA Datadictionary 15.1 (and older versions) 

Resolution

After looking at the product code,  sustaining engineering found that the report is actually printed BEFORE the delete takes place as a review to the user of what is being deleted.
The reason the report appears "corrupted" is because it is reporting ALIASes and TEXT that may or may not exist for that entity.
Since no ALIASES  nor TEXT  existed for that entity, they show nothing.
The report is printed as intended.