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

    Decrypting z308_verification field for sending z308 data to vendor

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

    Description:
    Can data in the z308_verification fields be decrypted if z308_encryption = “H”?

    Changing “H” (encrypt) to “N” (do not encrypt) does not affect the z308_verification fields: they are still encrypted.

    I’m wondering if there is a program that can decrypt these fields. (We want to send this data to EZProxy.)

    Resolution:
    The Aleph programs encrypt/decrypt the z308_verification field. There is no external routine that I know of which does this.

    Changing "H" to "N", by itself, does nothing. A new "N" status would requires one of the following additional actions:
    * open the record in the GUI and save it
    * run p_manage_64, which has the ability to encrypt/unencrypt z308 ID's.

    The header to tab100 ENCRYPT-Z308 says this:
    ! Exporting the records with p-file-03 will always export unencrypted records.

    Thus, you *could* export the z308 with p_file_03 and send all or part of the sequential file it creates to EZProxy.

    Example:

    $data_tab/tab100 : ENCRYPT-Z308=Y

    Export USR00 : Z308, Unencrypted Results:
    (v20)>> csh -f $aleph_proc/p_file_03 usr00,z308,go,,FIX
    Fields:
    |------ Z308_REC_KEY -----||----------Z308_VERIFICATION ----------|VT|- Z308_ID |STE
    Excerpt from z308.seqaa file:
    0000000056 USM0100000056 0000000056 ACN
    00000000001930 DUP5073 00000000001930ACN

    z308 in SQLplus (using first record above) in still encrypted:
    >> desc z308
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    Z308_REC_KEY NOT NULL CHAR(27)
    Z308_VERIFICATION VARCHAR2(40)
    Z308_VERIFICATION_TYPE CHAR(2)
    Z308_ID CHAR(12)
    Z308_STATUS CHAR(2)
    Z308_ENCRYPTION CHAR(1)

    >> select * from z308 where substr(Z308_REC_KEY, 1, 10) = '0000000056';
    Z308_REC_KEY Z308_VERIFICATION Z3 Z308_ID Z3 Z
    --------------------------- ---------------------------------------- -- ------------ -- -
    0000000056 USM01 b8983020b8b83543abdb2363abfb2383ab1b23a3 00 00000056 AC H

    Note that the encryption field = 'N' in the exported record because the verifications are no longer encrypted in the output file, even though encryption = 'H' in the system and the verifications are encrypted.

    Note that if you want to import exported records back into the system with encryption, the record’s Z308-ENCRYPTION column in the *.seqaa file must be set back to H.
    The ENCRYPT-Z308 flag in the tab100 table is NOT consulted for this purpose.
    The PLIF or p_file_06 will encrypt records marked with 'H'. p_file_04 just loads the file with no changes, no matter what the encryption field indicates.

    (keywords: p-manage-64 manage_64 file_03 p-file-03 file_04 p-file-04 file_06 p-file-06)


    • Article last edited: 10/8/2013