Archives of the TeradataForum

Message Posted: Fri, 24 Feb 2006 @ 10:59:06 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All..

I am trying to write a fast load script to load some sample 7 records, but I am getting the error: I/O Error on File Read: 35, Text: EOF encountered before end of record. I don't have any clue on this. Please help me in this regard.

Script and sample data file follows for the reference.

Script is:

     SESSIONS 4;
     ERRLIMIT 25;
     LOGON DemoTDAT/dbc,dbc;
     DROP TABLE customer_service.contact;
     DROP TABLE customer_service.Error1;
     DROP TABLE customer_service.Error2;

     CREATE TABLE customer_service.contact, FALLBACK
     (contact_number INTEGER
     ,contact_name CHAR(30) NOT NULL
     ,area_code INTEGER NOT NULL
     ,phone INTEGER NOT NULL
     ,extension INTEGER
     ,last_call_date DATE FORMAT 'YY/MM/DD' NOT NULL)
     UNIQUE PRIMARY INDEX (contact_number);

     SET RECORD VARTEXT;

     DEFINE contact_number (varchar(10)),contact_name (VARCHAR(30))
     ,area_code (varchar(16)),phone (varchar(16)),extension (varchar(15))
     ,last_call_date (varchar(10))

     FILE=c:\parm.txt;

     SHOW;

     BEGIN LOADING customer_service.contact ERRORFILES
     customer_service.Error1,customer_service.Error2;

     INSERT INTO customer_service.contact
     (contact_number,contact_name,area_code,phone,extension
     ,last_call_date)
     VALUES
     (:contact_number,:contact_name,:area_code,:phone,:extension
     ,:last_call_date
     );

     END LOADING;
     LOGOFF;

Record sample is:

     |8007|Smith,Ginny   |408|3792152|333|88/08/05|
     |8010|Brayton,Connie|408|1112345|112|87/07/21|
     |8005|Hughes,Jack   |212|5432126|710|87/08/05|
     |8001|Leblanc,James |805|2213456|221|87/08/01|
     |8008|Torres,Alison |802|5487890|444|88/08/14|
     |8015|Dibble,Nancy  |602|2713387|652|88/08/09|

Thanks in advance..

Regards,

Kishore

	<Prev	Next>		<<First	<Prev	Next>	Last>>