Portal | Manuals | 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

DFSORT Moderator

Joined: 09 Mar 2011
Posts: 7314

 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

DFSORT Moderator

Joined: 09 Mar 2011
Posts: 7314

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: 2060
Location: 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 How can we create a flat file in JAVA... jasorn Java & MQSeries 2 Wed Aug 08, 2018 3:08 pm I need to remove low values in my field shymala COBOL Programming 8 Sun Jul 29, 2018 11:15 am How to remove spaces between variable... Selvarajars DFSORT/ICETOOL 7 Fri Jul 27, 2018 3:58 pm finding anydata between positions of ... ram_vizag SYNCSORT 13 Tue Jul 17, 2018 9:14 pm KSDS file fields update by passing va... Anil Kumar Prajapati TSO/ISPF 5 Wed Jul 11, 2018 5:59 am

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