Re: RE: [sqr-users] Using Call System to FTP on file on WINNT-and PeopleSoft

[<bmrazek@sympatico.ca>]

I appreciate your reply.  I am using COMSPEC to create the command, so what I 
sent to you is correct for the server the program is running on.  They only run 
NT here.  Here is the code that creates the command:

LET $COMMAND =  GETENV('COMSPEC') || ' /c '
let $command = $command || $sign_string
CALL SYSTEM USING $command #nt_status WAIT

where $sign_string = 'ftp -n 
-s:\\scanty\psoftfm\\FMDEV\user\upload\fms_ftpout.bat'

So, I appreciate that the server is not my desktop, but the command created 
with COMSPEC seems to be the same.  The file path is also a server file path.

Thanks


> 
> From: "Knapp, Richard" <KnappR@umsystem.edu>
> Date: 2004/01/20 Tue PM 03:31:03 EST
> To: <sqr-users@sqrug.org>
> Subject: RE: [sqr-users] Using Call System to FTP on file on WINNT-and 
>PeopleSoft
> 
> 
> Peoplesoft is running on a different machine than your desktop, no?  So how 
>can you expect that commands that work on your desktop machine will work on 
>the PS server?
> 
> Make a command that uses the server OS and file paths for when it runs on the 
>server.
> 
> Richard Knapp
> Database Programmer/Analyst
> Institutional Research and Planning
> University of Missouri System
> 573-882-8856
> knappr@umsystem.edu
> 
> 
> -----Original Message-----
> From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
> Behalf Of bmrazek@sympatico.ca
> Sent: Tuesday, January 20, 2004 2:11 PM
> To: sqr-users@sqrug.org
> Subject: [sqr-users] Using Call System to FTP on file on WINNT-and
> PeopleSoft
> 
> 
> Hi Everyone,
> 
> I have read a few postings on this issue, and have tried recommended changes, 
>but nothing seems to be working for me.  I an running an SQR under PeopleSoft 
>PIA (Web) that is using call system to ftp a file from NT to the FTP site.  
>The code works fine if I run it through SQRW, but when running it through a 
>PeopleSoft page, nothing happens.  I don't believe I am getting a valid status 
>code either, as it is always 0, though from what I read in the SQR manuals, 
>for NT, anything less than 32 is an error.
> 
> Though my code is built dynamically in the SQR, ultimately, when call system 
>is executed, it looks like this:
> 
> C:\WINNT\system32\cmd.exe /c ftp -n 
>-s:\\scanty\psoftfm\\FMDEV\user\upload\fms_ftpout.bat
> 
> As stated, this works fine from the "run" command in windows, and also 
>running through SQRW, but running it from within peoplesoft results in no 
>results :-)
> 
> Any suggestions would be greatly appreciated.
> 
> Barb
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users