RE: COBOL TO ORACLE
Welcome to MY world :-( Basically, we need to get a Volkswagen to run faster than a Ferrari. -Original Message- Sent: 2003-10-07 4:29 PM To: Multiple recipients of list ORACLE-L I went to IBM's web site (http://www-1.ibm.com/servers/eserver/zseries/os/) and found OS/390 - OS/390 OS/390, the foundation of the new z/OS, provides high levels of availability, scale and manageability for mission-critical workloads, with such features as Workload Manager and Parallel Sysplex support. OS/390 is an integrated offering of many elements and optional features, including new technologies such as Enterprise Java Beans, XML, and HTML. OS/390 provides the qualities of service needed to meet the demands of global e-business. Notice the mention of Workload Manager --- Basically setting the priorities of various processes as to when they will be swapped back in. I suspect that your SYSADMIN is trained in the current version but does not understand the underlying technology. If there were no swapping then only one user could be signed on at a time, they could only run one process, and when they went to print the process would stop until the printing was finished. babette.turneru nderwood To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @hrdc-drhc.gc.ca cc: Subject: RE: COBOL TO ORACLE Sent by: ml-errors 10/07/2003 03:59 PM Please respond to ORACLE-L Sorry for the delay ... Was at Ottawa Oracle User Group Days last week and spent the time since then playing catch-up Yes, we are using OS/390 v10. I STRONGLY suspect the SYSADMIN is wrong. There HAS to be swapping / paging going on, but he insists this is not the case. Babette Turner-Underwood work: [EMAIL PROTECTED] home: [EMAIL PROTECTED] 954-3752 (Mon - Fri 7am - 3pm) -Original Message- Sent: 2003-10-01 4:00 PM To: Multiple recipients of list ORACLE-L What kind of a mainframe is that? Usually mainframe means an IBM machine based on 370 architecture. If that's the case then your SYSADMIN is wrong. Many, many years ago I started out as a computer operator for an IBM 370/165 and worked with IBM mainframes up through the E6000 series. They all work as virtual machines, swapping and paging sessions in and out of the physical RAM. Of course, you may have some other type of mainframe, in which case, what I said doesn't apply. babette.turneru nderwood To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @hrdc-drhc.gc.ca cc: Subject: RE: COBOL TO ORACLE Sent by: ml-errors
RE: COBOL TO ORACLE
Sorry for the delay ... Was at Ottawa Oracle User Group Days last week and spent the time since then playing catch-up Yes, we are using OS/390 v10. I STRONGLY suspect the SYSADMIN is wrong. There HAS to be swapping / paging going on, but he insists this is not the case. Babette Turner-Underwood work: [EMAIL PROTECTED] home: [EMAIL PROTECTED] 954-3752 (Mon - Fri 7am - 3pm) -Original Message- Sent: 2003-10-01 4:00 PM To: Multiple recipients of list ORACLE-L What kind of a mainframe is that? Usually mainframe means an IBM machine based on 370 architecture. If that's the case then your SYSADMIN is wrong. Many, many years ago I started out as a computer operator for an IBM 370/165 and worked with IBM mainframes up through the E6000 series. They all work as virtual machines, swapping and paging sessions in and out of the physical RAM. Of course, you may have some other type of mainframe, in which case, what I said doesn't apply. babette.turneru nderwood To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @hrdc-drhc.gc.ca cc: Subject: RE: COBOL TO ORACLE Sent by: ml-errors 10/01/2003 03:09 PM Please respond to ORACLE-L Then perhaps you can help me . . . We are suffering through a Pro*Cobol / Oracle on the mainframe implementation for a newly developed in house application. We have a mainframe with 1.7GB - 2GB REAL memory. 4 CPU machine - we have two logical CPUs in our LPAR We have 8 instances running (each with at least 300MB SGA) We are having major performance problems when people start doing a lot of work on these instances. The Mainframe SYSADMIN insists that there is NO swapping, NO paging occuring. There is no problem because each instance can have 2GB VIRTUAL memory and this is fine and dandy because this is how the mainframe works. Did you ever use Oracle on a mainframe? Did you come up with guidelines for minimum requirements? (like in the UNIX install guides / NT install guides, you need X RAM, etc) Thanks Babette -Original Message- Sent: 2003-09-30 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
RE: COBOL TO ORACLE
I went to IBM's web site (http://www-1.ibm.com/servers/eserver/zseries/os/) and found OS/390 - OS/390 OS/390, the foundation of the new z/OS, provides high levels of availability, scale and manageability for mission-critical workloads, with such features as Workload Manager and Parallel Sysplex support. OS/390 is an integrated offering of many elements and optional features, including new technologies such as Enterprise Java Beans, XML, and HTML. OS/390 provides the qualities of service needed to meet the demands of global e-business. Notice the mention of Workload Manager --- Basically setting the priorities of various processes as to when they will be swapped back in. I suspect that your SYSADMIN is trained in the current version but does not understand the underlying technology. If there were no swapping then only one user could be signed on at a time, they could only run one process, and when they went to print the process would stop until the printing was finished. babette.turneru nderwood To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @hrdc-drhc.gc.ca cc: Subject: RE: COBOL TO ORACLE Sent by: ml-errors 10/07/2003 03:59 PM Please respond to ORACLE-L Sorry for the delay ... Was at Ottawa Oracle User Group Days last week and spent the time since then playing catch-up Yes, we are using OS/390 v10. I STRONGLY suspect the SYSADMIN is wrong. There HAS to be swapping / paging going on, but he insists this is not the case. Babette Turner-Underwood work: [EMAIL PROTECTED] home: [EMAIL PROTECTED] 954-3752 (Mon - Fri 7am - 3pm) -Original Message- Sent: 2003-10-01 4:00 PM To: Multiple recipients of list ORACLE-L What kind of a mainframe is that? Usually
AW: COBOL TO ORACLE
Hi I'm basically doing the same: We're using PL1 programs to do an "unload" of VSAM files by hand. That actually takes care of multiple record structures and the like. It's a poor-man's normalisation of VSAMs ;). Then, just load the data as it is into a staging DB (Oracle), transform it and push it into the production DB (also Oracle). What I don't understand about the original eMail is the COBOL to Oracle part, but relating to the data ?! I guess moving the HOST based data was meant ? And regarding to connecting to VSAM or the like directly from Designer (via reading the copy books for instance), ... it either doesn't exist or we didn't find it ;). I opt for the first. PS: Having to use Oracle Designer is about as cool as crucification. Stefan -Ursprüngliche Nachricht-Von: Govindan K [mailto:[EMAIL PROTECTED]Gesendet: Mittwoch, 1. Oktober 2003 02:04An: Multiple recipients of list ORACLE-LBetreff: Re: COBOL TO ORACLE 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. If you are using SQL*Loader make sure to check the log after load. For larger loadsi would suggest direct load. The second question is did anyone use DESIGNER to connect to COBOL to create an ERD and then transform into ORACLE tabels script? I wonder how a tool will take care of Implicit Redefinition/Multiple Record Structures unless the Developer/DBA mentions them somewhere. HTH GovindanK-Original Message- From: Muqthar AhmedSent: 9/30/2003 12:16:28 PMTo: [EMAIL PROTECTED]Subject: Re: COBOL TO ORACLEHi, Thanks Muqthar Ahmed DBA Author: Muqthar Ahmed INET: [EMAIL PROTECTED] . ___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!
RE: COBOL TO ORACLE
LOL Of course the spent a lot on money on veterinarians to inoculate the horses against the Y2K bug. Mladen Gogala mladen To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @wangtrading.com cc: Subject: RE: COBOL TO ORACLE Sent by: ml-errors 09/30/2003 05:14 PM Please respond to 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: COBOL TO ORACLE
COBOL isn't dead, it just smells funny. You know what COBOL stands for, don't you? COBOL=Completely Outdated, Badly Overused Language. On Tue, 2003-09-30 at 17:24, April Wells wrote: 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- From: Mladen Gogala [mailto:[EMAIL PROTECTED] 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. 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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. 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: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list
Re: COBOL TO ORACLE
Wonderful race, the Romans. Just super! sniff! on 9/30/03 3:34 PM, Jesse, Rich at [EMAIL PROTECTED] wrote: 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 [mailto:[EMAIL PROTECTED] 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: Tim Gorman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: COBOL TO ORACLE
Then perhaps you can help me . . . We are suffering through a Pro*Cobol / Oracle on the mainframe implementation for a newly developed in house application. We have a mainframe with 1.7GB - 2GB REAL memory. 4 CPU machine - we have two logical CPUs in our LPAR We have 8 instances running (each with at least 300MB SGA) We are having major performance problems when people start doing a lot of work on these instances. The Mainframe SYSADMIN insists that there is NO swapping, NO paging occuring. There is no problem because each instance can have 2GB VIRTUAL memory and this is fine and dandy because this is how the mainframe works. Did you ever use Oracle on a mainframe? Did you come up with guidelines for minimum requirements? (like in the UNIX install guides / NT install guides, you need X RAM, etc) Thanks Babette -Original Message- Sent: 2003-09-30 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: COBOL TO ORACLE
Eeep! Reminds me of my CICS programming in school on a 4MB (MEGA bytes) IBM 4341 with the student partition on the lowest priority. For some reason, the operator got really mad at me when I forgot to put an unexecutable EXIT statement in my code... Barring any OS stats, have you tried a 10046 trace on any of the slow processes to see where the holdup is? It's been about 15 years since my mainframe days in school, but I'd still question 2.4GB worth of SGA on a 2GB machine, and that's without server processes, OS, etc... What is virtual memory? DISK! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 2:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: COBOL TO ORACLE Then perhaps you can help me . . . We are suffering through a Pro*Cobol / Oracle on the mainframe implementation for a newly developed in house application. We have a mainframe with 1.7GB - 2GB REAL memory. 4 CPU machine - we have two logical CPUs in our LPAR We have 8 instances running (each with at least 300MB SGA) We are having major performance problems when people start doing a lot of work on these instances. The Mainframe SYSADMIN insists that there is NO swapping, NO paging occuring. There is no problem because each instance can have 2GB VIRTUAL memory and this is fine and dandy because this is how the mainframe works. Did you ever use Oracle on a mainframe? Did you come up with guidelines for minimum requirements? (like in the UNIX install guides / NT install guides, you need X RAM, etc) Thanks Babette -Original Message- Sent: 2003-09-30 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: COBOL TO ORACLE
What OS are you using? I assume the COBOL app resides on the same box as the database? When performance is poor, can you see what the top processes are? As for the merits of COBOL, our COBOL apps hum along very nicely, processing millions of records a month. Also, I like having conversations with developers that tell me I connect to the database and run this SQL statement... vs getting into some convoluted discussion about objects, object servers, ODBC formatted SQL, etc. Perhaps I'm blissfully ignorant about some aspects of programming, but I can tell you that our COBOL programs that follow the KISS method give us the least amount of headaches. Jay [EMAIL PROTECTED] 10/01/03 03:09PM Then perhaps you can help me . . . We are suffering through a Pro*Cobol / Oracle on the mainframe implementation for a newly developed in house application. We have a mainframe with 1.7GB - 2GB REAL memory. 4 CPU machine - we have two logical CPUs in our LPAR We have 8 instances running (each with at least 300MB SGA) We are having major performance problems when people start doing a lot of work on these instances. The Mainframe SYSADMIN insists that there is NO swapping, NO paging occuring. There is no problem because each instance can have 2GB VIRTUAL memory and this is fine and dandy because this is how the mainframe works. Did you ever use Oracle on a mainframe? Did you come up with guidelines for minimum requirements? (like in the UNIX install guides / NT install guides, you need X RAM, etc) Thanks Babette -Original Message- Sent: 2003-09-30 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. **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: COBOL TO ORACLE
What kind of a mainframe is that? Usually mainframe means an IBM machine based on 370 architecture. If that's the case then your SYSADMIN is wrong. Many, many years ago I started out as a computer operator for an IBM 370/165 and worked with IBM mainframes up through the E6000 series. They all work as virtual machines, swapping and paging sessions in and out of the physical RAM. Of course, you may have some other type of mainframe, in which case, what I said doesn't apply. babette.turneru nderwood To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @hrdc-drhc.gc.ca cc: Subject: RE: COBOL TO ORACLE Sent by: ml-errors 10/01/2003 03:09 PM Please respond to ORACLE-L Then perhaps you can help me . . . We are suffering through a Pro*Cobol / Oracle on the mainframe implementation for a newly developed in house application. We have a mainframe with 1.7GB - 2GB REAL memory. 4 CPU machine - we have two logical CPUs in our LPAR We have 8 instances running (each with at least 300MB SGA) We are having major performance problems when people start doing a lot of work on these instances. The Mainframe SYSADMIN insists that there is NO swapping, NO paging occuring. There is no problem because each instance can have 2GB VIRTUAL memory and this is fine and dandy because this is how the mainframe works. Did you ever use Oracle on a mainframe? Did you come up with guidelines for minimum requirements? (like in the UNIX install guides / NT install guides, you need X RAM, etc) Thanks Babette -Original Message- Sent: 2003-09-30 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: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: COBOL TO ORACLE
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 [EMAIL PROTECTED] @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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: COBOL TO ORACLE
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: COBOL TO ORACLE
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 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -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 [EMAIL PROTECTED] @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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: COBOL TO ORACLE
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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. 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: COBOL TO ORACLE
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 [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: COBOL TO ORACLE
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 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: COBOL TO ORACLE
Title: RE: COBOL TO ORACLE 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- From: Mladen Gogala [mailto:[EMAIL PROTECTED]] 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. 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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.
Re: COBOL TO ORACLE
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. If you are using SQL*Loader make sure to check the log after load. For larger loadsi would suggest direct load. The second question is did anyone use DESIGNER to connect to COBOL to create an ERD and then transform into ORACLE tabels script? I wonder how a tool will take care of Implicit Redefinition/Multiple Record Structures unless the Developer/DBA mentions them somewhere. HTH GovindanK-Original Message- From: Muqthar AhmedSent: 9/30/2003 12:16:28 PMTo: [EMAIL PROTECTED]Subject: Re: COBOL TO ORACLEHi, Thanks Muqthar Ahmed DBA Author: Muqthar Ahmed INET: [EMAIL PROTECTED] . ___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!
RE: COBOL to Oracle
There is an interface in the rdbms. Look for the precomp directory of your ORACLE installation. Check the docs for precompilers and cobol. HTH, Ruth -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Friday, September 05, 2003 8:09 PMTo: Multiple recipients of list ORACLE-LSubject: COBOL to OracleHi List,Does anyone know of tools, or have had experience using tools, that will quickly convert COBOL code to Oracle. Any information you can provide would be greatly appreciated.Thanks in advance.Rick
COBOL to Oracle
Hi List, Does anyone know of tools, or have had experience using tools, that will quickly convert COBOL code to Oracle. Any information you can provide would be greatly appreciated. Thanks in advance. Rick
RE: COBOL to Oracle
Do you mean that the COBOL code would be translated to PL/SQL packages, or that the COBOL I/O would be changed to SQL insert/update/select using Pro*COBOL instead of READ and WRITE? Or do you mean that the COBOL programs would be automagically transformed into an Oracle database? One datafile for each program source code file? The mind boggles. -Original Message- Does anyone know of tools, or have had experience using tools, that will quickly convert COBOL code to Oracle. Any information you can provide would be greatly appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: COBOL to Oracle
[EMAIL PROTECTED] wrote: Hi List, Does anyone know of tools, or have had experience using tools, that will quickly convert COBOL code to Oracle. Any information you can provide would be greatly appreciated. Thanks in advance. Rick What do you mean by converting Cobol to Oracle ? One one side you have a programming language, and on the other side a subsystem to handle data without having to open files, read, blahblah. Would you dream of concerting VB to Excel ? I presume that what you wan to do is to replace your Cobol file accesses to ISAM files or the like to access to relational tables. The forget about the QUICK, because you will have to rethink everything if you want the effort to be worthwhile. FYI there used to be and should still be a product napmed PRO*Cobol allowing to embed SQL statements in Cobol code (SQL statements replaced by library calls by a preprocessor). This is the direction I would take. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: COBOL to Oracle
I wonder how the code generator is going to take care of Multiple Record Types , Redefines clauses , Renames clause, GO to statements, Perform Thru , Declaratives? That would be interesting. GovindanK Hi List, Does anyone know of tools, or have had experience using tools, that will quickly convert COBOL code to Oracle. Any information you can provide would be greatly appreciated. Thanks in advance. Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).