Oracle-L: RE: COBOL TO ORACLE

From: Stephane Paquette <stephane.paquette_at_standardlife.ca>
Date: Tue, 30 Sep 2003 12:19:28 -0800
Message-ID: <F001.005D187D.20030930121928@fatcity.com>

Like Thomas Day said, Oracle is an rdbms and COBOL a programming language.

You can use Sql*Loader to load flat files into Oracle or use COBOL programs with embedded SQL, you'll need to use Oracle Pro*Cobol to precompile the COBOL source before compiling them.

The last time I've used Designer it was 2 years ago and I do not remember any support for transforming flat files to an ERD. Anyway, it would probably be a bad thing, I've seen applications do a 1 to 1 mapping between files and tables. The result was not good...

Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187 stephane.paquette_at_standardlife.ca <mailto:stephane.paquette_at_standardlife.ca>

-----Original Message-----

Thomas Day
Sent: Tuesday, September 30, 2003 3:34 PM To: Multiple recipients of list ORACLE-L

Er ... No.

COBOL is a programming language. Oracle is a relational database manager.

The data used in a COBOL program can be stored in a variety of ways. It's even possilbe to have a COBOL program using data from an Oracle database.

I'm not aware that Designer can translate COBOL file definitions into entities; however, if you know COBOL and Oracle it should be fairly straightforward.

                      Muqthar Ahmed
                      <Muqthar.Ahmed           To:      Multiple recipients
of list ORACLE-L <ORACLE-L_at_fatcity.com>
                      @decoratetoday.c         cc:
                      om>                      Subject: COBOL TO ORACLE
                      Sent by:
                      ml-errors


                      09/30/2003 03:14
                      PM
                      Please respond
                      to ORACLE-L

Hi,

Is there a tool available to move data from COBOL to ORACLE directly? One way to do is get COBOL data on a flat file and then use SQL*Loader to insert into ORACLE tables.

The second question is did anyone use DESIGNER to connect to COBOL to create an ERD and then transform into ORACLE tabels script?

Thanks
Muqthar Ahmed
DBA
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Muqthar Ahmed
INET: Muqthar.Ahmed_at_decoratetoday.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Thomas Day
INET: tday6_at_csc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Stephane Paquette
INET: stephane.paquette_at_standardlife.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message