MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2004

Re: Determining spool file record length



fixed

Well, first I would question the use of CPYSPLF.  Suggesting instead an 
output file or some such thing versus generating a spool file.  Then I 
might suggest that if you are trying to email the file to use another 
tool, one that wouldn't lose the line spacing, overlays, etc.  If you were 
trying to ftp it down to a PC I might suggest using iSeries Navigator or 
another tool.

However if for some reason you perceive that you just have to do it this 
way, I suppose you could do it with a two step process.  In the first step 
you do your normal CPYSPLF.  Then jab a little sql at that
SELECT max(length(rtrim(SPOOL))) FROM rob/spool
Then create your new physical file based on this number.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"York, Albert" <albert.york@xxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
10/05/2004 11:47 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"'MIDRANGE-L@xxxxxxxxxxxx'" <MIDRANGE-L@xxxxxxxxxxxx>
cc

Fax to

Subject
Determining spool file record length






I need to determine the record size (characters per line) of a spool file,
so I can create a physical file of the correct length when I use the 
CPYSPLF
command.

I have tried using WRKSPLFA to a print file but it doesn't always have the
actual number of characters, only the maximum for the print file.

Thanks,

Albert York 
 
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact