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