Re: COBOL flat file to Oracle

From: Brett Neumeier <random_at_nospam.com>
Date: 15 Apr 1998 19:24:02 GMT
Message-ID: <6h31gi$k2r$1@eve.enteract.com>

Abeeda_Mohammed_at_xn.xerox.com wrote:
> I have a COBOL layout in which each field is defined as an
> array which occurs 84 times.i.e Gross_qty occurs 84 times,
> net_qty occurs 84 times etc; I have to load this into an
> Oracle table. Is there a way to define arrays in Oracle tables?

Egad. This is as far from normalized as you can get!

Why not normalize it as you load it, with SQL*Loader? Create a "parent" table and a "child" table; the "child" table will have the parent's ID, an indicator for which one (of the 84 repetitions) this record is, and the data fields gross_qty, net_qty, etc.

Then use SQL*Loader to load both the parent and child tables simultaneously. Example case 5 on page 5-14 of the Utilities User's Guide explains basically how to do this.

-bn
(the real domain is "enteract") Received on Wed Apr 15 1998 - 14:24:02 CDT