Questions tagged [ebcdic]

Extended Binary Coded Decimal Interchange Code (EBCDIC) is a set of 8-bit character encodings.

Extended Binary Coded Decimal Interchange Code (EBCDIC) is a set of closely related 8-bit character encodings (code pages) used primarily on IBM mainframe operating systems such as z/OS, OS/390, VM and VSE, as well as IBM midrange computer operating systems such as OS/400 and i5/OS (see also Binary Coded Decimal).

208 questions
0
votes
1 answer

Unable to read the EBCDIC 037 decoded image (Java)

I have a EBCDIC file from which i extracted images. However, there is some data on the images which is key source in identifying my transactions. Assume that i have an image as "stackoverflow logo" stored under name "img1.jpg" on my desktop and when…
0
votes
1 answer

PHP: convert an EBCDIC binary file with compression into ASCII format

I am looking for PHP code that can convert an EBCDIC binary file in to ASCII. This EBCDIC file also has some packed data fields, the code should be able to unpack these fields as well, and present them in a readable format. EBCDIC files follow the…
Alex Maz
  • 1
  • 1
0
votes
0 answers

EBCDIC data load into oracle

I need to load this into a table in oracle. Need the table datatype definition in oracle and SQLLoader code. the upto 500 times is ok, if I get to read the data in the file to be loaded, then I can apply other oracle concepts like Unpivot to…
Jay J
  • 1
  • 1
0
votes
0 answers

Record count and Filename from VSAM Source EBCDIC encoding in Informatica PowerCenter

I need to get the filename and then count the number of records in that VSAM source file in Informatica PowerCenter 10. I had already done similar thing with other flat files in which from the source instance I can get the file name by checking…
KeenLearner
  • 685
  • 1
  • 8
  • 25
0
votes
1 answer

DB2 json values fetch contains strange characters "NEL" when viewed through Notepad++

We have a problem while viewing the JSON file that contains "\r\n" fetched from DB2 (encoding scheme EBCDIC). When we check the content of the attribute with TOAD directly in the database, we see that we have correct Hex-values for CRLF. We are…
Chammu
  • 103
  • 3
  • 13
0
votes
0 answers

How to load EBCDIC file into relational tables ( Oracle, SQL Server etc.) using Informatica Power Center

I have a mainframe source file in EBCDIC format. I need to load it in Oracle database . We also have Informatica Power Center and SSIS ETL tools. What is the easiest way to load it in relational tables using or without using above tools? How to…
0
votes
2 answers

We have many mainframe files which are in EBCDIC format, is there a way in Python to parse or convert the mainframe file into csv file or text file?

I need to read the records from mainframe file and apply the some filters on record values. So I am looking for a solution to convert the mainframe file to csv or text or Excel workbook so that I can easily perform the operations on the file. I also…
umesh
  • 1
  • 3
0
votes
0 answers

Conversion of text which is in format CP037 to hexadecimal

I have a text in the below format which is CP037 format and I want that to be converted to hexadecimal format in java. Text1 - AGNSAæûÃÃÂõÂjÂq  à Text2 - AGNS²t Âµ.nÂZ|ÂÂÃà First I thought of converting it to ascii and then to…
user11201509
0
votes
1 answer

EBCDIC unpacking comp-3 data returns 40404** in Java

I have used the unpack data logic provided in below link for java How to unpack COMP-3 digits using Java? But for the null data in source it returns 404040404 like on Java unpack code. I understand this was space in ebcdic, but how to unpack by…
Rajesh
  • 69
  • 1
  • 6
0
votes
0 answers

TimeStamp issue while migrating from ebcdic fromat to ascii format

I am having an issue while converting ebcdic to ascii format. The ebcdic file which is on mainframe has creation and modification time back in 1990 and when I migrated them to Linux, their modification time became 2018. How can I change back so that…
flow
  • 63
  • 6
0
votes
1 answer

Reading a SEG-Y file with EBCDIC and binary data contents in Fortran

I am reading a SEG-Y file (used in geophysics to store data) which has 2 header sections, the first is 3200 bytes containing information in EBCDIC format, while the second header is in binary format and is 400 bytes length. The data later follows…
PolarXYZ
  • 63
  • 8
0
votes
1 answer

Informatica v10.2 - Transformation for ASCII to EBCDIC

I need to convert data from ASCII to EBCDIC in an Informatica Transformation. I have attempted to use CONVERT_BASE in an expression using string datatypes for the currency data, but received a non-fatal error. I've also googled a fair amount and…
0
votes
2 answers

Is there an EBCDIC_STR function on IBMi

I'm running into issue with character encoding and I found the functions EBCDIC_STR, ASCII_STR in Db2 for z/OS. Are there similar function for Db2 for IBM i?
Ben. L.
  • 28
  • 2
  • 7
0
votes
0 answers

EBCDIC to UTF-8 encoding

I need an advice. I retrieve a string from a cobol routine that should contain the German "ü" but the EBCDIC encode it as "è" . When the string is passed to that has to xml the UTF-8 encode it as #252# instead of the "ü". Can someone help me on…
romanek
  • 1
  • 1
0
votes
1 answer

How to convert ebcdic format to ASCII using Scala?

How do I convert EBCDIC format to ASCII using Scala programming?