Multi Statement Request

[Guest_imported]

Has anyone succesfully submitted a multi-statement request (all inserts) through ODBC? I've gotten several different answers from NCR consultants on this. Any experiences would be helpful.
Thanks

 

[davidw03]

A multi-statement request is done by putting the semi-colon on the same line as the next statement. In other words, the next statement must appear after the semi-colon and on the same line. The multi-statement is a Unit-of-Work, meaning that it all completes or it all rollbacks. So be carefull, if the last statement abends, then the entire request will rollback.

 

[Patten]

If you are working with queryman, you could process statements in the query window as multi-statements by pressing the "double-feet" button: it will execute your request in parallel.

 

[RanD]

Yes.

QMan uses ODBC.
As stated previously in this thread, (but clarified here with example), finish the first statement with a ';' on the next line immediately followed by the second statement, for example...

sel count(*) from tableA
; sel count(*) from tableB
; sel count(*) from tableC
;

You can use either the 'two feet' or 'four feet' buttons - execute and execute parallel, respectively to process.

If you want an explicit transaction, you could do the following:

BT
;sel count(*) from tableA
; sel count(*) from tableB
; sel count(*) from tableC
;ET
;

Regards
RanD
(Randy Volters, certified Teradata Master
email: randvol0826@aol.com)