Re: Copy IFS .txt file records to PF or READ from RPGIV -- MIDRANGE-L

Thank you all.  I'm just waiting for the internet cops to allow me access
to Scott's site =).



                                                                           
             rob@xxxxxxxxx                                                 
             Sent by:                                                      
             midrange-l-bounce                                          To 
             s@xxxxxxxxxxxx            Midrange Systems Technical          
                                       Discussion                          
                                       <midrange-l@xxxxxxxxxxxx>           
             01/16/2007 07:33                                           cc 
             AM                                                            
                                                                   Subject 
                                       Re: Copy IFS .txt file records to   
             Please respond to         PF or READ from RPGIV               
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




1 - Even though it is a simple text file you will find that WordPad will
make it look prettier than NotePad.  WordPad will break up the lines.
Showed that to one of our PC "gurus" just last week.  I also showed the
same guy that you CAN select text out of a pdf file by using the "select"
tool.

2 - The theory is that copying the file, using CPYFRMIMPF, and just
reading that is easier.  However, since V5R3 lots have changed.  In the
V5R3 memo to users IBM alluded to that much undesirable effects were going
to occur because of new rules on CCSID, etc.  With all the hassles we ran
into we started using Scott's IFS API's.  They actually perform better
than CPYFRMIMPF.  Not only that, but you get more granular control.  Let
me explain.  Let's say that, in your example below, that EAC is a unit of
measure.  Now let's say that you are on the 3,000 row and that is the
first one that says EAC.  All the rest say EA.  Now let's say that your
U/M code in your file only allows for 2 characters.  If you use the IFS
API's then you can handle that nicely in an exception report.  Beats the
snot out of monitoring for an exception message on CPYFRMIMPF and telling
some poor sap to look at the job log.  We used to have to do a HELL of a
lot of Excel analysis to find these kind of errors.

http://www.scottklement.com/rpg/ifs.html

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





fkany@xxxxxxxxxxxxxxxxxx
Sent by: midrange-l-bounces@xxxxxxxxxxxx
01/15/2007 04:16 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange-L Mailing List - Midrange.com" <midrange-l@xxxxxxxxxxxx>
cc

Subject
Copy IFS .txt file records to PF or READ from RPGIV







Good afternoon,

I have a text file in the IFS that has 2 records(displays as 1 line when
opened in notepad):
TGHU7051481-860580|TGHU7051481|40HC|||290.00000000000|EAC|||
TTNU9726230-860578|TTNU9726230|40HC|||290.00000000000|EAC|||

Which method of the 3 below would be the simpliest in setting up to
process
the data?

1) Copy records from the text file to a physical file, then use RPG to
READ
the file?

2) READ text file records directly from RPG?

3) Your suggestion...

If it will help, the system I'm working on is at V5R4.

Thank you,

Frank