I/o Error On File Read 35
All communityThis categoryThis boardKnowledge baseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for Search instead for Did you mean: Teradata : Product Forums : Database : Fastload File read: 35, Text: EOF encountered befo... Options Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page Malleshkr Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 09-12-2012 02:27 AM 09-12-2012 02:27 AM Fastload File read: 35, Text: EOF encountered before end of record I have a scenario here. I get the an error when my source CSV contains data in below format & hence my fastload is unable to process it. "February 29, 2012","","","","","15/3/2012","22/3/2012","Packaging :: Departure Point :: LON","","15",1,1,0,0.00 "February 29, 2012","","","","","16/5/2012","20/5/2012","Packaging :: Departure Point :: LON","","77",1,1,0,0.00 "February 29, 2012","","","","","19/4/2012","22/4/2012","Packaging :: Departure Point :: LON","","50",0,1,0,0.00 I feel its cause my source data has some quotes. Can you please help me with this? Error: I/O Error on File Read: 35, Text: EOF encountered before end of record Highest return code encountered = '12' _Mallesh 0 Kudos Reply All forum topics Previous Topic Next Topic 5 REPLIES Qaisar_Kiani Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 09-13-2012 03:23 AM 09-13-2012 03:23 AM Re: Fastload File read: 35, Text: EOF encountered before end of record What is the record type you are using? I think you should use SET RECORD VARTEXT Is there any line break after your last record? 0 Kudos Reply Malleshkr Enthusiast Options Mark as New Bookmark Subscribe Subscribe t
turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for Search instead for Did you mean: Teradata : Product Forums : Database : Fload from csv file Options Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page Highlighted Kishore_1 Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 01-13-2011 04:02 http://community.teradata.com/t5/Database/Fastload-File-read-35-Text-EOF-encountered-before-end-of-record/td-p/20301 AM 01-13-2011 04:02 AM Fload from csv file Hi,I am running the following fastload script to read from a csv file:SHOW VERSION ; SESSIONS 4; ERRLIMIT 2000; logon tdpid/username,password;drop table DBNAME.Bday_reminder ;create table DBNAME.Bday_reminder ( First_Name VARCHAR(50), Last_Name VARCHAR(50), Mail_Id VARCHAR(50), Emp_id INTEGER, Extn_No INTEGER, Mobile_No INTEGER, Mobile_No_Home INTEGER)PRIMARY INDEX Bday_reminder ( Emp_id );SET RECORD vartext " "; define http://forums.teradata.com/forum/database/fload-from-csv-file First_Name (VARCHAR(50)) , Last_Name (VARCHAR(50)), Mail_Id (VARCHAR(50)), Emp_id (VARCHAR(6)), Extn_No (VARCHAR(5)), Mobile_No (VARCHAR(10)), Mobile_No_Home (VARCHAR(15))file=BDay.csv; SHOW; drop table DBNAME.err_1 ;drop table DBNAME.err_2 ;BEGIN LOADING DBNAME.Bday_reminder errorfiles DBNAME.err_1, DBNAME.err_2; insert into DBNAME.Bday_reminder ( First_Name , Last_Name , Mail_Id , Emp_id , Extn_No , Mobile_No , Mobile_No_Home )VALUES(:First_Name ,:Last_Name ,:Mail_Id ,:Emp_id ,:Extn_No ,:Mobile_No ,:Mobile_No_Home );END LOADING;logoff;The csv file is tab delimited.I am getting the following error:**** 11:22:38 Number of recs/msg: 336**** 11:22:38 Starting to send to RDBMS with record 1**** 11:22:38 I/O Error on File Read: 35, Text: EOF encountered before end of recordCan anyone help me out where the error is and what's the solution ?Thanks in AdvanceKishore Everyone's tags (3): eof encounterederrorfastload 0 Kudos Reply All forum topics Previous Topic Next Topic 2 REPLIES teradater Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 01-13-2011 06:04 AM 01-13-2011 06:04 AM Re: Fload from csv file This is from "Message" pdf document:35 EOF encountered before end of recordExplanation: The end-of-file was reached before
FILE STATUS KEYS / CODES: File status Codes beginning with a '0' are considered Successful execution. Codes beginning with a '1' are considered "at end" messages, those beginning with a '2' are considered "invalid http://ibmmainframes.com/references/a27.html key" messages, File Status Codes beginning with a '3' are considered "Permanent Errors", keys like '4x' are "Logical Errors" and '9x' are "Implementer defined". Code Statements Description of the Code https://www.storagecraft.com/support/forum/backup-failure-error-message-31-device-attached-system-not-functioning 00 ALL Successful completion 01 - Not a valid File Status Key. 02 READ WRITE REWRITE "DUPLICATE KEY", Indexed files only. The input-output statement i/o error was successfully executed, but a duplicate key was detected. A duplicate key exist for at least one alternate key for which duplicates are allowed. Possible causes: For a READ statement, the key value for the current key is equal to the value of that same key in the next record in the current key of reference. For a WRITE or REWRITE statement, the record i/o error on just written created a duplicate key value for at least one alternate record key for which duplicates are allowed. 03 - Not a valid File Status Code. 04 READ "Record length Mismatch". A READ statement was successfully executed, but the length of the record being processed did not conform to the fixed file attributes for that file. It means the size of the record just read does not agree with the size specified in the program. 05 OPEN DELETE "Missing Optional file". An OPEN statement is successfully executed but the referenced optional file is not present at the time the OPEN statement is executed. The file has been created if the open mode is I-O or EXTEND. If this happened on a DELETE FILE then the file was not found. This does not apply to VSAM sequential files. 06 WRITE Attempted to write to a file that has been opened for INPUT. 07 CLOSE OPEN "Referenced file is not on a TAPE device". Sequential files only. For a CLOSE statement with the NO REWIND, REEL