Joined: 09 Oct 2006 Posts: 12 Location: Chennai, India
Quote:
Can you have E+0 and/or E-0?
No.
Quote:
what is the maximum exponent you can have?
Max 1 exponent. Example: E+2, E+3 etc.
Quote:
Is every value put into a form that has 12 characters?
Yes. The length is 12 which is inclusive of the "." - decimal point, "E" exponent. Also, there can be only maximum 2 digits before the decimal point. Example: 1.2345678912 and 12.345678912
Quote:
Which of the following would you want in the output data set?
The output should contain the values greater than 9.
None of your example shall be in the output as they are all ".9"s.
Examples:
As discussed, we may ignore the values with negative exponents as they will certainly be lesser than 9. But these need to be calculated to ignore the ones which are lesser than 9.
1.3456789012 - this won't be there in the o/p
1.3456789E+2 - this should be there in the o/p
0.0091234E+4 - this should be there in the o/p
9.0012332E-2 - this should NOT be there in the o/p as it would be < 9
9.0010012341 - this should be there in the o/p
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
This is quite tricky, but I believe the following DFSORT job will do what you asked for. I assumed your input file has RECFM=FB and LRECL=20, but the job can be changed appropriately for other attributes.