• 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