Convert COMP-1 to Readable

gylbharat · Posted: Mon Aug 27, 2012 1:29 pm

Hi,

I tried running with EDIT masks... But every data can be different depending upon power of 10. In such cases how do we specify how many digits there will be after decimal point.

Example.

INPUT FILE:

Bill Woodger · Posted: Mon Aug 27, 2012 1:37 pm

Easy. There will always be one digit in front of the decimal place. By convention, this will either be significati (1 through 9) or zero. The rest of (or the entire) the number is represented in the decimal part, and carries a "scaling" factor, like your example. E+09, E-02. Which is X10 to the power of 9, and X10 to the power of minus 2 (the last is a number less than 1 or greater than -1 if the number is negative.

If there is nothing in the MASK which supports this notation, then you can't do it with the MASK.

Which leaves, doing it in a program, or trying to "unpick" the data format. If you want to try the last, you have to find out how COMP-1 is stored (COMP-2 is the same, just longer).

gylbharat · Posted: Mon Aug 27, 2012 2:38 pm

Is there a way in sort to convert FL to External floating point as 1.23E+01

Bill Woodger · Posted: Mon Aug 27, 2012 2:52 pm

This is taking a long time :-)

You have Syncsort documentation. You can check whether there is anything in the edit MASK which supports floating point.

If there is not, you either have to "invent" a method to do it by decomposing the format of the data that the "float" is held in, or your need to do it in something else (as was suggested much earlier in the thread).

gylbharat · Posted: Mon Aug 27, 2012 3:31 pm

I do not have syncsort documentation... However, I checked the edit masks given in the below link...

www.ibmmainframes.com/post-40358.html

looks like there is no edit mask for floating point numbers.

Bill Woodger · Posted: Mon Aug 27, 2012 3:36 pm

OK, I suspect that it has been suggested to you before to get the documentation. So, do it.

For now that leaves you with understanding how COMP-1 is represented in binary and working out how to take it apart with Syncsort.

or

Doing it in a program.

I get the feeling I've written this more than once in this thread :-)

gylbharat · Posted: Mon Aug 27, 2012 3:44 pm

Thanks Bill... I will check out the documentation.

dick scherrer · Posted: Mon Aug 27, 2012 6:52 pm

Hello,

In case this has not been mentioned previously, the material is available from Syncsort Support for free to organizations that are licensed to use Syncsort.

Over the weekend i did a bit of reading in the current Syncsort documentation. While Floating Point is "supported", i did not see a way to get the output you want.

I'd suggest opening an issue with Syncsort Support and they can explain how to do this - if it is possible. We'd appreciate an update either way

Not to beat up the same thought - but how does the current application show these fields?

enrico-sorichetti · Posted: Mon Aug 27, 2012 6:54 pm

time to lock the topic,
the useless back and forth is just a waste of time for everybody