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...
 

how i can give the value of packed decimal thru jcl?

THIS IS AN ARCHIVE FORUM: CLICK HERE TO GO TO THE ORIGINAL TOPIC

 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DFSORT/ICETOOL
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  
 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DFSORT/ICETOOL
Page 1 of 1
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM