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

["Knapp, Richard" <KnappR@umsystem.edu>]

Is ftp secure in some way?  What is the -s part?  Is that a flag or a drive?  
Try to find a log file that records the error messages the bum command is 
producing.  Ask your sysop or DBA if you don't have privs.

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:59 PM
To: sqr-users@sqrug.org; sqr-users@sqrug.org
Subject: Re: RE: [sqr-users] Using Call System to FTP on file on
WINNT-and PeopleSoft


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

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