Archives of the TeradataForum
Message Posted: Thu, 18 Jul 2002 @ 12:55:10 GMT
| Subj: || || Re: MultiStatements |
| From: || || Geoffrey Rommel |
Michael Larkins wrote:
| ||It is my guess that you read about the ; trick but didn't notice that it was only a trick in BTEQ. The ODBC only see the commands as
individual, not necessarily related commands.|| |
Right, although it is possible for ODBC to issue multi-statement requests. I say this because Queryman does so (if you press F9
rather than F5) and because the ODBC Driver for Windows User's Guide says "The Teradata ODBC Driver permits multi-statement SQL requests."
But how or whether you could do that in VB, I don't know.