All Forums Tools
Kishore_1 208 posts Joined 03/10
17 Jul 2010
Help Needed on bteq export/import option


I am using the bteq import export option,I have followed the following steps in order:

Step 1
export data from table to file

.set width 900
.export data file=myoutput.txt
Select item_id from
sample 10;

.export rest;

Step 2
creating a new table

create table db.tab2
(item_id integer)

Step 3
import data from file to table

.import data file=myoutput.txt,skip=3
.quiet on
.repeat *
using item_id(integer)
insert into db.tab2

The contents of file myoutput.txt is in unreadable format.
How to get rid of this?
But data is getting inserted into the newly created table.
How is this possible?

dnoeth 4628 posts Joined 11/04
19 Jul 2010

You specified DATA in your expart command.

This is Teradata's internal binary format,
e.g. INT -> 4 byte, FLOAT -> 8 Byte IEEE format

Of course you could export/inport text, but DATA or INDICDATA is the best way for import/export from/to Teradata, using lowest resources.



maheshkumittal 2 posts Joined 11/11
10 Nov 2011

Hi I am using the below commands in BTEQ for export and import :
.EXPORT DATA FILE=C:\Data\ProdLoads.dat;
.IMPORT data FILE=C:\Data\ProdLoads.dat,SKIP 1;

I am getting the below output for export :
*** Success, Stmt# 1 ActivityCount = 107
*** Query completed. 107 rows found. 22 columns returned. But the data is not exported to the file.

While importing it gives the error as :
*** Growing Buffer to 17263
*** Error: Import data record not terminated with LF or CF
using record size of 17263 !
*** Warning: Out of data.

CarlosAL 512 posts Joined 04/08
10 Nov 2011

You cannot use the same file to EXPORT and IMPORT as the same time (without an EXPORT RESET between them).



baji 1 post Joined 03/13
10 Mar 2013

hai iam new to teradata.when iam importing my file to table iam getting the following error.please help me
.sessions 5;
.import data file=D:\input.dat;
using custid  (integer),
income        (integer),
age           (smallint),
yearswithbank (smallint),
nbrchildren   (smallint),
gender        (char(1))
insert into cust
cust_id  ,
income  ,
age     ,      
:gender     );
 *** Error: Use IMPORT to open a file first before
           trying to read from it.
 *** Failure 3593 No DATA parcel sent and request uses a USING clause.
                Statement# 1, Info =0
 *** Total elapsed time was 1 second.

You must sign in to leave a comment.