Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    p-file-95 doesn't update database

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    I want to use p-file-95 to delete some fields from BIB records.
    This is the parameters I used in the run. I used 'Y' for update the database. The report shows found match doc and found match field. but No update to the database.

    The Report
    <doc-counter>000000004</doc-counter>
    <doc-match-counter>000000004</doc-match-counter>
    <doc-no-match-counter>000000000</doc-no-match-counter>
    <doc-updated-counter>000000000</doc-updated-counter>
    <field-match-counter>000000004</field-match-counter>
    <field-no-match-counter>000000000</field-no-match-counter>

    Here is an example of the input file being used, prior to converting it to MARC Communications Format:

    000000001 LDR L ^^^^^^^^^^^^00061^^^45^^
    000000001 001 L 000595257
    000000001 005 L 00000000000000.0
    000000001 035 L $$a2175660$$bMULS$$9MAT

    Resolution:
    The p-file-95 routine isn't designed to delete tags, as you are trying to do. It does exactly what the Help indicates - and only that. It finds a field to be matched on (the $$9 subfield = MAT), and then replaces it with the following field (the $$9 = ADD.)

    So you can't simple delete a field with this service. You have to replace the field. I think you can accomplish what you want by replacing the unwanted 035 field with a CAT field (which would indicate when and how the record was updated). Here is an example of what the input to p-file-95 would look like:

    000000001 LDR L ^^^^^^^^^^^^00061^^^45^^
    000000001 001 L 000595257
    000000001 005 L 00000000000000.0
    000000001 035 L $$a2175660$$bMULS$$9MAT
    000000001 CAT L $$aFILE95$$b00$$c20080624$$lUSM01$$h1200$$9ADD

    I tested this and it worked. The 035 field is removed and the CAT field is added. If you decided to do this, be sure to put the appropriate Cataloger Level in CAT $$b.

    ***********
    Follow-up from ALEPH customer, with an variation on the solution:

    I used format of following file and 035 has been deleted without adding any fields. It works great.

    000595257 001 L 000595257
    000595257 035 L $$a2175660$$bMULS$$9MAT
    000595257 035 L $$9ADD
    000596055 001 L 000596055
    000596055 035 L $$a206-E-113$$bNYG$$a0385937$$bMULS$$9MAT
    000596055 035 L $$9ADD


    • Article last edited: 10/8/2013
    • Was this article helpful?