Need to create Form in QMF



IBM's flagship relational database management system

Need to create Form in QMF

Postby sjrcreation » Tue Mar 29, 2011 3:26 pm

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.
sjrcreation
 
Posts: 30
Joined: Sat Dec 11, 2010 9:44 am
Has thanked: 0 time
Been thanked: 0 time

Re: Need to create Form in QMF

Postby GuyC » Tue Mar 29, 2011 7:38 pm

why QMF ? why a form? why REXX
maybe explain why and in which output you need the counts .
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: Need to create Form in QMF

Postby sjrcreation » Sun Apr 03, 2011 7:35 am

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.
sjrcreation
 
Posts: 30
Joined: Sat Dec 11, 2010 9:44 am
Has thanked: 0 time
Been thanked: 0 time

Re: Need to create Form in QMF

Postby NicC » Sun Apr 03, 2011 9:51 am

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Need to create Form in QMF

Postby DFSHDC40 » Thu Apr 07, 2011 5:51 am

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?
If the code hasn't been changed, why is the LKED date today?
User avatar
DFSHDC40
 
Posts: 41
Joined: Sat Oct 16, 2010 4:16 pm
Location: IMS.SDFSRESL
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post