- Article Type: General
- Product: Aleph
- Product Version: 20
As part of our workflow for creating automatic summary holdings statements, we would like to run the HSTMT fix on all HOL records with an Sxx field on a nightly basis. How is the best way to accomplish this?
The jobs which run fixes are p_manage_25 and p_manage_37. p_manage_25 operates only on a sequential file; p_manage_37 can operate on a sequential file, a from-to group of record numbers, *or* on the Oracle records themselves.
You could run p_ret_01 in the ABC60 to retrieve the doc numbers of records with an Sxx field and then use that as input to p_manage_37. Assuming not many records will be changed, the p_manage_37 should not take long. But p_ret_01 on the entire HOL file could take a while....
What you *could* do is to define a Z07H table in the ABC60 (with triggers so that a Z07H is written each time a Z07 is written). Then you could run an SQL script against this Z07H to extract the doc number. This will give you a file of record numbers updated that day, which could then be used as input to p_manage_37.
Or, you could include this fix in the tab_fix INS section so it is run each time the record is written.
(keywords: manage_37 manage_25 ret_01 p-manage-37 p-manage-25 p-ret-01)
- Article last edited: 10/8/2013