MVSFORUMS.com

[sakreg]

I simply want to run a series of SQL using QMF. What I know is this can be achieved using PROC. I am able to run the query when running from QUERY panel (PF6 from QMF), the same, when I try to run from PROC panel, (PF10) they are not getting executed

Say, I am trying to run the following query using PROC panel

SELECT COUNT(*) FROM DBZ1.TABLE1;

What I get is,
SELECT is not a command

Anything in particular I need to take care while building the query to be used inside a PROC?

[kolusu]

sakreg,

The idea of proc is to run multiple named queries but not queries within a proc.you need to save all your queries differently and then put the names of the queries
and run them

ex:

[sakreg]

Thanks kolusu, you gave me a lead to start with QMF Proc.

[yadav2005]

Kolusu,

I am new to writing and executing a QMF proc , can you show an example and I do not know how to write / execute in QMF panel . I have a requirement where in I have a PDS member which contains sql statements . I want to do two things
a) replace the existing proc with the new member contents
b) execute the proc contents

Please help me in this regard.Thanks.

[yadav2005]

Kolusu,

Can you show me a batch jcl to execute the QMF proc as per your contents i understand that only the last saved named query in the proc gets executed.

[yadav2005]

Further if I would like to see the existing PROCs already created in QMF how can i see that ?.

I want to create a new one only if the name does not exist earlier.

[kolusu]

[yadav2005]

Thanks Kolusu,

You information is excellent. I was able to clearly follow your instructions and I am able to work with QMF procs .I have started practising them and concepts are clear.

Thanks once again.

[jim haire]

There is a way you can run the Proc interactively and see the results between queries using the INTERACT command.

Example below: