IBM Mainframe Forum

Can any one help me to create a form in QMF?

The query is simple.
Select count(*) from tabename.

i am trying to use REXX with QMF to retrive data for many tables. ie row count for many table.

why QMF ? why a form? why REXX
maybe explain why and in which output you need the counts .

Hi Guys. thanks for the respond.
I got the result. let me explain below
Req: in a PS i have table name like around 80 table name(input). Need to take row count for each one.
i choose rexx bec to dynamically substitute the table name in the query. I need the output in a ps which should have table name and its row count. like below
xxx.table = nnn
xxx.table = nnn
xxx.table = nnn

Form describe the structure of the O/P needed.

but now i face the process is slow. Rexx take time to run as it send the table name one by one to QMF and get the store the result in PS.
if there is any other way to increase the performance, Pl post.

Don't use a form! The simple formatting you describe can be so easily done directly in Rexx. Store all your results in a stem and then write them in one call to EXECIO to a seq. dataset.

Why use QMF at all (its a performance dog) but great at what it does well
DSNREXX
DSNTEP2 + post process the output with rexx/sort what ever

Or even a very noddy Cobol program ......or am i missing a very basic requirement?