Hi, Can anyone please help me to convert the input Binary column to be converted to Decimal.
Input string is "08 16 O 00 0f 08 16 O f5 f0 f1 f0 f0 e8 e8 f0 f0 f1 f1 d5 @ @ 07 85 14 8f 00 0f 00 00 00 0f 00 00 00 03 8c 01 d 09 / f0 f2 f0 f2"
Output should be Decimal value.
Can please anyone help me on this?
This is urgent.
Thanks in Advance.
Convert Binary to Decimal in PX 8.0.1
Moderators: chulett, rschirm, roy
The issue might be urgent for you, but not to DSXchange. Ray puts it into a much nicer wording than I do.
"Binary" just means non-ascii unless you specify what format it is in. Without knowing what format it is, no conversion is possible. But my first guess is that you are looking at more than one number considering the length of the string.
"Binary" just means non-ascii unless you specify what format it is in. Without knowing what format it is, no conversion is possible. But my first guess is that you are looking at more than one number considering the length of the string.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I appologise for words mismatch from my side, i must have typed in "Issue is Urgent for me".
This is the Filler column from CFF which was stored into dataset as a binary column in our Cycle 1 jobs, now in Cycle 2 we are using this dataset and extracting the information stored in Filler column, this is a Hex Data and we tried many routines but it just throws error "Unable to convert Raw to String."
Please do help me.
Thanks N Regards.
This is the Filler column from CFF which was stored into dataset as a binary column in our Cycle 1 jobs, now in Cycle 2 we are using this dataset and extracting the information stored in Filler column, this is a Hex Data and we tried many routines but it just throws error "Unable to convert Raw to String."
Please do help me.
Thanks N Regards.
-
- Premium Member
- Posts: 36
- Joined: Wed Dec 27, 2006 3:50 am
- Location: Phoenix
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What size decimal?
There is information in the manuals about how decimal numbers are stored, but the number of bytes depends on both the precision and the scale.
There is information in the manuals about how decimal numbers are stored, but the number of bytes depends on both the precision and the scale.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Convert Binary to Decimal in PX 8.0.1
I can't see you getting an 18 digit decimal out of that input, I can't even see an 18 digit packed decimal in it... or do you mean literally each character in to decimal equivalent?satishm wrote:Hi, Can anyone please help me to convert the input Binary column to be converted to Decimal.
Input string is "08 16 O 00 0f 08 16 O f5 f0 f1 f0 f0 e8 e8 f0 f0 f1 f1 d5 @ @ 07 85 14 8f 00 0f 00 00 00 0f 00 00 00 03 8c 01 d 09 / f0 f2 f0 f2"
Output should be Decimal value.
Can please anyone help me on this?
This is urgent.
Thanks in Advance.