Archives of the TeradataForum
Message Posted: Tue, 14 Dec 1999 @ 19:23:18 GMT
| Subj: || || Return char data longer than 254? |
| From: || || Michael McIntire |
Has anyone written a general CLI application to execute and return data in a comma delimited format? User wants data returned in all
ascii format, and the record length is greater than 254 (hence, BTEQ cannot be used).
The real question is: How can you return all char data with record lengths greater than 254 - without using fastexport. Currently, the
developers are casting and concatenating 80 columns into a single char(586) record. ODBC on unix is not an option.