Archives of the TeradataForum

Message Posted: Fri, 13 Oct 2006 @ 08:25:11 GMT

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

Vinay,

I saw the column contents you posted in the master's forum .......

     >>>Char2HexInt(Col)? ?????????????? Count(*)
     >>>202020202020202020???????? 8979773
     >>>000000002020202020???????? 1068394
     >>>000000000020202020???????? 77

If I read it right, you are having NULL's in front of spaces, which I suspect is causing the TRIM function to misbehave ( I guess that's true for any Unix/Windows based programs )......

My best guess is this ..... This data is probably getting loaded from mainframe, and those folks are not doing a good job in their load modules (my MF know-how is limited but I have had MF developers make my life miserable in the past because of sending nulls in the data to Unix boxes ... I used to open it up in VI editor / octal dump etc to figure out what's going on .............. )

But if I were you that's where I am going to look ........ and probably you need a way to get rid of the nulls in front of the data for that column .. TRIM certainly doesn't look like the candidate .... .

And as far as I know no matter if you insert one space or two space or whatever it should get stored and treated as nine spaces ...... so I vote NULLs ......

Joseph Vinish D'silva

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