Portal | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref

Author Message
srinivasulu.p

New User

Joined: 10 Jul 2012
Posts: 22
Location: india

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

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)

Bill Woodger

Moderator Emeritus

Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

 Posted: Tue Mar 11, 2014 9:56 pm    Post subject: Reply to: How to specify packed decimal values in include co 8 - 2 = 6 14 - 8 = 6
srinivasulu.p

New User

Joined: 10 Jul 2012
Posts: 22
Location: india

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

 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
Bill Woodger

Moderator Emeritus

Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

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

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

Global Moderator

Joined: 10 May 2007
Posts: 2407
Location: Hampshire, UK

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

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

New User

Joined: 10 Jul 2012
Posts: 22
Location: india

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

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

New User

Joined: 10 Jul 2012
Posts: 22
Location: india

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

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)
 All times are GMT + 6 Hours
 Page 1 of 1

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics Parsing more than 1000 columns in a s... ssuthagar SYNCSORT 10 Tue Sep 22, 2020 12:23 am SORT the records based on the second ... Ramsee SYNCSORT 1 Wed Aug 19, 2020 3:01 pm Required Date Format in Include Sort ... vivky_vivek DFSORT/ICETOOL 6 Fri Aug 14, 2020 6:52 am To convert numeric to Packed Decimal vinu78 DFSORT/ICETOOL 9 Fri Jul 31, 2020 7:14 pm a copybook getting improper values in... Mahammad Musthafa COBOL Programming 7 Sat Jul 18, 2020 12:58 am

 © 2003-2020 IBM MAINFRAME Software Support Division
 Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us