Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: the conversion is from Mainframe flat file to Unix Flat file

RE: the conversion is from Mainframe flat file to Unix Flat file

From: Raymond Lee Meng Hong <RAYMOND_at_infopro.com.my>
Date: Fri, 15 Jun 2001 21:19:54 -0700
Message-ID: <F001.0032C37A.20010615212545@fatcity.com>

Thank for your help..

I will ask my customer to dd for me later on..

currently I don't have any unix system in front of me ,can you find it for me the command ?
to transfer EBCDIC to Ascii.

-----Original Message-----
Sent: Saturday, June 16, 2001 12:25 PM
To: Multiple recipients of list ORACLE-L file

Hi Raymond,
 EBCDIC= Extended Binary-Coded Decimal Interchange Code. A format developed by IBM a long time ago to represent characters as numbers for the computers. This format is mainly used by Mainframe computers (those big monster computers in that cold room with a combination lock on the door ;-)

 Most PCs, Apple/Macs, UNIX use ASCII code (ASCII = American Standard Code for Information Interchange) to do the same.

 To read the EBCDIC coded data on a UNIX server, you will need to use 'dd' command that can read and convert data coded in EBCDIC to ASCII, provided the tape drive can read that tape. I think it should not contain any tape label (unlabelled tape). There may be some third party tools to do the same on NT/Win2K.  

Hope this helps.  

Regards,

> -----Original Message-----
> From: Raymond Lee Meng Hong [SMTP:RAYMOND_at_infopro.com.my]
> Sent: Friday, June 15, 2001 9:40 PM
> To: Multiple recipients of list ORACLE-L
> Subject: the conversion is from Mainframe flat file to Unix Flat file
> - b
>
> what is EBCDIC format
>
> I have a customer from IBM DB2 mainframe going to pass data to my oracle
> system for matching of record ,what they told me is the tape is in EBCDIC
> format ? I don't have any experience on these format ? can anyone please
> explain /guildline on these ?
>
>
> Raymond fall asleep in waiting for the Q.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Raymond Lee Meng Hong
> INET: RAYMOND_at_infopro.com.my
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raymond Lee Meng Hong
  INET: RAYMOND_at_infopro.com.my

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).
Received on Fri Jun 15 2001 - 23:19:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US