FDL4822 DEFINE statement rejected.

General
Enthusiast

FDL4822 DEFINE statement rejected.

Hi
Iam trying to load a small sample data using fast load..and Iam getting the following error..
Can any one help me please..

FDL4822 DEFINE statement rejected.

and log file is as follows:

0001 logon 127.0.0.1/dbc,

**** 17:27:42 Teradata Database Release: 13.00.00.00
**** 17:27:42 Teradata Database Version: 13.00.00.00
**** 17:27:42 Current CLI or RDBMS allows maximum row size: 64K
**** 17:27:42 Character set for this job: ASCII
**** 17:27:43 Number of FastLoad sessions connected = 2
**** 17:27:43 FDL4808 LOGON successful

0002 DEFINE

(EmpNo (smallint),
Name (VARCHAR(12)),
DeptNo (smallint),
JobTitle (VARCHAR(12)),
Salary (DECIMAL(8,2)),
YrsExp (BYTEINT),
DOB (DATE),
Sex (CHAR(1)),
Race (CHAR(1)),
MStat (CHAR(1)),
EdLev (BYTEINT),
HCap (BYTEINT))

FILE = /home/meta/bin/fastload_flatfile_01.txt;

**** 17:27:43 FDL4822 DEFINE statement rejected.
**** 17:27:43 Definition syntax error for:
===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================

**** 17:27:43 Logging off all sessions
**** 17:27:43 Total processor time used = '0.49 Seconds'
. Start : Wed Mar 24 17:27:42 2010
. End : Wed Mar 24 17:27:43 2010
. Highest return code encountered = '8'.
**** 17:27:43 FDL4818 FastLoad Terminated
Tags (1)
3 REPLIES
Teradata Employee

Re: FDL4822 DEFINE statement rejected.

There is unauthorized enclosing parenthesis on your define clause. Datataypes must be enclosed but not the whole definition
Enthusiast

Re: FDL4822 DEFINE statement rejected.

Hi Vador

I have corrected the script ...now I got succeeded Thanks
Teradata Employee

Re: FDL4822 DEFINE statement rejected.

hi 

i am facing the same problem.