View previous topic :: View next topic
|
Author |
Message |
vijayamadhuri
Active User
Joined: 06 Apr 2005 Posts: 180
|
|
|
|
My criteria is as follows
file-1 of length 368 at position 100 has values 'ac' or ' ' and position 200 has an amount field in the format.-s9(5) v99
file-2 of length 80 position 50 has an amount value s9(5) v99
file-3 of length 700 at position 400 has an amount -s9(5) v99
I have to create a report saying
credit card --current date
count -- This should be equal to all the 'ac' in file 1 and the total records in file-2
Total amount -- total amount of file 1 with 'ac' and total amount in file 2
check payments --current date
count - This should be equal to all the ' ' in file 1 and the total records in file-3
Total amount -- total amount of file 1 with ' ' and total amount in file 3
My shop has only sysnsort ..so please could you provide me a soloution using syncsort.. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
While this might be done as you want with Syncsort, if you need this quickly, i'd suggest putting together a bit of code and getting your totals. |
|
Back to top |
|
|
|