Archives of the TeradataForum

Message Posted: Wed, 17 Jul 2002 @ 18:41:27 GMT

I need to update around 2500 rows, in a single shot from VB through ODBC(sent as calls to Upsert Macros). One option I am investigating
is using MultiStatements (i.e. putting each statement in a new line beginning with a semicolon).

However, when I tried to execute with or without the semicolon, there didnt seem to be any performance difference.

How can I ascertain that the query will be executed in parallel? Is there any limitation (a) in the number of statements? (b) length of
string that the ODBC connection can handle.