Re: A quick question on spool files

First you need to create the physical file you want to put the spool file into. 
 I just use
CRTPF, give the name and a length (80, 132, 400, whatever).
Then use SAVSPLF, you need to give a lot of information on the spool file to 
save to
a physical file, spool file name, job name, user name, spool file number.  Put 
in the file
name of the physical file you created.

Okay, so now you have your spool file into a physical file.  Now you can do 
anything
you can do with a physical file.  The first thing you are probably goign to 
want to do is
to create DDS for the physical file.  Look at your column layouts and create 
the DDS
based on that.  I would generally do this to another physical file and do a 
CPYF from
the original file to the DDS file with MAP(*NOCHK).  This will just copy the 
records
without checking for layout.  Then browse the file and see if you have it 
right.  Ooops,
missed that one by a column, change the DDS, recompile, do CPYF again.

Now you can do your queries.

If this is somethign you are going to be doing over and over for a certain 
pyscial file and
you keep the physical file and just SAVSPLF directly into the DDS file.  Stick 
in all in
a CL.

Regards,

Jim Langston


Date: Thu, 3 Aug 2000 04:15:45 -0400
From: ORiordan_Paudie@emc.com
Subject: A quick question on spool files

Hi
Just a quick question to see if anybody has done this and how to do it

Is it possible to change spool files into Database members/files for query
purposes
and how do you do it?

Thanks in advance for your help


+---
| 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
+---