Omit condition for zeros

abraralum · New User Joined: 19 Dec 2010 Posts: 42 Location: Bangalore

Hi,

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

Below is my sort card

abraralum · New User Joined: 19 Dec 2010 Posts: 42 Location: Bangalore

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

However, it does not work for Debit Indicator.

Pandora-Box · Posted: Mon Nov 26, 2012 6:38 pm

What happen when you tried this??

abraralum · New User Joined: 19 Dec 2010 Posts: 42 Location: Bangalore

The sort card not considering the Debit Indicator 'D'

Bill Woodger · Posted: Mon Nov 26, 2012 6:50 pm

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.

abraralum · New User Joined: 19 Dec 2010 Posts: 42 Location: Bangalore

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.

Bill Woodger · Posted: Mon Nov 26, 2012 8:23 pm

Try with

abraralum · New User Joined: 19 Dec 2010 Posts: 42 Location: Bangalore

Thanks Bill, it worked!

Bill Woodger · Posted: Wed Nov 28, 2012 6:27 pm

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.