All Forums Tools
tdice 55 posts Joined 01/11
23 Feb 2011
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

feinholz 1234 posts Joined 05/08
24 Feb 2011

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

Jimm 298 posts Joined 09/07
24 Feb 2011

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.

tdice 55 posts Joined 01/11
24 Feb 2011

Thanks..

You must sign in to leave a comment.