Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to specify packed decimal values in include cond in sort

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
srinivasulu.p

New User


Joined: 10 Jul 2012
Posts: 22
Location: india

PostPosted: Tue Mar 11, 2014 9:14 pm    Post subject: How to specify packed decimal values in include cond in sort
Reply with quote

Hi
i want to use packed decimal value in Include condition to copy records using sort , please help me ... i have tried with below code its not working..
Code:


MY FILE DATA IS LIKE THIS : I WANT TO COPY  THE RECORDS B AND C FIELDS HAVING 0(ZERO)

A(AS/1-2)  !   B(PS/3-8)    C(PS/9-14)
 AB          !            0              0
 AB          !      1234.0         23.0
 AB          !            0              0
 AB          !            0        1456.0

SORT FIELDS=COPY
 INCLUDE COND=(3,5,PD,EQ,0,AND,9,5,PD,ED,0)

Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Tue Mar 11, 2014 9:56 pm    Post subject: Reply to: How to specify packed decimal values in include co
Reply with quote

8 - 2 = 6
14 - 8 = 6
Back to top
View user's profile Send private message
srinivasulu.p

New User


Joined: 10 Jul 2012
Posts: 22
Location: india

PostPosted: Tue Mar 11, 2014 10:21 pm    Post subject: Re: Reply to: How to specify packed decimal values in includ
Reply with quote

Bill Woodger wrote:
8 - 2 = 6
14 - 8 = 6


Thanks for your reply, but i didnt get you... pls help me in extract those records
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Tue Mar 11, 2014 10:30 pm    Post subject: Reply to: How to specify packed decimal values in include co
Reply with quote

Code:
 INCLUDE COND=(3,6,PD,EQ,0,AND,9,6,PD,EQ,0)


If that doesn't work, show the sysout from the step.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1894
Location: UK

PostPosted: Wed Mar 12, 2014 12:08 am    Post subject: Re: Reply to: How to specify packed decimal values in includ
Reply with quote

srinivasulu.p wrote:
Bill Woodger wrote:
8 - 2 = 6
14 - 8 = 6


Thanks for your reply, but i didnt get you... pls help me in extract those records

You were getting your offsets wrong - review what you posted and relate it to what Bill posted.
Back to top
View user's profile Send private message
srinivasulu.p

New User


Joined: 10 Jul 2012
Posts: 22
Location: india

PostPosted: Wed Mar 12, 2014 9:02 am    Post subject: Re: Reply to: How to specify packed decimal values in includ
Reply with quote

Bill Woodger wrote:
Code:
 INCLUDE COND=(3,6,PD,EQ,0,AND,9,6,PD,EQ,0)


If that doesn't work, show the sysout from the step.


Quote:
Hi Bill
please find sysout, i am not getting any error , but the records are not copied

Code:
BSAM WAS USED FOR SORTIN             
BSAM WAS USED FOR SORTOUT           
RCD IN    1929166, OUT          0   
RELEASE 1.4 BATCH 0520 TPF LEVEL 1.0
Back to top
View user's profile Send private message
srinivasulu.p

New User


Joined: 10 Jul 2012
Posts: 22
Location: india

PostPosted: Wed Mar 12, 2014 9:17 am    Post subject: Re: Reply to: How to specify packed decimal values in includ
Reply with quote

srinivasulu.p wrote:
Bill Woodger wrote:
Code:
 INCLUDE COND=(3,6,PD,EQ,0,AND,9,6,PD,EQ,0)


If that doesn't work, show the sysout from the step.


Quote:
Hi Bill
please find sysout, i am not getting any error , but the records are not copied

Code:
BSAM WAS USED FOR SORTIN             
BSAM WAS USED FOR SORTOUT           
RCD IN    1929166, OUT          0   
RELEASE 1.4 BATCH 0520 TPF LEVEL 1.0



now its working , i have tried with below code
Code:

 INCLUDE COND=(3,6,PD,EQ,+0,AND,9,6,PD,EQ,+0)
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Extend the decimal values in DIVISION Balaryan DFSORT/ICETOOL 3 Thu Oct 05, 2017 4:05 pm
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts JOINKEYS Paired and Unpaired Sort MFwhiz DFSORT/ICETOOL 4 Fri Sep 29, 2017 1:48 am
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts More than 1 Include criteria for sing... Roy Ware SYNCSORT 6 Wed Sep 13, 2017 11:45 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us