| View previous topic :: View next topic |
| Author |
Message |
tattva
Beginner
Joined: 02 Feb 2005
Posts: 97
Topics: 36
|
 Posted: Thu Jan 03, 2008 6:09 am Post subject: Multiply and add using sort |
 |
|
Hi All,
I know a similar ques has already been asked previously. The solution didnt work for my problem.
I'm currently using SYNCSORT FOR Z/OS 1.2.1.1R version of SYNCSORT.
| Code: |
My sample input file is :
VALUE RUN-DATE AMOUNT
PS(5,6) (1-6) C(10) (7-16) PS(9,4) (17-23)
+1.000000 12-11-2007 +39710.1500
+1.000000 12-11-2007 +132470.1400
+1.000000 12-11-2007 +89346.1300
+1.000000 12-11-2007 +6.5100
+1.000000 12-11-2007 +204228.2500
+1.000000 12-11-2007 +8.7900
+1.000000 12-11-2007 +471.9600
+1.000000 12-11-2007 +13693.9500
+1.000000 12-11-2007 +38607.7500
+1.000000 12-11-2007 +10.3700
+1.000000 12-11-2007 +53559.0400
+1.000000 12-11-2007 +5897.9700
+1.000000 12-11-2007 +1501.1700
+1.000000 12-11-2007 +4581.7600
+1.000000 12-11-2007 +5189.9100
|
I need to sort out all the records if they satisfy the below condition:
| Code: |
(If Amount < 0) OR ( AMOUNT > 0 AND (DECIMAL(VALUE ) * AMOUNT < 0.001))
|
P.S: I had written to Alissa and looks like there is no solution to this with the version of syncsort mentioned above.
Is there a way to crack this?
Appreciate your help !!
Thanks |
|
| Back to top |
|
 |
vivek1983
Intermediate
Joined: 20 Apr 2006
Posts: 222
Topics: 24
|
| Posted: Fri Jan 04, 2008 1:12 am Post subject: |
|
|
tattva,
| Quote: |
P.S: I had written to Alissa and looks like there is no solution to this with the version of syncsort mentioned above.
Is there a way to crack this?
|
How abt EZT instead of syncsort in case you are not so concerned abt the methodology but the results?
I guess EZT will be useful in cracking this.
_________________
Vivek G
--------------------------------------
A dream is just a dream. A goal is a dream with a plan and a deadline. (Harvey Mackay) |
|
| Back to top |
|
|
tattva
Beginner
Joined: 02 Feb 2005
Posts: 97
Topics: 36
|
| Posted: Fri Jan 04, 2008 3:55 am Post subject: |
|
|
vivek1983,
We do not have EZT in our shop.
Frank/ Kolusu,
Any solutions in DFSORT for the above problem?
Thanks, |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose
|
| Posted: Fri Jan 04, 2008 10:42 am Post subject: |
|
|
| tattva wrote: | Frank/ Kolusu,
Any solutions in DFSORT for the above problem?
Thanks, |
Frank and I are DFSORT developers. DFSORT and Syncsort are competitive products. We are happy to answer questions on DFSORT and DFSORT's ICETOOL, but we don't answer questions on Syncsort.
And for the record YES it can be done using DFSORT
Thanks
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
tattva
Beginner
Joined: 02 Feb 2005
Posts: 97
Topics: 36
|
| Posted: Wed Jan 09, 2008 2:42 am Post subject: |
|
|
kolusu,
Am fully aware of the fact that you and Frank are DFSORT programmers.
I just wanted to know the solution using DFSORT.
Thanks |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
