z00p_str field sometimes null
- Article Type: General
- Product: Aleph
Description:
p_publish_04 seems to have run successfully. The z00p records which it has produced sometimes have data in the z00p_str field, but in other cases this field is null. Why is this?
Resolution:
As described in the Z00P.pdf document, the z00p_str field contains the published record if its length is less than 4000 bytes. If its length is 4000 bytes or more, then it is stored in the z00p_ptr field.
The Z00P_STORAGE_TYPE field indicates which is used in a particular z00p:
V = Stored in Z00P-STR
C – Stored in Z00P-PTR
Note: the z00p_ptr field is in CLOB format. See KB 16384-19057 for information on the use of "set long" to view the data in CLOB fields.
- Article last edited: 10/8/2013