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

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

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: 1715
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 Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts Overlaying one set of charater values... Kevin Lindsley SYNCSORT 7 Sat Nov 05, 2016 3:21 am
This topic is locked: you cannot edit posts or make replies. How to pass the previous month date i... Suganya87 DFSORT/ICETOOL 5 Mon Oct 31, 2016 4:13 pm
No new posts Comparing Decimal and CHAR columns rakesh17684 DB2 7 Thu Oct 20, 2016 2:33 am


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