p_file_03: excessive output files for z00p table
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
Why does the p_file_03 job create so many output files for the z00p table?
There are only 335,193 z00p records in abc50, but we already have 30 output files (z00p.seqaa - z00p.seqbd).
Resolution:
The Oracle z00p table is in CLOB format, while these sequential files are not. The z00p has the fields in xml format.
From z00p.seqaa:
<datafield tag="010" ind1=" " ind2=" ">
<subfield code="a">2008008259</subfield>
</datafield>
This is 87 bytes. The same tag in the z00 would be only 16 bytes.
- Article last edited: 10/8/2013