|
View previous topic :: View next topic
|
| Author |
Message |
Revathi Baala
New User
Joined: 27 Feb 2008
Posts: 7
Location: India
|
|
|
|
Hi,
I have a amount field in character format. Need to retrieve all the rows if the amount is greater than 5000.
FB- >80
eg. +121584.32 -> amount field.
Need to write a sort card to retrieve the amount greater than 5000.
Can you please help me.
Thanks. |
|
| Back to top |
|
 |
nelson.pandian
Active User
.jpg)
Joined: 09 Apr 2008
Posts: 133
Location: Phoenix, AZ
|
|
|
|
Hi Revathi,
Welcome to the forum.
Please provide us some sample input and expected output data. The starting position and the character length of the amount field. |
|
| Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007
Posts: 2205
Location: San Jose
|
|
|
|
Revathi Baala,
You can use the SFF format on INCLUDE COND to get the desired results.
| Code: |
//STEP0100 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD *
+121584.32 - YES
+23.11 - NO
-5000.22 - NO
+50.33 - NO
+5000.44 - YES
+4999.99 - NO
+15000.99 - YES
//SORTOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(1,10,SFF,GT,500000)
/* |
|
|
| Back to top |
|
|
Revathi Baala
New User
Joined: 27 Feb 2008
Posts: 7
Location: India
|
|
|
|
Thanks Kolusu.
I tried with you example. It worked. |
|
| Back to top |
|
|
|
|
