Archives of the TeradataForum

Message Posted: Thu, 11 Aug 2005 @ 15:58:36 GMT

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

Swapnil,

You have to export fixed width datatypes to get fixed width output. The 'junk characters' are the length of the variable length filed following. Simply cast to fixed width

For example

     Col1 is varchar(14)

     Cast it to full length.

     Cast(col1 as char(14))

This will make your ouput files really big.

Something else to check for space and performance. You may also want to check if the datatypes in the table. Don't use varchar if the columns is almost always at the max level. This is because varchar takes two extra bytes to indicate the length. So if column was varchar(3) and contents were ABC it would take 5 bytes to store instead of 3 if it was char(3)

For example,

There is a section in one of the Database Management manuals describing how to make the choice. Don't have time to find it right now.

Thanks,

Bob Diehl

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