Delimited File

Hello, I have a dlimited file that I'm reading in. The LRECL is fixed at 1600 bytes, however, there is no terminiating character on the end of the record. I have tried several different things to get this working. I have read in FILLER of 1600, used a redefine to force a '*' as a record terminator and I'm still getting the following error:
Error from Component 'RFM_Disguise_Data_fields', Partition 0
[M850]
Maximum record buffer size (5000000 bytes) exceeded.

If the data actually contains records larger than this, set the
configuration variable AB_MAX_RECORD_BUFFER to an appropriate value.

If the data does not contain such large records, then
either (1) The metadata does not accurately describe the data,
or (2) The data has somehow been corrupted.

I have also tried looking for \n for the record terminator with the same result. My record looks like:
string('|') var1;
string('|') var2;
string('|') var3;
string('*') FILLER3;
end('*') /* Enter your record definition here*/;

Thanks for your replies. There is no copybook. It's a pipe delimited file, so the field lengths are variable, but the file is fixed at 1600.

I have changed it a little and am now using the READ SEPERATE VALUES component and it's closer but I still have an error:
Error from Component 'Read_Separated_Values', Partition 0
[B1]
Error parsing record 1: Too few fields (88 found, expected 90).
[Hide Details] [Go to Component]

I have verified the number of fields in the record is 88. If I add a filler field and an end of record field, it looks for 92 fields.

I suspect your read separated values is not working because of your Area code fields in the DML. Try reading the whole phone number into a field and then in a Reformat split the Area code off to its own field if that is the requirement.
Also you could just apply the following dml to the source.

recordstring('|') LOAN_ID_IN;string('|') LN_PGM;string('|') LN_STATUS;string('|') DECLINE_TXT1;string('|') DECLINE_TXT2;date("YYYYMMDD")('|') APP_RCD_DTE;decimal('|') DISB1_AMT;decimal('|') DISB2_AMT;decimal('|') INT_REPAY_RATE;decimal('|') INT_DEFER_RATE;decimal('|') LOAN_GFEE_PCT;string('|') DEFER_OPTION;string('|') REPAY_TERM;date("YYYYMMDD")('|') DISB1_DTE;date("YYYYMMDD")('|') DISB2_DTE;date("YYYYMMDD")('|') STAT_CHNG_DTE;string('|') SSN;string('|') LAST_NAME;string('|') FIRST_NAME;string('|') PRI_ADDRESS_1;string('|') PRI_CITY;string('|') PRI_STATE;string('|') PRI_ZIP;string(3) PRI_AREA_CODE;string('|') PRI_PHONE;date("YYYYMMDD")('|') BIRTH_DTE;decimal('|') PRI_INCOME;string('|') RESID_CD;string('|') CRED_BUR;string('|') CRED_SCORE;string('|') COAPP_SSN;string('|') COAPP_LAST_NAME;string('|') COAPP_FIRST_NAME;string('|') COAPP_ADDRESS_1;string('|') COAPP_CITY;string('|') COAPP_STATE;string('|') COAPP_ZIP;string(3) COAPP_HOME_AREA_CD;string('|') COAPP_PHONE_NUMBER;date("YYYYMMDD")('|') COAPP_BIRTH_DATE;decimal('|') COAPP_INCOME;string('|') COAPP_RESID_CODE;string('|') COAPP_CREDIT_BUR;string('|') COAPP_CREDIT_SCORE;string('|') GRADE_LEVEL;date("YYYYMMDD")('|') ANT_GRAD_DTE;string('|') SCHOOL_DOE_CD;string('|') SCHOOL_NAME;string('|') SCHOOL_CITY;string('|') SCHOOL_STATE;string('|') SCHOOL_ZIP;string('|') DISB_CAL;string('|') TRACK_CD;string('|') HEARDFROM;string('|') REFERRER_HOST;decimal('|') LOAN_AMT_REQ;date("YYYYMMDD")('|') F_RECD_DT;decimal('|') LOAN_AMT_APPRV;string('|') EMAIL_ADDRESS;string('|') APP_SOURCE_CD;string('|') EDOC_AUTH;string('|') OPER_CD;string('|') TIER_GUAR;date("YYMMDD")('|') LOAN_PD_FROM_DTE;date("YYMMDD")('|') LOAN_PD_TO_DTE;string('|') CURR_EMPLOYER;string('|') COAPP_CURR_EMPLOYER;string('|') TIER_SCEN;string('|') TIER_SCEN_CD;string('|') AGENCY;decimal('|') DISB3_AMT;decimal('|') DISB4_AMT;date("YYMMDD")('|') DISB3_DTE;date("YYMMDD")('|') DISB4_DTE;string('|') RECOURSE_IND;decimal('|') RECOURSE_AMT;string('|') BO_MI_TXT1;string('|') BO_MI_TXT2;string('|') BO_MI_TXT3;string('|') BO_MI_TXT4;string('|') BO_MI_TXT5;string('|') COAPP_MI_TXT1;string('|') COAPP_MI_TXT2;string('|') COAPP_MI_TXT3;string('|') COAPP_MI_TXT4;string('|') COAPP_MI_TXT5;string('|') ESIGN_ELIG;string('|') ESIGNED_BY;string('|') GUAR_CD;string('|') CITIZEN_CD;string('\n')FILLER;
end /* Enter your record definition here*/
This way if the data is shorter than the 1600 record length the FILLER field will hold the extra whitespace. Just to let you know that if the data in the source file has a record length of 1600 and the data within the file could exceed 1600 there could be a problem in the future in your processing. Especially with address information..
If each field in your source has padded space in the field to make it fixed length even though there are delimiters read the data in as fixed length like the following example.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.