BTEQ Import Error: Import data record not terminated with LF or CF

Tools & Utilities

BTEQ Import Error: Import data record not terminated with LF or CF

I am trying to import a file which was exported from another td db using:

Teradata BTEQ 13.00.00.09 for WIN32. Enter your logon or BTEQ command:

.logon td/admin

.logon td/admin

Password:

 *** Logon successfully completed.

 *** Teradata Database Release is 13.10.04.11

 *** Teradata Database Version is 13.10.04.11

 *** Transaction Semantics are BTET.

 *** Character Set Name is 'ASCII'.

 *** Total elapsed time was 1 second.

 BTEQ -- Enter your DBC/SQL request or BTEQ command:

.EXPORT DATA FILE = exporttest12

.EXPORT DATA FILE = exporttest12

 *** To reset export, type .EXPORT RESET

 BTEQ -- Enter your DBC/SQL request or BTEQ command:

select DatabaseName, TableName, TableKind, RequestText, RequestTxtOverflow from

dbc.tables;

select DatabaseName, TableName, TableKind, RequestText, RequestTxtOverflow

from dbc.tables;

 *** Success, Stmt# 1 ActivityCount = 124516

 *** Query completed. 124516 rows found. 5 columns returned.

 *** Total elapsed time was 1 second.

 BTEQ -- Enter your DBC/SQL request or BTEQ command:

.logoff

.logoff

 *** You are now logged off from the DBC.

 Teradata BTEQ 13.00.00.09 for WIN32. Enter your logon or BTEQ command:

Now when I try to import the file 'exporttest12' using a script I am getting the Import data record error: Actual output as follows:

c:\dell>bteq < importtest.bat

BTEQ 13.10.00.01 Wed Jan 23 14:11:26 2013

+---------+---------+---------+---------+---------+---------+---------+----

.SESSIONS 2

+---------+---------+---------+---------+---------+---------+---------+----

.LOGON 10.1.0.137/user,

 *** Logon successfully completed.

 *** 2 Sessions logged on.

 *** Teradata Database Release is 13.00.00.19

 *** Teradata Database Version is 13.00.00.19

 *** Transaction Semantics are BTET.

 *** Session Character Set Name is 'ASCII'.

 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----

.IMPORT DATA FILE = c:/user/exporttest12

+---------+---------+---------+---------+---------+---------+---------+----

.REPEAT *

+---------+---------+---------+---------+---------+---------+---------+----

USING DatabaseName (CHARACTER(30)),

                 TableName (CHARACTER(30)),

                 TableKind (CHARACTER(1)),

                 RequestText (VARCHAR(12500)),

                 RequestTxtOverflow (CHARACTER(1))

INSERT INTO dell.tables

VALUES ( :DatabaseName,

        :TableName,

        :TableKind,

        :RequestText,

        :RequestTxtOverflow );

 *** Starting Row 0 at Wed Jan 23 14:11:26 2013

 *** Growing Buffer to 27402

 *** Error: Import data record not terminated with LF or CF

            using record size of 27402 !

 *** Warning: Out of data.

 *** Ok, Session 1113, Request 3, Statement# 1

 *** Insert completed. One row added.

 *** Finished at input row 1 at Wed Jan 23 14:11:26 2013

 *** Total number of statements: 1,  Accepted : 1,  Rejected : 0

 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----

.LOGOFF

 *** You are now logged off from the DBC.

+---------+---------+---------+---------+---------+---------+---------+----

.QUIT

 *** Exiting BTEQ...

 *** RC (return code) = 0

Please help... I don't know why it should be failing... import/export of the same on the my local td works fine with the same.