Re: Can you use FTP in SQR?

[BELLARY <BELLARY@AOL.COM>]

You can execute any operating system command using SQR's

CALL SYSTEM USING { command } { status }


SYSTEM  Specifies that this CALL command will issue an operating system
command.

command  Specifies the operating system command to execute.  Command can be a
quoted string, string variable, or column.

status  Contains the status returned by the operating system.  Status must be
a numeric variable.


Now you can have a unix shell script which actually does the FTP work. You can
use this shell script as command when ever you want to FTP based on the result
of your file creation. Another TIP is that you can create this shell script in
you SQR program itself so that you can have it customised to your
requirements.

-ARUN