There is a mismatch between the number of data fields in dbname.ch.txt (16) and the number of fields in the header record when specifying -verbose (17).
Everything lines up up to Tenancy #, but in the data records it is followed by a character field and then a numeric field. Whereas in the header there are two character fields between those two numeric fields:
|"Tenancy #"|"Partition Policy"|"Partition"|"Partition #"|
So is it the case that the Partition Policy field or the Partition field is missing from each data record, or is there an extra field name in the header record that shouldn't be there?
BTW this is in 11.5.
There is a mismatch between the number of data fields in dbname.ch.txt (16) and the number of fields in the header record when specifying -verbose (17).
Everything lines up up to Tenancy #, but in the data records it is followed by a character field and then a numeric field. Whereas in the header there are two character fields between those two numeric fields:
|"Tenancy #"|"Partition Policy"|"Partition"|"Partition #"|
So is it the case that the Partition Policy field or the Partition field is missing from each data record, or is there an extra field name in the header record that shouldn't be there?
Flag this post as spam/abuse.
There is a mismatch between the number of data fields in dbname.ch.txt (16) and the number of fields in the header record when specifying -verbose (17).
Everything lines up up to Tenancy #, but in the data records it is followed by a character field and then a numeric field. Whereas in the header there are two character fields between those two numeric fields:
|"Tenancy #"|"Partition Policy"|"Partition"|"Partition #"|
So is it the case that the Partition Policy field or the Partition field is missing from each data record, or is there an extra field name in the header record that shouldn't be there?
Flag this post as spam/abuse.
Thanks Rich. This result was from a sports DB. I'll try again with my application DB.
Confirmed, with Type II storage the chain csv file contains 16 fields per record for the control and schema areas and 17 fields per record for Type II data areas.