Home » Infrastructure » Other Operating Systems » RMS RECORD VARIANT to oracle table
RMS RECORD VARIANT to oracle table [message #116368] Tue, 19 April 2005 12:33 Go to next message
croK
Messages: 170
Registered: April 2002
Senior Member
Hi All.
We are in the process of migration from RMS seq/indexed files to Oracle RDBMS 9i.
I'm not that good with RMS, but question would be:

how to create table/s to simulate VARIANT RECORD file?

I mean, do we have to normalize ONE VARIANT RECORD file and create several tables to hold all data from that file?
Let me know if question is clear or not.

Any feedback would be appreciated.
Best regards.
Re: RMS RECORD VARIANT to oracle table [message #122929 is a reply to message #116368] Thu, 09 June 2005 04:55 Go to previous message
Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...
Senior Member

Hi,

If the source data type varies then you are probably left with using an Oracle varchar2 to hold the data.

kind regards

Michael Hartley http://www.openfieldsolutions.co.uk
Previous Topic: Can not install Java
Next Topic: Oracle VMS Client under HP-UX Server
Goto Forum:
  


Current Time: Thu Mar 28 08:43:37 CDT 2024