 |
 |
Archives of the TeradataForum
Message Posted: Thu, 16 Dec 1999 @ 18:21:04 GMT
| Subj: | | Re: Return char data longer than 254? |
| |
| From: | | Randy Heldt |
Michael,
Attached is a C program I wrote over four years ago to execute queries against Teradata and return the data regardless of the size
(width). This program reads standard input and expects to see a logon card first. It then submits the proceeding statements to
Teradata and returns the result without any formatting. This could easily be modified to place commas between the fields returned.
This was successfully compiled and executed on NCR Unix MP-RAS. I'm really not much of a C programmer and I borrowed most of the
code from an example I found in a Teradata manual (maybe the CLI manual). But it has come in handy when trying to retrieve data from
fields > 254 characters on UNIX.
Randy Heldt
Teradata Solutions Group
NCR Corporation
| |