Kbase 8751: How to move PROGRESS data to ORACLE
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
How to move PROGRESS data to ORACLE
910909-gfs01
INTRODUCTION:
=============
This Technical Support KnowledgeBase Entry demonstrates how to move
PROGRESS Data to ORACLE
WHY YOU NEED TO KNOW THIS:
==========================
To use the PROGRESS/ORACLE gateway to access this data via
PROGRESS tools.
PROCEDURAL APPROACH:
====================
Dump the data from the PROGRESS database
using the Data Dictionary, or run a procedure such as:
OUTPUT TO filename.d.
FOR EACH filename:
EXPORT filename.
END.
OUTPUT CLOSE.
Use the CREATE TABLE command to create the ORACLE database
that will receive data. Also, use the CREATE INDEX command
to create the indexes for this table.
Create a control file to use with ORACLE's SQL*Loader utility.
It will look something like this:
-- filename.ctl Control file for loading filename data
LOAD DATA
INFILE * -- denotes that the data is in this file
APPEND -- add this data to what already exists
INTO TABLE filename -- name of the table to add data
FIELDS TERMINATED BY ' ' OPTIONALLY ENCLOSED BY '"'
(
field1,
field2 DATE "MM/DD/YY",
field3
)
BEGINDATA -- data starts below this line
0 01/01/91 "Customer Name"
.
.
.
The data of the file is included in the .ctl file after
the "BEGINDATA" line. It is readfrom this location by
including the line "INFILE *". You can optionally
specify a filename for the loader to read by changing
the line to "INFILE filename.d".
Run the SQLLOAD utility to import the data into ORACLE. For
example, "SQLLOAD user/password filename.ctl filename.log
filename.bad"
The .log file will contain a log of the load process and the .bad
file will contain the records that could not be loaded. Always
check the .bad file to see if there is anything you must fix
before loading these records.
At this point, you are ready to create or update your ORACLE
gateway schema and begin writing programs to access
this table.
ONLINE PROCEDURES OR UTILITIES:
===============================
PROGRESS Data Dictionary
PROGRESS 4GL
SQL*Loader (ORACLE)
REFERENCES TO WRITTEN DOCUMENTATION:
====================================
PROGRESS System Administration Guide, Chapter 4
PROGRESS Database Gateways Guide, Chapters 2 & 3
ORACLE System Administration Guide
ORACLE SQL Language Reference Manual
ORACLE Utilities User's Guide
Progress Software Technical Support Note # 8751