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



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



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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.