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