|
|
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
| |