Archives of the TeradataForum

Message Posted: Mon, 19 Nov 2007 @ 12:49:24 GMT

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

<-- Anonymously Posted: Mon, 19 Nov 2007 17:36 -->

Hi All,

I had an experience where one of the field defined had a length of 31K characters and even SQL assistant had failed to give the output. Suggest to use Trim command for the same.

Alternatively you can use spanned records as follows

     DCB=(RECFM=VBS,LRECL=32760,BLKSIZE=32756,DSORG=PS),

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