Re: COBOL Batch programs on OS/390 accessing Oracle DB on SUN ...

Rob,

Be advised also that you are moving from an EBCDIC code environment to an ASCII environment. Your data will be sorted in a different order on the UNIX database. In some instances this will only cause output to appear in a different sequence. However, if your programs do any processing that depends on the order of the order of the data, it will appear out of order. The biggest difference is that the numbers sort after the letters in EBCDIC and before the numbers in ASCII.

Another difference is that DB/2 considers that the day runs from 00:00:01 to 24:00 and Oracle goes from 00:00:00 to 23:59:59.

You may also see performance differences because of the different optimizers.

Cheers,

Paul

• Original Message ----- From: "Booyse Nico" <booysen_at_saps.org.za> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, June 07, 2000 3:05 AM Subject: RE: COBOL Batch programs on OS/390 accessing Oracle DB on SUN ...

> Hi Rob
>
> We are using batch Pro*Cobol programs running on OS/390 which connects via
> SQL*Net to an Oracle on Sun database. You don't need a RDBMS on the
> mainframe to accomplish this but you will need a TNS subsystem which is
> needed to open a remote SQL*Net connection. If you want to use Pro*Cobol
you
> will also need the pre-compilers for OS/390.
>
> Regards,
> Nico
>
>
> ----------
> From: Rob Wright [SMTP:rwright_at_lic.co.nz]
> Sent: Wednesday, June 07, 2000 5:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: COBOL Batch programs on OS/390 accessing Oracle DB on SUN
> ...
>
>
>
> Please pardon my ignorance ...
>
> I am currently investigating the possibility of implementing an
> Oracle database
> on a SUN box. We have a batch DB2
> application suite which we would like to leave on our OS/390.
> However, rather
> than talk to a DB2 database, we would
> like it to talk to the Oracle database on the SUN box.
>
> Is it possible for the batch application to communicate with Oracle
> on the SUN?
> Is it possible without having an RDBMs on the OS/390?
> What components do we need to achieve this?
>
> Answers to any of these questions would be greatly appreciated.
>
> Thanks
> Rob
>
>
> --
> Author: Rob Wright
> INET: rwright_at_lic.co.nz
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> 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).
> --
> Author: Booyse Nico
> INET: booysen_at_saps.org.za
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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
Received on Wed Jun 07 2000 - 06:32:51 CDT