Re: Alternatives for transferring a CSV file on IFS to user?

[Mike Wills <mike@xxxxxxxxxxxx>]

I did not think of the spaces being a problem. When I wrote it initially, I didn't know for sure what version of Windows they were running. Yes, I can do that and see if that fixes it. Thanks Scott!

--
Mike Wills
http://mikewills.me

On Feb 3, 2012, at 12:28 AM, Scott Klement wrote:

> Hi Mike,
>
> %USERPROFILE% typically evaluates to a directory name with spaces in it. 
>  For Example, in my WinXP Pro box, it evaluates to:
>
> C:\Documents and Settings\Scott
>
> The problem this causes is that blanks in a command string are treated 
> as parameter separators. When all is said and done, your command looks 
> like this (should be one line -- please forgive that the e-mail software 
> wraps it):
>
> copy \\192.168.0.200\exportfiles\customersbysalesperson.csv c:\Documents 
> and Settings\whomever\Documents
>
> The "copy" command is expecting two parameters, an from file and a 
> destination file.  Trouble is, you're passing it 4 parameters, because 
> each blank is treated as a parameter separator.  So your "from" file is 
> okay, but your destination file looks like 3 separate parameters to the 
> copy command.  And this results in the message "The syntax of the 
> command is incorrect."
>
> A simple fix is to add double quotes:
>
> ExecClCmd('CALL PGM(RUNPCCMD) ' +
>                'PARM(''copy \\192.168.0.200\exportfiles\' +
>                'customersbysalesperson.csv ' +
>                '"%USERPROFILE%\Documents"'')');
>
> Now the destination filename is all a single parameter (due to the 
> quotes) "c:\documents and settings\scott\Documents"
>
> However -- I suspect you really wanted this to go into a *folder* named 
> documents (instead of creating a file with that name).  In Windows XP, 
> that folder would be named "My Documents" (not just Documents) correct 
> me if I'm wrong.  So you really want this:
>
>
> ExecClCmd('CALL PGM(RUNPCCMD) ' +
>                'PARM(''copy \\192.168.0.200\exportfiles\' +
>                'customersbysalesperson.csv ' +
>                '"%USERPROFILE%\My Documents"'')');
>
> I don't know if that folder is still named "My Documents" in Vista or 
> Win7, though...  You'd probably know that better than I do.  But if it's 
> different on different versions of Windows, then you have another 
> challenge...
>
>
>
>
> On 2/2/2012 10:37 PM, Mike Wills wrote:
> > I have a CSV I have created on the IFS that I am trying to copy to their desktop via PCO. They told me the following:
> >
> > "The PCO session A command prompt screen comes up.  It says" The syntax of the command is incorrect. Press any key to return." I hit return and the screen goes blue and then returns to menu. Nothing shows up in my Docs."
> >
> > I am not sure where to continue looking since I don't have access to their PC. They are on Windows XP. Here is what I am doing:
> >
> > ExecClCmd('CALL PGM(RUNPCCMD) ' +
> >                    'PARM(''copy \\192.168.0.200\exportfiles\' +
> >                    'customersbysalesperson.csv %USERPROFILE%\Documents'')');
> >
> > RUNPCCMD.CLLE
> >              PGM        PARM(&CMD)
> >
> >              DCL        VAR(&CMD) TYPE(*CHAR) LEN(120)
> >
> >              STRPCO
> >              MONMSG     MSGID(IWS4010)
> >
> >              STRPCCMD   PCCMD(&CMD) PAUSE(*YES)
> >
> >              ENDPGM
> >
> > This works on my PC (Windows Vista), but not theirs. Any thoughts?
> >
> > --
> > Mike Wills
> > http://mikewills.me
>
> -- 
> 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.