× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. April 2005

RE: Accessing documents in IFS with Excel from the iSeries

He's talking about full quotation marks, not apostrophes. Put quotation marks 
around any part of the path name that has blanks in it. 
STRPCCMD PCCMD('\\192.168.1.10\REPORTS\ITDEPT\"CONSOLIDATED BALANCE 
2005-04-05.XLS"'
Or maybe around the whole thing after the IP address
STRPCCMD PCCMD('\\192.168.1.10\"REPORTS\ITDEPT\CONSOLIDATED BALANCE 
2005-04-05.XLS"'


-------------- Original message -------------- 

> 
> Put quotes around what? I have quotes around the PCCMD 
> I tried: 
> STRPCCMD PCCMD('\\192.168.1.10\REPORTS\ITDEPT\CONSOLIDATED BALANCE 
> 2005-04-05.XLS') 
> 
> STRPCCMD PCCMD('\\192.168.1.10\REPORTS\ITDEPT\"CONSOLIDATED BALANCE 
> 2005-04-05.XLS" ') 
> 
> STRPCCMD PCCMD('\\192.168.1.10\REPORTS\ITDEPT\''CONSOLIDATED BALANCE 
> 2005-04-05.XLS'' ') 
> 
> All with the same results 
> 
> -----Original Message----- 
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> michael@xxxxxxxxxxxxxxxxxx 
> Sent: Wednesday, April 13, 2005 8:56 AM 
> To: Midrange Systems Technical Discussion 
> Subject: RE: Accessing documents in IFS with Excel from the iSeries 
> 
> put quotes around it...or use the MS-DOS short name, which would 
> probably be CONSOL~1.XLS..but that would be a PITA because you probably 
> have multiple files with the same first party of the name, so the ~x 
> would be different for each file...yeah, use quotes. 
> 
> > -------- Original Message -------- 
> > Subject: RE: Accessing documents in IFS with Excel from the iSeries 
> > From: "R Allen" 
> > Date: Wed, April 13, 2005 9:44 am 
> > To: "'Midrange Systems Technical Discussion'" 
> > 
> > Rob, 
> > 
> > I have this working now (Thanks to everyone's help) BUT..... 
> > I want to use long file names such as 
> > STRPCCMD PCCMD('\\192.168.1.10\REPORTS\ITDEPT\CONSOLIDATED BALANCE 
> > 2005-04-05.XLS') 
> > 
> > I get an error message (appears it is truncating the file name at the 
> first 
> > space): 
> > '\\192.168.1.10\REPORTS\ITDEPT\CONSOLIDATED' is not recognized as an 
> > internal or external command, operable program or batch file. 
> > 
> > Does this mean I cannot use long names, or blanks are not allowed, or 
> there 
> > is some other was to specify the command? 
> > 
> > Thanks 
> > 
> > John 
> > 
> > -----Original Message----- 
> > From: midrange-l-bounces@xxxxxxxxxxxx 
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx 
> > Sent: Friday, April 08, 2005 5:01 PM 
> > To: Midrange Systems Technical Discussion 
> > Subject: RE: Accessing documents in IFS with Excel from the iSeries 
> > 
> > gdisys is the system name, rob is the share name. 
> > 
> > Rob Berendt 
> > -- 
> > Group Dekko Services, LLC 
> > Dept 01.073 
> > PO Box 2000 
> > Dock 108 
> > 6928N 400E 
> > Kendallville, IN 46755 
> > http://www.dekko.com 
> > 
> > 
> > 
> > 
> > 
> > "R Allen" 
> > Sent by: midrange-l-bounces@xxxxxxxxxxxx 
> > 04/08/2005 03:06 PM 
> > Please respond to 
> > Midrange Systems Technical Discussion 
> > 
> > 
> > To 
> > "'Midrange Systems Technical Discussion'" 
> > cc 
> > 
> > Subject 
> > RE: Accessing documents in IFS with Excel from the iSeries 
> > 
> > 
> > 
> > 
> > 
> > 
> > I tried you suggestion but cannot get mine to work, what is the share name 
> > gdisys or rob? 
> > 
> > The actual path is /REPORTS/ITDEPT/SALESRPT.PDF 
> > I have a share named REPORTS over the /REPORTS directory 
> > 
> > I tried: STRPCCMD ('START REPORTS\ITDEPT\SALESRPT.PDF') 
> > 
> > I tried: STRPCCMD ('\\REPORTS\ITDEPT\SALESRPT.PDF') 
> > "The system cannot find the path specified" 
> > 
> > I tried: STRPCCMD ('START \\REPORTS\ITDEPT\SALESRPT.PDF') 
> > "Network path not found" 
> > 
> > None of these worked, what am I overlooking doing wrong? 
> > 
> > Thanks 
> > 
> > John 
> > 
> > 
> > -----Original Message----- 
> > From: midrange-l-bounces@xxxxxxxxxxxx 
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx 
> > Sent: Friday, April 08, 2005 2:40 PM 
> > To: Midrange Systems Technical Discussion 
> > Subject: Re: Accessing documents in IFS with Excel from the iSeries 
> > 
> > Have you thought about using a share name and not a drive? I just did: 
> > STRPCCMD PCCMD('\\gdisys\rob\craigs.txt') 
> > and that pulled up notepad and loaded that file right in. 
> > 
> > Rob Berendt 
> > -- 
> > Group Dekko Services, LLC 
> > Dept 01.073 
> > PO Box 2000 
> > Dock 108 
> > 6928N 400E 
> > Kendallville, IN 46755 
> > http://www.dekko.com 
> > 
> > 
> > 
> > 
> > 
> > "John" 
> > Sent by: midrange-l-bounces@xxxxxxxxxxxx 
> > 04/08/2005 02:19 PM 
> > Please respond to 
> > Midrange Systems Technical Discussion 
> > 
> > 
> > To 
> > 
> > cc 
> > 
> > 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. 
> > 
> > 
> > -- 
> > 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. 
> > 
> > 
> > 
> > -- 
> > 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. 
> > 
> > 
> > -- 
> > 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. 
> > 
> > 
> > 
> > -- 
> > 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. 
> 
> -- 
> 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. 
> 
> 
> 
> 
> -- 
> 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. 
>

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.