FAQ
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).

Search Discussions

  • Thomas Day at Sep 30, 2003 at 7:34 pm
    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

    @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
    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).
  • Karniotis, Stephen at Sep 30, 2003 at 7:44 pm
    You can also Execute SQL directly from Oracle using the precompilers - No
    need to export the data and use SQL Loader.

    Thank You

    Stephen P. Karniotis
    Technical Alliance Manager
    Compuware Corporation

    Direct: (313) 227-4350
    Mobile: (248) 408-2918
    Email: Stephen.Karniotis_at_Compuware.com
    Web: www.compuware.com

    -----Original Message-----
    Sent: Tuesday, September 30, 2003 3:14 PM
    To: Multiple recipients of list ORACLE-L
    Subject: COBOL TO ORACLE

    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).

    The contents of this e-mail are intended for the named addressee only. It
    contains information that may be confidential. Unless you are the named
    addressee or an authorized designee, you may not copy or use it, or disclose
    it to anyone else. If you received it in error please notify us immediately
    and then destroy it.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Karniotis, Stephen
    INET: Stephen_Karniotis_at_compuware.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).
  • Stephane Paquette at Sep 30, 2003 at 8:19 pm
    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

    -----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

    @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

    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: 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

    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).
  • Mladen Gogala at Sep 30, 2003 at 9:09 pm
    Unfortunately, you have to rewrite it to LISP or Oberon first.
    On Tue, 2003-09-30 at 15:14, Muqthar Ahmed wrote:
    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
    Note:
    This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.
    Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Mladen Gogala
    INET: mladen_at_wangtrading.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).
  • Mladen Gogala at Sep 30, 2003 at 9:14 pm

    On Tue, 2003-09-30 at 16:19, Stephane Paquette wrote:
    Like Thomas Day said, Oracle is an rdbms and COBOL a programming language.
    COBOL *** WAS *** a programming language. Horse *** WAS *** basis of
    transport. You should have used past tense, Stephane. I'm not really
    that partial when it comes to horses, but having suffered COBOL, I would
    really leave it in the ancient past, together with Spanish Inquisition
    and crucifiction as a viable capital punishment.

    Note:
    This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.
    Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Mladen Gogala
    INET: mladen_at_wangtrading.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).
  • April Wells at Sep 30, 2003 at 9:24 pm
    COBOL still lives and breathes, though, in many MANY shops (this one
    included). Just like the Mainframe, it won't go away easily or soon...

    I feel your pain, though, I lived through it too... and if I never have to
    figure out where an "alter" sends the program based on the data ever again I
    will die happy... worse than any goto around!

    April Wells
    Oracle DBA/Oracle Apps DBA
    Corporate Systems
    Amarillo Texas
    /\
    / \

    / \
    \ /

    \/
    \< \
    \<
    \

    Few people really enjoy the simple pleasure of flying a kite
    Adam Wells age 11

    -----Original Message-----
    Sent: Tuesday, September 30, 2003 4:15 PM
    To: Multiple recipients of list ORACLE-L
    On Tue, 2003-09-30 at 16:19, Stephane Paquette wrote:
    Like Thomas Day said, Oracle is an rdbms and COBOL a programming language.
    COBOL *** WAS *** a programming language. Horse *** WAS *** basis of
    transport. You should have used past tense, Stephane. I'm not really
    that partial when it comes to horses, but having suffered COBOL, I would
    really leave it in the ancient past, together with Spanish Inquisition
    and crucifiction as a viable capital punishment.

    Note:
    This message is for the named person's use only. It may contain
    confidential, proprietary or legally privileged information. No
    confidentiality or privilege is waived or lost by any mistransmission. If
    you receive this message in error, please immediately delete it and all
    copies of it from your system, destroy any hard copies of it and notify the
    sender. You must not, directly or indirectly, use, disclose, distribute,
    print, or copy any part of this message if you are not the intended
    recipient. Wang Trading LLC and any of its subsidiaries each reserve the
    right to monitor all e-mail communications through its networks.
    Any views expressed in this message are those of the individual sender,
    except where the message states otherwise and the sender is authorized to
    state them to be the views of any such entity.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Mladen Gogala
    INET: mladen_at_wangtrading.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).

    The information contained in this communication, including attachments, is strictly
    confidential and for the intended use of the addressee only; it may also contain
    proprietary, price sensitive, or legally privileged information. Notice is hereby given that
    any disclosure, distribution, dissemination, use, or copying of the information by anyone
    other than the intended recipient is strictly prohibited and may be illegal. If you have
    received this communication in error, please notify the sender immediately by reply e-mail,
    delete this communication, and destroy all copies.

    Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to
    this e-mail has been swept for viruses. We specifically disclaim all liability and will
    accept no responsibility for any damage sustained as a result of software viruses and advise
    you to carry out your own virus checks before opening any attachment.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: April Wells
    INET: awells_at_csedge.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).
  • Jesse, Rich at Sep 30, 2003 at 10:34 pm
    Crucifixion is a perfectly viable form of punishment, but only for the first
    offense.

    Best thing the Romans ever done for us. Oh, yeah. If we didn't have
    crucifixion, this country would be in a right bloody mess.

    Rich Jesse,
    People's Front of Judea
    -----Original Message-----
    From: Mladen Gogala
    Sent: Tuesday, September 30, 2003 4:15 PM
    To: Multiple recipients of list ORACLE-L
    Subject: RE: COBOL TO ORACLE

    On Tue, 2003-09-30 at 16:19, Stephane Paquette wrote:
    Like Thomas Day said, Oracle is an rdbms and COBOL a
    programming language.
    COBOL *** WAS *** a programming language. Horse *** WAS *** basis of
    transport. You should have used past tense, Stephane. I'm not really
    that partial when it comes to horses, but having suffered
    COBOL, I would
    really leave it in the ancient past, together with Spanish Inquisition
    and crucifiction as a viable capital punishment.
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Jesse, Rich
    INET: Rich.Jesse_at_qtiworld.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).
  • Stephane Paquette at Sep 30, 2003 at 10:54 pm
    Mladen, maybe it is the past for you but it is quite the present for me.

    We just decided between 2 packages (insurance industry): one in cobol using
    flat files on AS400 and the other one where all jobs are in cobol but the
    database is Oracle.

    We have choose the second one. So, in the next week, I'll install Oracle
    Pro*Cobol on the unix boxes and then support the people having
    precompilation problems. Youppi !

    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

    -----Original Message-----
    Mladen Gogala
    Sent: Tuesday, September 30, 2003 5:15 PM
    To: Multiple recipients of list ORACLE-L
    On Tue, 2003-09-30 at 16:19, Stephane Paquette wrote:
    Like Thomas Day said, Oracle is an rdbms and COBOL a programming language.
    COBOL *** WAS *** a programming language. Horse *** WAS *** basis of
    transport. You should have used past tense, Stephane. I'm not really
    that partial when it comes to horses, but having suffered COBOL, I would
    really leave it in the ancient past, together with Spanish Inquisition
    and crucifiction as a viable capital punishment.

    Note:
    This message is for the named person's use only. It may contain
    confidential, proprietary or legally privileged information. No
    confidentiality or privilege is waived or lost by any mistransmission. If
    you receive this message in error, please immediately delete it and all
    copies of it from your system, destroy any hard copies of it and notify the
    sender. You must not, directly or indirectly, use, disclose, distribute,
    print, or copy any part of this message if you are not the intended
    recipient. Wang Trading LLC and any of its subsidiaries each reserve the
    right to monitor all e-mail communications through its networks.
    Any views expressed in this message are those of the individual sender,
    except where the message states otherwise and the sender is authorized to
    state them to be the views of any such entity.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Mladen Gogala
    INET: mladen_at_wangtrading.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: 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
    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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 30, '03 at 7:14p
activeSep 30, '03 at 10:54p
posts9
users7
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase