Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 25 May 2005 @ 16:15:12 GMT


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


Subj:   Re: Error while importing a file in bteq
 
From:   Praveen_Chakrapani

Hi Dhanraj,

If your using .import data the file should be in BTEQ export or FastExport format. Instead of .import data file = emps try using .import vartext file = emps

A note from BTEQ reference guide:

DATA,INDICDATA :
If DATA or INDICDATA is specified, BTEQ expects the incoming data to be in FastLoad format, such as that produced by a BTEQ EXPORT DATA or BTEQ EXPORT INDICDATA command, or by FastExport.

REPORT:
If the REPORTformat is specified, BTEQ expects the incoming data to be in the format produced by a BTEQ EXPORT REPORT command.

VARTEXT:
record format as variable length character fields


Regards,

Praveen



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016