The Question is:
I am trying to write a DCL script to ftp files created on our Novell server to
VMS SERVER. The files on Novell server are created by an application. The name
and location of the files are automatically created by application and the
name and location of t
hese files are kept in an oracle tables. Now every day they want files created
yesterday to be ftped to VMS. I have two questions:
1. Is there a way to query the oracle table and
get the file name, directory location and then
substitute it in ftp file command? As I have no
infor. about the files I am going to ftp, how
can I write the get myfile statement? can myfile be a symbol instead of
actual file name?
2. Is there a way to get infor. about when the
file created on Novell and only ftp those files
created at certain time? I know if the files are
created on VMS, we can check the file attributes.
The Answer is :
Oracle programming questions should be directed to an Oracle Wizard.
1: yes, but you want to know how -- and the OpenVMS Wizard hasn't any
idea of how to query the remote Oracle database in your particular
environment. Simply that this is certainly possible.
2: yes, the OpenVMS Wizard expects that a network client-server
environment could be easily implemented. But again, you will want
to know how, and the OpenVMS Wizard is not sufficiently familiar
with your environment -- but rexec or rsh would be two of the more
obvious initial approaches to the stated goal.
The OpenVMS command DIRECTORY/FTP/FULL can also potentially be used
(unfortunately no /SINCE option presently exists with the standard
FTP command), or you could connect directly to the remote FTP server
and pull the files over directly. Alternatively, an SQL application
operating on the remote host could extract and format a list of files.
Or you can mount the disk volumes involved via SMB or NFS protocols.
Or you could code the remote system to periodically move the files
into a particular directory -- or a particular name -- based on
information local to the remote system.
The HP Services organization can offer programming and configuration
and network programming assistance, as well.