Cannot find the full path for file

Tools

Cannot find the full path for file

Hi

I am new to teradata.

I am getting this error while using fastload in ETL tool..

"Cannot find the full path for file "

But when i searched whole teradata installation i didnt find this file..
Can someone please help me?

Thanks
Hari
1 REPLY
Enthusiast

Re: Cannot find the full path for file

Are you using a flat file with your fastload? If so, the error could be pertaining to the path of the file. Here's a sample fastload script:

Logon "database"/"User_Name", "password";

Create Table Sql00.Employee_Table02
(
Employee_No Integer
, Dept_No SmallInt
, Last_Name Char(20)
, First_Name Varchar(12)
, Salary Decimal(8,2))
UNIQUE PRIMARY INDEX (Employee_No);

DEFINE Employee_No (INTEGER)
, Dept_No (Smallint)
, Last_Name (Char(20))
, First_Name (Varchar(12))
, Salary (Decimal(8,2))
File = C:\temp\Fastload_Flat_File01.txt; /* you need to list the entire path of the file. */

BEGIN Loading SQL00.Employee_Table02
ERRORFILES Sql01.De_Err1, Sql01.D_err2
CHECKPOINT 1000000;

INSET INTO SQL00.Employee_Table02 VALUES
(: Employee_No
, : Dept_No
, : Last_Name
, : First_NAme
, : Salary);

END LOADING;

LOGOFF;

Be sure to list the entire path of the flat file. Be sure to include your c:\ (or whatever directory the file is under) and your '.txt' .