-
Notifications
You must be signed in to change notification settings - Fork 80
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Cobrix returning hexadecimal value in different format (qb) #625
Comments
There could be several reasons for such behavior. Possibly, the data is in a different code page (not EBCDIC common). Please, provide an example value and corresponding value in '_debug' field. I know it is sensitive, hope a single QBxxxx number is not |
Hi Ruslan,
"column":"qb","column_debug":"988200007600" . |
So EBCDIC What output you expect for this column? What abinitio shows for this field and this record? |
Hi Ruslan, I got some information from the customer. Ab initio reading data "988200007600" in the following format: "qb\x00\x00\x00\x00" Then they use some function to cast it back to 988200000000 Transformation used: (decimal(12)) reinterpret_as(packed decimal(12,stripped), ) |
I see. One workaround that you can use is:
This will only work with the latest Cobrix (2.6.8) |
Hi All,
When I am reading hexadecimal data from Cobol file using Cobrix, the output is in a different format. I have tried to cast it using Spark SQL and Pyspark. But there is no use.
The data type defined in copy book is PIC X(06). In most cases, it is getting converted to "qb" with one or 2 spaces after that. Can anyone please help me with this? Whereas Abinitio reads the same data as "qbXXX". Some characters after "QB". But in Abinitio they were able to cast that value to hexadecimal.
As the data we are reading is highly sensitive, we could not able to get it from our customer. So I couldn't able to share the file here.
Thanks in advance,
Narayana
The text was updated successfully, but these errors were encountered: