Fastload error

Tools
Enthusiast

Fastload error

Hi All!!

We have our teradata database on UNIX server. And recently we had teradata version upgrade from 6 to 7.

I am working on a Teradata fastload script that worked correctly with out any error. But giving an error when executed in new version.

The fastload script is as follows:

.logon USER_ID/PASS_WD,

.LOGTABLE ERR_DB.TABLE_NAME ;

DROP TABLE ERR_DB.UV_table_name ;
DROP TABLE ERR_DB.ET_table_name ;

DELETE FROM DB.table_name ;

set record unformatted;

define
emp_id (CHAR(12) ),
org_name (CHAR(50) , NULLIF = '*'),
prv_zip (CHAR(5) , NULLIF = '*'),
last_nm (CHAR(40) , NULLIF = '*'),
frst_nm (CHAR(20) , NULLIF = '*'),
prof_pfx (CHAR(4) , NULLIF = '*'),
address (CHAR(50) , NULLIF = '*'),
city_nm (CHAR(50) , NULLIF = '*'),
newlinechar (CHAR(1))

file=file_name;
show;

begin loading DB.table_name errorfiles ERR_DB.ET_table_name, ERR_DB.UV_table_name
checkpoint 0 ;

insert into DB.table_name (
emp_id,
org_name,
prv_zip,
last_nm,
frst_nm,
prof_pfx,
address,
city_nm

) VALUES (
:emp_id,
:org_name,
:prv_zip,
:last_nm,
:frst_nm,
:prof_pfx,
:address,
:city_nm
) ;

end loading;

logoff;


Encountering the error "syntax error at line 13 : `(' unexpected ".

Googled this issue to find exact reason. Found few posts which say the error is due to "OS version".

Does any one has something to say about this?

Thanks in advance!
Sanjay!
1 REPLY
Enthusiast

Re: Fastload error

.LogTable is a Multiload command, not Fastload. The rest of the script looks like Fastload though.

Try removing the Logtable command and try again.
If you still have a problem, show the output, not the input. Then we can see which is line 13 (Line 13 is rarely the 13th line in the script - it is not that easy.)