Re: Show nulls on display file?

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 02/22/2017 06:33:52
AM:

----- Message from Booth Martin <booth@xxxxxxxxxxxx> on Wed, 22 Feb
2017 02:32:07 -0600 -----

To:

"RPG programming on the IBM i (AS/400 and iSeries)"

<rpg400-l@xxxxxxxxxxxx>

Subject:

Re: Show nulls on display file?

Can you define the situations that could have a null? All I can think
of is a new record? Or perhaps a numeric field for date terminated sort

of thing? In any event, it seems to me that knowing how that null field

will be used might pretty well define how you handle it?

I do like the idea of a a mark, perhaps underline a null? It still
confuses me though. How will the user key a blank/null into a numeric
field?


On 2/21/2017 3:17 PM, Bob Cagle wrote:

Is there a way to display a null value on a display file? I have

a user requesting that a 2-digit numeric field show either blanks or
zero as well as 1 - 99, emulating Excel-like behavior.

The only solution I can think of is to convert it to a character

field and validate for numeric or blank. Suggestions?

Thanks

Bob Cagle
IT Manager
Lynk

I'm not clear, but I think the OP is not really looking for genuine null
fields. It sounds like they just want to distinguish between actually
having blanks or zeroes in the field. If so, edit codes should work.

If they're really after distinguishing true null values, I like how DBU
does it. They condition the field to use column separators (and yellow)
when the value is null.

Michael Quigley
Computer Services
The Way International
www.TheWay.org