execution of multiple querries with SPUFI and QMF tools

Tags:
390
IBM DB2
Mainframe
hello, how can i execute multiple queeries with the help of tools- SPUFI and QMF respectively. thank you

Answer Wiki

Thanks. We'll let you know when a new response is added.

In SPUFI, end each query with a ;

select * from tab1;

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Fskovacs
    Continuing-- In SPUFI terminate each query with a ';' select * from tab1; select * from tab2;
    0 pointsBadges:
    report
  • TwoMetreBill
    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 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
    0 pointsBadges:
    report
  • Dbaohio
    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
    0 pointsBadges:
    report
  • Mainframedb2
    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.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following