Re: Question about SQL and Nulls

If your table will have fields without any known value (wich is quite
usual), go ahead and use null capable fields. That is what they are
for. Nothing will do the job better.

Your only trouble may come from "experienced" as/400 programmers that
are still in the old as/400.
_________________________________________________________________________________________
Bob Anderson wrote:

Good Afternoon,
I am working with a new table design and wonder about the wisdom of
using Null capable fields in the design.

Is it worth the trouble making fields Null capable and if so how do you
handle the fields in a Select Into or an Update operation operation.

I know I will need Null indicators and such but I wondering if it is
worth it.

Thanks

Bob Anderson
IT Guy
Kent Sporting Goods
433 Park Ave. S
New London OH 44851
419-929-7021 x315
email: banderson@xxxxxxxxxxxxxxxxxxx

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.