|
midrange.com
Try this...
STRPCCMD PCCMD('"\\192.168.1.10\REPORTS\ITDEPT\CONSOLIDATED BALANCE
2005-04-05.XLS"')
Double quotes around the whole thing.
> -------- Original Message --------
> Subject: RE: Accessing documents in IFS with Excel from the iSeries
> From: "R Allen" <rallen@xxxxxxxxxxx>
> Date: Wed, April 13, 2005 10:10 am
> To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
>
> 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" <rallen@xxxxxxxxxxx>
> > Date: Wed, April 13, 2005 9:44 am
> > To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
> >
> > 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" <rallen@xxxxxxxxxxx>
> > Sent by: midrange-l-bounces@xxxxxxxxxxxx
> > 04/08/2005 03:06 PM
> > Please respond to
> > Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> >
> >
> > To
> > "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
> > 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" <Jallen@xxxxxxxxxxx>
> > Sent by: midrange-l-bounces@xxxxxxxxxxxx
> > 04/08/2005 02:19 PM
> > Please respond to
> > Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> >
> >
> > To
> > <MIDRANGE-L@xxxxxxxxxxxx>
> > 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 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.
