[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ulysse::rdb_vms_competition

Title:	DEC Rdb against the World

Moderator:	HERON::GODFRIND

Created:	Fri Jun 12 1987
Last Modified:	Thu Feb 23 1995
Last Successful Update:	Fri Jun 06 1997
Number of topics:	1348
Total number of notes:	5438

817.0. "File transfer Rdb -> Oracle?" by SUOSW3::KAISER (ULTRIX/SQL, Tuxedo and Sybase?!?!) Tue Dec 04 1990 08:22

Two of my customers have a similar problem: they want to have write access 
from a database application (which hopefully will be Rdb based) to an Oracle
database. As the target database is on a node far away a file transfer over
the network in one case and via tapes in the other will be the best solution.
To unload the data from Rdb with RMU/UNLOAD will be ok, but I don't know wether 
there is a chance to load these files into O. Can someone give me the answer?
Or is there a better solution? Online access cannot be used.

Thanks 
-Hans

T.R	Title	User	Personal Name	Date	Lines
817.1	Need to write programs to do so	IJSAPL::OLTHOF	Henny Olthof @UTO 838-2021	`Tue Dec 04 1990 10:23`	10
	My best guess: - write a program on the VAX that unloads the data in a special format file - write a program on the other machine that loads the data into the Oracle database Don't count that you can use rmu backup or export/inport facilities as these are non-identical to Rdb and Oracle. Henny
817.2	Of course not RMU/BACKUP or SQL EXPORT	SUOSW3::KAISER	ULTRIX/SQL, Tuxedo and Sybase?!?!	`Tue Dec 04 1990 10:46`	4
	I know I cannot count on RMU/BACKUP or SQL EXPORT, but does O have something like our RMU/LOAD which I can use? -Hans
817.3	O has SQL*loader	MAIL::DUNCANG	Rdb & DTM, 2 phase knockout for Oracle	`Tue Dec 04 1990 22:50`	11
	yes ... Oracle has a utility called SQL*loaded ... no... I don't know anything about it other than a couple of customer I know use it and seem to like it OK. The thing you have to worry about is a mis-match on datatypes. One obvious one is the date format. Rdb used the VMS data format while Oracle does its own thing with dates. I would probably use a program to load the data as you would have better control of commit frequency and data. -- gerry
817.4	Datatrieve...	HGOVC::DEANGELIS	Momuntai	`Wed Dec 05 1990 05:23`	11
	Just a little more on Gerry's note about SQLLoader... You can control the commit frequency in that utility, but you will have problems with incompatible datatypes. If you have Datatrieve available, then unload from Rdb into character format, with some field delimiter (eg ','). This is really easy to do - a couple of domains and record definitions and a 3 line DTR procedure. The output file could then be directly loadable into Oracle via SQLLoader. John.
817.5	Rdb can convert to character	WIBBIN::NOYCE		`Wed Dec 05 1990 17:33`	2
	Can't you define an Rdb view to get RMU/UNLOAD to set up the datatypes the way you want?
817.6	Thanks a lot	SUOSW3::KAISER	ULTRIX/SQL, Tuxedo and Sybase?!?!	`Thu Dec 06 1990 08:40`	9
	>> Can't you define an Rdb view to get RMU/UNLOAD to set up the datatypes >> the way you want? Hmmm, this sounds good. I think they could do that. Personnally, I would like the idea to use Datatrieve, but I think our customer will not accept buying DTR just to extract data from Rdb. Thank to all -Hans
817.7	"Date" type may be a problem	MAIL::DUNCANG	Rdb & DTM, 2 phase knockout for Oracle	`Sat Dec 08 1990 01:19`	7
	Re: datatypes .... the Oracle "date" datatype is propietary. So, I believe you would have to read the oracle "date" fields and convert them to VMS datatype so Rdb would know how to handle them. I'm not sure this can be automated. -- gerry