Re: disk space analysis with OPNQRYF question

-----Original Message-----
From: Stone, Joel <StoneJ@GourmetAward.com>
To: 'MIDRANGE-L@midrange.com' <MIDRANGE-L@midrange.com>
Date: Tuesday, December 07, 1999 12:41 PM
Subject: disk space analysis with OPNQRYF question


>Is there a better way to do this?  I had to map many fields to blanks and
>zeros.  Isnt there a way to build a record format in OPNQRYF and use blanks
>and zeros to fill any fields missing in the input file?   This turns a
>simply OPNQRYF stmt into an ugly mess!
>

Well, the better way is with SQL, if you have the development stuff, then
you can select just the fields you want from the first file, union with the
second file that has the fields you need using CAST to correct any mappings.
The advantage is that if all you need is library, file name and size, then
that is all you have to ask for, union and map with CAST.

It prevents the "big mess" that open query file requires on the maps. And,
yes Virginia, you do have to map those fields on the OPNQRYF command.


===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified AS/400 Professional System Administrator
 -- IBM Certified AS/400 Professional Network Administrator

"The sum of all human knowledge is a fixed constant.
    It's the population that keeps growing!"



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---