Archives of the TeradataForum
Message Posted: Fri, 06 Jan 2006 @ 16:24:57 GMT
Subj: | | Re: Line feed '0A'x NOT returned in SHOW VIEW/TABLE |
|
From: | | Dempsey, Mike |
Teradata always returns '0D'x as the 'Line End' string.
This of course works great on an IBM mainframe (Teradata's original target customers) but not so well on Unix/Windows.
My apps (SQL Assistant etc.) anticipate this and automatically convert all '0D'x characters to '0D0A'x.
I am not aware of any switch/option to change this behavior so you will probably need to perform a similar global change on the output string.
(There was a similar thread recently for Unix.)
Mike Dempsey
Teradata Client Tools
|