If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
QMF: I’ve not used it in years but in the past, it was limited to one query at a time if executed interactively though in batch, multiple were allowed. See the manuals (free to download from http://www.ibm.com) for how to set up batch job streams.
SPUFI: to add to what the prior responders entered; if you are including DDL with the queries, you will need a COMMIT after the DDL. For example:
CREATE INDEX ……
;
COMMIT
;
SELECT ……
;
But you do not need the COMMITs between DML. You can INSERT and then SELECT against what you inserted without the COMMITs, just like any any application program.
qmf:one query can be executed at a time,this are create form(changing coloumn names),autocommoit are default option yes.
spufi:multiple querys can be executed at a time,this are not create forms,autocommit yes/no can be set.
Continuing–
In SPUFI terminate each query with a ‘;’
select * from tab1;
select * from tab2;
QMF: I’ve not used it in years but in the past, it was limited to one query at a time if executed interactively though in batch, multiple were allowed. See the manuals (free to download from http://www.ibm.com) for how to set up batch job streams.
SPUFI: to add to what the prior responders entered; if you are including DDL with the queries, you will need a COMMIT after the DDL. For example:
CREATE INDEX ……
;
COMMIT
;
SELECT ……
;
But you do not need the COMMITs between DML. You can INSERT and then SELECT against what you inserted without the COMMITs, just like any any application program.
Bill
In QMF you can save your queries into a PROCEDURE and then
run the procedure.
Ex. a procedure saved as PROC1 can contain the following :
run query Q1 ….
run query Q2 ….
….etc
qmf:one query can be executed at a time,this are create form(changing coloumn names),autocommoit are default option yes.
spufi:multiple querys can be executed at a time,this are not create forms,autocommit yes/no can be set.