Re: the conversion is from Mainframe flat file to Unix Flat file - b

2001-06-16 Thread Thater, William

On Fri, 15 Jun 2001,Raymond Lee Meng Hong scribbled on the wall in glitter...:

-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.
-
-
it's Extended Binary Data Interchange Code or EBDIC and wad big blue's attempt at 
ASCII.  there should be utilities on your system to convert.  what's your OS and 
version?

--
Bill Shrek Thater   Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
God made machine language; all the rest is the work of man.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

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: [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: the conversion is from Mainframe flat file to Unix Flat file - b

2001-06-15 Thread Riyaj_Shamsudeen

Raymond
EBCDIC is the format few mainframe computer uses. Unix systems typically uses ASCII. I am not sure about the type of the file, but you may have to convert the file from EBCDIC to ASCII to make any meaning ful use of the file. You could use dd command for this conversion..
dd if=input file of=outfile conv=ascii bs=128k

Thanks
Riyaj Re-yas Shamsudeen
Certified Oracle DBA
i2 technologies  www.i2.com






Raymond Lee Meng Hong [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/15/01 09:40 PM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
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: [EMAIL PROTECTED]

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