HP OpenVMS Systems

ask the wizard
Content starts here

RMS and relational database files?

» close window

The Question is:

 
dear wizard,
 
How do I extract rms into ascii format?
inorder for me to load it into relational database (Oracle)
 
 
Thanks
 
 


The Answer is :

 
  Please take a look at the Guide to OpenVMS File Applications manual as
  a starting point.
 
  The Record Management System (RMS) software is used to store sequential
  ASCII format files, as well as for relative and indexed file formats.
 
  Options for extraction from relative or indexed file formats into an RMS
  sequential (text) format run the gamut from the CONVERT command to a DCL
  command procedure to one of the available RMS-ODBC interface packages to
  a custom-written converter tool.
 
  Since extracting an ASCII sequential text file into ASCII sequential text
  is unlikely to cause a question, the Wizard will assume that the file
  format is either relative or indexed, or a sequential file with binary
  data.  These file formats can all contain binary or floating-point format
  data, and loading this data directly into a database may require the
  creation of specific record definition in the conversion tool, or an
  explicitly-written conversion tool (DCL or a program) that uses the READ
  command or the sys$get routine to retrieve the data and either outputs
  SQL calls in text (to be executed later) or directly executes embedded
  SQL calls.  If the contents of the file are entirely ASCII text, the
  conversion is often rather easier.
 

answer written or last revised on ( 23-NOV-1998 )

» close window