Archives of the TeradataForum
Message Posted: Thu, 24 Jan 2002 @ 16:18:11 GMT
We use a third party multi-dimensional reporting tool on top of our Teradata Relational database. Unfortunately, this tool can only process (pass to Teradata and wait for a reponse) one SQL statement at a time. Therefore, if a user generates a report which creates 15 SQL statements, the user must wait as long as it takes to execute these 15 statements sequentially.
I am interested in the idea of sending multiple SQL statements to Teradata via the front-end tool (assuming we can somehow disguise these multiple SQL statements to look like a single SQL statement to the front-end tool.)If we could do this, is it possible to execute these multiple SQL statements in parallel via a direct ODBC connection between the front-end tool and Teradata? I know that I can currently do this using the 'Execute Parallel' option in Queryman and using the ';' trick in BTEQ; however, I don't know what the syntax would need to look like via a direct ODBC connection.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|