can i do data converson for column in fastload

Tools
Enthusiast

can i do data converson for column in fastload

Hi,

According to fastload limitations i found out as
Rule #6: No more than one data type conversion is allowed per column during a FastLoad. Why just one? Data type conversion is highly resource intensive job on the system, which requires a “search and replace” effort. And that takes more time. Enough said!

Now I wanted to take 1st 3 characters from a field.
lets say i have data like xyzklm. i want to insert xyz while loading to teradata table.
in fastload i am using substr(:var1,1,3). But it is throwing error "error 3618: Expression not allowed in Fast Load Insert, column columnname"

Please help

Thanks
3 REPLIES
Teradata Employee

Re: can i do data converson for column in fastload

Expressions are not allowed in the DML INSERT statement for the FastLoad protocol.
This is a Teradata Database restriction (hence the DBS error).
The FastLoad utility has no control over this.
-- SteveF
Enthusiast

Re: can i do data converson for column in fastload

If the column is defined in the table as char(3), it should just take the first 3 characters without complaining. (You cannot take anything else like the 2nd, 3rd, 4th).
Otherwise, use MLoad - this will take SQL expressions quite happily.
Enthusiast

Re: can i do data converson for column in fastload

Thanks..