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
 

 

Omit condition for zeros

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
abraralum

New User


Joined: 19 Dec 2010
Posts: 42
Location: Bangalore

PostPosted: Mon Nov 26, 2012 6:31 pm    Post subject: Omit condition for zeros
Reply with quote

Hi,

I am trying to remove records if the packed decimal field contains a zero.

Below is my sort card
Code:

SORT FIELDS=COPY       
OMIT COND=(01,8,PD,EQ,0,09,8,PD,EQ,0)


However not sure if it works for Debit Indicator. Any pointers will be helpful.
Back to top
View user's profile Send private message

abraralum

New User


Joined: 19 Dec 2010
Posts: 42
Location: Bangalore

PostPosted: Mon Nov 26, 2012 6:38 pm    Post subject:
Reply with quote

I have referred below link :
http://ibmmainframes.com/viewtopic.php?t=52194&highlight=packed+decimal

However, it does not work for Debit Indicator.
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Mon Nov 26, 2012 6:38 pm    Post subject:
Reply with quote

What happen when you tried this??
Back to top
View user's profile Send private message
abraralum

New User


Joined: 19 Dec 2010
Posts: 42
Location: Bangalore

PostPosted: Mon Nov 26, 2012 6:40 pm    Post subject:
Reply with quote

The sort card not considering the Debit Indicator 'D'
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7236

PostPosted: Mon Nov 26, 2012 6:50 pm    Post subject: Reply to: Omit condition for zeros
Reply with quote

Do you mean by "debit indicator" the D which is the value in the sign nybble for a negative number? Are you saying you have "negative zeros" which are not being identified? Or what?

EDIT: You OMIT card is not syntactically correct.
Back to top
View user's profile Send private message
abraralum

New User


Joined: 19 Dec 2010
Posts: 42
Location: Bangalore

PostPosted: Mon Nov 26, 2012 6:54 pm    Post subject:
Reply with quote

Hi Bill,

Yes, it is 'D" which is the sign for a negative number.

Actually, I have data like this- X'000000000000000C'.
I would need to identify if the filed contain X'000000000000000D' also.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7236

PostPosted: Mon Nov 26, 2012 8:23 pm    Post subject: Reply to: Omit condition for zeros
Reply with quote

Try with
Code:
OPTION NOSZERO
Back to top
View user's profile Send private message
abraralum

New User


Joined: 19 Dec 2010
Posts: 42
Location: Bangalore

PostPosted: Wed Nov 28, 2012 6:12 pm    Post subject:
Reply with quote

Thanks Bill, it worked!
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7236

PostPosted: Wed Nov 28, 2012 6:27 pm    Post subject: Reply to: Omit condition for zeros
Reply with quote

Thanks for letting us know. It is available as an installation option, so you should get it discussed so that someone can decide whether to make it the permanent default, or leave it as it is with all personnel aware of it.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
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 INCLUDE condition questions van bui DFSORT/ICETOOL 1 Thu Jun 30, 2016 9:52 am
No new posts 2 vsam file compare and update a fiel... ABINAYATHULASI DFSORT/ICETOOL 6 Sun May 29, 2016 11:15 am
No new posts Join key - Populate Zeros when Unpair... rexx77 DFSORT/ICETOOL 6 Thu May 12, 2016 12:22 am
No new posts Join and Omit records- Master File no... shajeeth DFSORT/ICETOOL 5 Tue Jan 26, 2016 8:16 pm


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