Archives of the TeradataForum

Message Posted: Sun, 04 Aug 2002 @ 00:38:42 GMT

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

You know Teradata, to save space, groups all the varchar fields together in a row at one place and for each varchar field it allocates an additional 2 bytes which contain the address of the start of the varchar field. This is an overhead but saves a lot of space. You will find this 2 bytes for each varchar field.

YOu will get it if you are using the mode INDICATOR. If you just want to load the data in some Teradata table, just go ahead and use MLOAD of FastLoad. Teradata utilities recognise these 2 bytes internally. But if you are using this for some report generation then use the MODE RECORD but you will have to cast each field as character based on the filed length which you will find in Queryman in show definition.

ROHIT REVO

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