Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Limit on record length in comma delimited?

Status
Not open for further replies.

kiddpete

MIS
Oct 9, 2003
788
US
We are attempting to read a comma delimited file with a SUFFIX=COM master. All works well until the data in the record pushes out to column 145 or beyond. When that happens, we get this message:

(FOC416) MORE VALUES SUPPLIED THAN FIELDS IN THE MASTER FILE DESCRIPTION

If we then break the record into two records, with no data in 145 or beyond, everything works fine again.

Is 144 the record length limit for this kind of file? Is there any way around it?
 
Try a $ sign at the end of each record to delimit it. so a record would be:
field1, field2,lastfield,$
 
The records already have a $ sign at the end of the record. The problem deals with the length of the record, not the format of the file.
 
That message normally means that there are more comma-separated fields on the incoming file than have been specified on the master file desc.
I've used csv files wider that 144 (VM/CMS platform).
 
Yes, but there are not more values. If we delete some digits from individual numbers, without deleting the number, the record is successfully read. Ditto is we split the record in two with each part less than 145 positions.

Processing is on MVS.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top