Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 7306

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: 7306

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: 1756
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 Check Binary Values for symbols gandikk CA Products 3 Tue Mar 21, 2017 5:11 am
No new posts Innovations in Your Mainframe Sort Arun Raj PC Guides & IT News 4 Wed Mar 15, 2017 10:38 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts SORT requirement sjiraga COBOL Programming 6 Thu Mar 09, 2017 9:11 pm
No new posts To display values of multiple rows in... vinu78 DB2 2 Thu Mar 09, 2017 1:20 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us