RE: AS400 to EXCEL

["Tracy Ball" <TBall@xxxxxxxxxxxxxxxx>]

<laughing> But of course....got to know what file I am coming from!

-Tracy 
 Ext. 3107


-----Original Message-----
From: Mike Haston ** Data [mailto:MHaston@xxxxxxx]
Sent: Wednesday, May 14, 2003 1:18 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: AS400 to EXCEL



FROMSTMF('/QDLS/TBALL/fileName.extension')

I have one like this:  FROMSTMF('/QDLS/MJH/TEST.CSV')


-----Original Message-----
From: Tracy Ball [mailto:TBall@xxxxxxxxxxxxxxxx]
Sent: Wednesday, May 14, 2003 2:00 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: AS400 to EXCEL


When using the CPYFRMIMPF, I understand everything except the "From Stream 
File..." parm.  I don't know what value it is looking for.  Here is what I 
tried to no avail:

                       Copy From Import File (CPYFRMIMPF)                       
                                                                                
 Type choices, press Enter.                                                     
                                                                                
 From stream file . . . . . . . . FROMSTMF     > 'qdls/tball'                   
                                                                                
 From file:                       FROMFILE                                      
   File . . . . . . . . . . . . .                                               
     Library  . . . . . . . . . .                  *LIBL                        
   Member . . . . . . . . . . . .                *FIRST                         
 To data base file:               TOFILE                                        
   File . . . . . . . . . . . . .              > UPSEOD                         
     Library  . . . . . . . . . .              >   TRACYB                       
   Member . . . . . . . . . . . .                *FIRST                         
 Replace or add records . . . . . MBROPT         *ADD                           
 Stream file record length  . . . STMFLEN        *TOFILE                        
                                                                                
                                                                                
                                                                                
 Now, on the CPYFRMPCD command, the location would just be "TBALL", as the qdls 
path is understood by the command.  What is the difference here?

Any help is appreciated!

Tracy L. Ball
The Jackson Group
Sr. Programmer/Analyst 
(317) 781-4600 ext. 3107
                                                                           
                                                               

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.