Archives of the TeradataForum
Message Posted: Thu, 23 Feb 2006 @ 20:18:30 GMT
| Subj: | | Re: ODBC Queries repeated |
| |
| From: | | Bob Hahn |
ODBC itself supports multi-statement requests--SQL Assistant has limited support as Mike described.
Is BTEQ possible for your users? It supports multi-statement requests and delimited data (vartext) and multiple sessions.
With a little coding, one could create a custom program using ODBC, OLEDB, JDBC. All support Teradata multi-statement requests via Parameter
Markers (Chapter 6). There is a limit of 2549 parameters per request for V2R5 and above. As Dieter mentioned V2R6 added Parameter Array support
and JDBC 03.03 and above can exploit it.
For custom via PERL perhaps Dean Arnold's or Geoffrey Rommel's 'freeware' Perl interface to Teradata
| |
 |
|
 |
|
| |
<Prev |
Next> |
|
<<First |
<Prev |
Next> |
Last>> |
|
| 
