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

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.