Migrating from RMS to Oracle

[Kevin Erne]

I can't imagine any PowerHouse component recognising a 'nested' table. I
think they are mainly used if you want to put Object Orientated structures
in an Oracle Database. You will have to create a separate table for each
of the coded record structures.

PowerHouse (on VMS/unix) always accesses by record name anyway so 'File'
open/access type code will not have to changed if you give the table name
the same name as the coded record structure (apart from putting 'in database'
in front of each record reference)  

Cheers  

>-- Original Message --
>From: "Goparaju, Vidyasagar" <VGoparaju@tradepointsystems.com>
>To: "'mail@kevinerne.co.uk'" <mail@kevinerne.co.uk>
>Cc: powerh-l@lists.swau.edu
>Subject: RE: Migrating from RMS to Oracle
>Date: Fri, 23 May 2003 09:47:48 -0400
>
>
>I am not new to Powerhouse and RDBMS... I am in this field for 14 years.

Now...
Has anybody used nested tables in Oracle and accessed using Powerhouse on
Solaris?

I have created nested tables and type objects in Oracle 9i and getting weird
err
>rs when referenced in Powerhouse programs.
Finally ended up creating different tables in Oracle.

Sagar



 -----Original Message-----
From: 	Kevin Erne [mailto:kevin.erne@lineone.net] 
Sent:	Friday, May 23, 2003 4:11 AM
To:	powerh-l@lists.sw
>u.edu
Subject:	Migrating from RMS to Oracle

Sorry about being so US/UK centric - looking at tradepoint systems website
it seems that they have offices in US,UK and Holland

If external consultants are not an option, what about asking your employ
>r
to provide some basic Oracle training.






= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe 
>password>" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing l
>st: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list
>is closed, thus to post to the list you must be a subscriber.