Archives of the TeradataForum

Message Posted: Tue, 07 Nov 2006 @ 16:35:17 GMT

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

Geoffrey Rommel writes:

Sounds like good plan this x'1F' separator. Trouble is, we can't seem to get the

     SET RECORD VARTEXT "value";

to work with x'1F'. We've tried a few obvious combinations, including pasting the value in between the double quotes, each to no avail.

Geoffrey, have you managed to use this approach, or do you know if it's a documented approach ?

The way things are going, it looks as though we'll need to go for fixed position on the input file.

By the way, thanks for all your different suggestions - as usual.

Dave Clough
Database Designer
Express ICS

www.tnt.com

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