View previous topic :: View next topic
|
Author |
Message |
169354 Currently Banned New User
Joined: 14 May 2007 Posts: 5 Location: chennai
|
|
|
|
My input records looking like this.
000000.00
000012.01
000046.65
000000.00
I want the records greater than 0.00 value. i want to delete the records having values less than or equal to 000000.00
Then I have to subtract 0.01 from the remaining records. Is it possible thro sort or icetool?
These records starting at postion 30.
Output should be looks like..
000012.00
000046.64
lrecl=80 and fixed block. |
|
Back to top |
|
|
169354 Currently Banned New User
Joined: 14 May 2007 Posts: 5 Location: chennai
|
|
|
|
My input records looking like this.
000000.00
000012.01
000046.65
000000.00
i want the records greater than 0.00 value. i want to delete the records having values less than 000000.00
then i have to subtract 0.01 from the remaining records. is it possible thro easytrieve?
these records starting at postion 30.
output should be looks like..
000012.00
000046.64
lrecl=80 and fixed block. need immediate reply plz |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
169354 wrote: |
is it possible thro easytrieve? |
Yes, quite easy.....
Define the input as two fields separated by the decimal point and move them to two fields next to each other.
Redefine those two fields as a single numeric field with an implied decimal.
Do your testing and math on the field, move it to an edited output field and write it out. |
|
Back to top |
|
|
169354 Currently Banned New User
Joined: 14 May 2007 Posts: 5 Location: chennai
|
|
|
|
Sorry friend,
am very new to easytrieve.. whatever u mentioned i couldnt able to understand .. can u plz write the code for this? |
|
Back to top |
|
|
169354 Currently Banned New User
Joined: 14 May 2007 Posts: 5 Location: chennai
|
|
|
|
i got the data excp error soc7 error...
couldnt able to fix it. |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
Do you have access to the Application Guide and the Reference Guide? |
|
Back to top |
|
|
foliater
New User
Joined: 06 Apr 2006 Posts: 31
|
|
|
|
Eliminating records will not be a great deal.
Add the below step in your SYSIN
OMIT COND(30,9,CH,LE,C'000000.00')
To subtract values, you have use COBOL. Not possible in SORT. |
|
Back to top |
|
|
|