RE: Accessing documents in IFS with Excel from the iSeries

["Cox, Joe" <joecox@xxxxxxxxxxx>]

As far as the mapped drives, simply use the fully qualified server name
and path, no mapped drives and no shares needed.  Basic network services
like DNS and/or WINS need to be available but most environments have
those.  I also think user ID's and passwords need to be the same between
systems.  

________________________________________________________
PGM                                                             
             DCL        VAR(&PCCMD) TYPE(*CHAR) LEN(128)       
                                                              
             STRPCO                                            
             MONMSG CPF0000                                    

CHGVAR     VAR(&PCCMD) VALUE(' +                         
             \\MYAS400.MYBUS.COM\ROOT\FOLDER1\PRODDA+
             TA\AM\SALESRPT.XLS')         
                                                         
STRPCCMD   PCCMD(&PCCMD) PAUSE(*NO) 
_________________________________________________________

Or you can specify the file, path, etc. with variables
_________________________________________________________
  PGM (&LETTER)                                                      
              DCL        VAR(&LETTER) TYPE(*CHAR) LEN(10)            
                                                                     
              DCL        VAR(&PCCMD) TYPE(*CHAR) LEN(128)            
 /* EXECUTE FILE TRANSFER TO CREATE XLS FORMAT                */     
                                                                     
              STRPCO                                                 
              MONMSG CPF0000                                         
                                                                     
                                                                     
/* DELETE XLS FILE PRIOR TO DATA TRANSFER                    */      
             CHGVAR     VAR(&PCCMD) VALUE('"DEL +                    
                         \\ MYAS400.MYBUS.COM \ROOT\FOLDER1\PRODDA+
                         TA\AM\' *TCAT &LETTER *TCAT '.XLS"')        
STRPCCMD   PCCMD(&PCCMD) PAUSE(*NO)
__________________________________________________________

Hope that helps a little.                   

Joe Cox
Director Information Systems
MSU Foundation Inc.
1501 S 11th Avenue
Bozeman, MT  59717
(406) 994-2416
joecox@xxxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John
Sent: Friday, April 08, 2005 1:19 PM
To: MIDRANGE-L@xxxxxxxxxxxx
Subject: Accessing documents in IFS with Excel from the iSeries

We are creating some PDF files and Excel files on our iSeries and
placing
them in the IFS. 

I would like to give the users the ability to access these from their
green
screen application.

I have tried STRPCCMD ('START Y:/REPORTS/ITDEPT/SALESRPT.PDF')

Which works fine but requires all users to map their drive Y the same.

And also requires that the user already be logged on to the Y drive
(does
not prompt for user id and password)

 

I want to display these files from an iSeries application and give the
user
the option to view the pdf and excel files without starting a program on
their PC

 

My questions are (bear with me if these are dumb questions, Running PC
commands from the iSeries is new to me): 

1) Is there another way to do this without a socket program?

2) I can create a share from the iSeries, can I map a drive from the
iSeries?

3) Can I check to see if a drive is mapped (from an iSeries using RPG or
CL)

4) The users may put their PDF and Excel files into different
directories in
the IFS, The program knows exactly where the PDF and Excel files are
(has
the complete IFS path name) I do not want to create a share of the IFS
root,
is there a better way to run the STRPCCMD to allow this (without making
the
user key in the directory path)

Example I have a database with /REPORTS/ITDEPT/SALES.PDF in it, The
easiest
thing would be to have all users map drive Y to the root then the
STRPCCMD
at the beginning of this email would work for them all, however since I
do
not want the Y drive mapped to the root, I am looking for other
possibilities. Has anyone done anything like this and if so how did you
implement?

 

 

Thanks

 

John

 

 

 

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