Question

 In which Oracle table/field do I find the DEL=Y value for BIB and item records?  

Answer

In BIB record the DEL=Y field is embedded in the Z00 record as all other BIB fields are too.

The Z30 record is actually deleted when the item record is deleted. The "Deletion" is reported in the Z30H (history) record the following way:

    02     02 z30h_history \

      03 h_date .....................20161228

      03 h_hour .....................1336

      03 h_reason ...................Deleted

      03 h_cataloger ................MASTER

      03 h_reason_type ..............DELETE

    02 z30h_upd_time_stamp ..........201612281336478

    02 z30h_ip_last_return_v6 .......

This is only working when parameter CREATE-Z30H in tab100 is set to "Y" and a Z30H record is created.

• Article last edited: 28-DEC-2016