Archives of the TeradataForum

Message Posted: Fri, 06 Jan 2006 @ 15:37:40 GMT

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

Baskaran's answer is correct. The reason is that "show table", for reasons I cannot fathom, returns a single row with carriage returns (\r). When you display these in Unix, they return the cursor to the beginning of the line without advancing to the next line; hence you see only the last "line", along with leftover junk from previous lines. Just s/\r/\n/g and the problem is solved.

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