IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

how to check the nagative values in the sort ........


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
VENKATA999
Warnings : 2

New User


Joined: 05 Jan 2006
Posts: 44

PostPosted: Tue Apr 25, 2006 9:34 pm
Reply with quote

Hi Friends ,

I have a query in sorting . i have input file like

Code:

01   rama             -2000
02   krishna          -2500
03   kiran            -2500
04   tan               6000
05   arun             -2500


can any one help me how to write the include cond to retrive the values equal to -2500 .

#2 . The other query is where do we use the format parameter's FI , FL .

I am aware of ch , pd , zd , AC , But not above . If any one give the example code it would be a great help to me .


Thanks in advance ,
Venkata .
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Tue Apr 25, 2006 9:48 pm
Reply with quote

Quote:
can any one help me how to write the include cond to retrive the values equal to -2500.


You can use this INCLUDE statement:

Code:

   INCLUDE COND=(23,5,FS,EQ,-2500)


Quote:
where do we use the format parameter's FI , FL


FI is the format for signed fixed-point data. This is similar to BI, but whereas BI only allows positive values, FI allows positive and negative values. Negative values are in 2's complement form.

Example: X'0001' = 1, X'FFFF' = -1

You would use FI when you have signed fixed-point data values.

FL is the format for signed hexadecimal floating-point data. The value has a sign, a characteristic and a fraction.

You would use FL when you have signed hexadecimal floating-point data.

For more information on the various formats you can use with DFSORT, see Appendix C of "z/OS DFSORT Application Programming Guide". You can access it from:

Use [URL] BBCode for External Links

I'd suggest using the PDF version as it's formatted better.
Back to top
View user's profile Send private message
hariavinash

New User


Joined: 04 Jan 2006
Posts: 64

PostPosted: Tue Apr 25, 2006 9:54 pm
Reply with quote

Code:

//STEP000  EXEC PGM=SORT
//SORTIN   DD  *
;LJASD   +9939
;LJASD   -9939
;LJASD   +9933
;LJASD   -9934
;LJASD   +9935
//SORTOUT  DD  SYSOUT=*
//SYSIN    DD  *
  SORT FIELDS=COPY
  INCLUDE COND=(10,1,CH,EQ,X'60')
//SYSOUT   DD  SYSOUT=*
//SYSUDUMP DD  SYSOUT=*
//*
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Tue Apr 25, 2006 10:50 pm
Reply with quote

hariavinash,

The request was for records with -2500. Your "solution" includes any record with '-' in position 10. That would include the -2000 record as well as the -2500 records.

Please test your jobs before you post them.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts JCL sort card - get first day and las... JCL & VSAM 9
Search our Forums:

Back to Top