Archives of the TeradataForum
Message Posted: Fri, 30 Jan 2004 @ 10:09:57 GMT
I got a solution to this problem & hence am posting it here for the benefit of others.
Since the characters are of variable bytes in a specific field Mload does not know when to take single byte or double byte or triple byte. So the solution could be to push all the chars in one temp table & then chop them from there using the SUBSTR function.
One solution for inserting all the chars is the input data file should be delimited with a character so that you can use VARCHAR instead of char in your layout.
Then you can have your layout with VARCHAR like
.field col1 * varchar(100) ---> 100 is here as an example. Value should be greater than your largest field above.
.IMPORT statement should be like this:
.Import infile unicode format vartext '|' Layout unicode2 apply INSERT
NOTE : This doesn't needs your Teradata to be Kanji-enabled !!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|