Re: COBOL copybook to SQL*Loader script utility?
From: Frank van Bortel <fbortel_at_home.nl>
Date: Thu, 20 Dec 2001 20:50:34 +0100
Message-ID: <3C22410A.1C7EDE74_at_home.nl>
Date: Thu, 20 Dec 2001 20:50:34 +0100
Message-ID: <3C22410A.1C7EDE74_at_home.nl>
Brad Pippert wrote:
>
> Does anyone know of a utility that can create a SQL*Loader script from
> a COBOL copybook? The utility could run in either a Windows or UNIX
> environment.
>
> I currently have a flat file that is over 14000 characters wide and
> consists of over 1000 fields. I also have the associated copybook. I
> would like to be able to move this data into an Oracle table, but
> would prefer not to create the SQL*Loader script by hand.
I know a co-worker at Oracle did this once; I forwarded this request to him by mail - maybe he'll respond.
On the other hand - grep and awk would take you there, wouldn't they?
-- Gtrz, Frank van BortelReceived on Thu Dec 20 2001 - 20:50:34 CET