Archives of the TeradataForum

Message Posted: Fri, 30 Jan 2004 @ 10:09:57 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi again,

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 !!

Thanks, Vivek.

	<Prev	Next>		<<First	<Prev	Next>	Last>>