Re: Show nulls on display file?

... interesting discussion about JSON and Javascript, a little bit off topic in a RPG list, but anyway.
- if your application isn't interested in null values, this could be easily solved in the view layer (SQL function coalesce will do it for you)
=> most parts of your application won't see any null values and won't have any problems with this.
- as I posted before null values are very important for referential constraints, lets have an example:
an order has to have a customer, to insure this a referential constraint should ensure this.
your business is wholesale - but sometimes you are making retail and those one-time customers, don't have a customer record, if the customerId field of the ordertable is null capable, you leave it null and this would not disturb the referential constraint.
In your application you could this again handle as blank, using the view, exchanging the null value with blank, if someone would try to pull the customer record, the application will get a null for the record, shouldn't be a problem for JSON (or JSON would be the problem!!!)
The one and only place in the application to deal with this, would be the order entry part, this part has to be smart enough to put in a null value to orders.customerId, if no customer information was filled in.

D*B