Archives of the TeradataForum

Message Posted: Thu, 08 Dec 2005 @ 20:38:09 GMT

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

For TEXT record formats, you need a record terminator at the end of each record. On the Windows platform that is Carriage return and line feed characters consecutive ('0D0A'xc). For UNIX, it is line feed ('0A'xc).

VARTEXT allows you to use column delimiters (i.e. pipe, comma, etc.), but you need the same record terminators as TEXT in order for the data to be parsed correctly.

You could use SET RECORD UNFORMATTED, but you have to account for all the bytes - including any record terminator.

     H1_ACCT    (CHAR  (09)),
     BASEINC1   (CHAR  (10)),
     BASEINC2   (CHAR  (10)),
     BASEINC3   (CHAR  (10)),
     CRLF       (CHAR  (02))

Kyle Prescott
UnumProvident

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