HP OpenVMS Systems

ask the wizard
Content starts here

Network (Distributed) (Database) Programming?

» close window

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.

answer written or last revised on ( 7-APR-2003 )

» close window