Archives of the TeradataForum

Message Posted: Thu, 24 Dec 2009 @ 16:21:46 GMT

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

It is difficult to provide a solution without knowing what script you are running and what platform and how you are running etc. Also my preference is, instead of executing 'Select * ' type out the fields properly some thing like below:

     SELECT FIELD_1 (CHAR(50),
     DATE_FIELD (DATE, FORMAT 'YYYY-MM-DD') (CHAR(10), BLA BLA FROM MYTABLE;

As you are saying below about chopping off the record, ensure you set a Width statement some thing like this:

     .SET WIDTH 5000

HTH!

Thanks

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