Archives of the TeradataForum
Message Posted: Fri, 06 Jan 2006 @ 15:37:40 GMT
| Subj: || || Re: Perl, DBD::ODBC and 'Show Table'. |
| From: || || Geoffrey Rommel |
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.