Archives of the TeradataForum

Message Posted: Wed, 26 Jun 2013 @ 08:05:18 GMT

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

Adhoc is designed as a simple mechanism to test the proper setup of the TD ODBC driver utility. It isn't really (IMHO) intended to be a proper client utility and doesn't have the functions you require.

If you really have to use adhoc, you have 2 options:

1) Modify the source code and add the function you need to export the result set (I believe it comes with source code because last time I used it, I had to "make" it).

2) Redirect adhocs output to a file and use that (./adhoc > output.txt

A much better option would be to use the client utility that is intended to support these functions. Specifically try using bteq. I'll leave it to you to read the manual, but have a look at the ".export" command in the manual.

Regards

Glenn Mc

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