| IBM MAINFRAME HELP & SUPPORT FORUMS Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
|
| View previous topic :: View next topic |
| Author |
Message |
rameshbabu
Joined: 23 May 2005
Posts: 27
|
| Posted: Fri Jun 03, 2005 5:34 pm Post subject: how i can give the value of packed decimal thru jcl? |
|
|
hi
when i am searching the data for a perticular packed decimal field say for example i want to know the how many records having the corp-id > 0
then how can i give in the sort
sort fields=copy
include cond=(1,5,pd,gt,x'???????') |
|
| Back to top |
|
Frank Yaeger
Joined: 15 Feb 2005
Posts: 4579
Location: San Jose, CA
|
| Posted: Fri Jun 03, 2005 8:06 pm Post subject: |
|
|
DFSORT allows PD fields to be compared to decimal numbers (n, +n or -n). So your INCLUDE statement would look like this:
Code:
INCLUDE COND=(1,5,PD,GT,+0)
For complete information on DFSORT's INCLUDE and OMIT statements, see "z/OS Application Programming Guide". Here's a link to that discussion:
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA10/3.7?DT=20050222160456 |
|
| Back to top |
|
| |
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM
|