Archives of the TeradataForum

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

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

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>>