NULLs in SQR/PeopleSoft.

[Greg Rabinovich <odecca25@YAHOO.COM>]

This may not be 100% SQR relevant question, however
the fact that PeopleSoft creates tables with most of
its fields having Not Null constraints makes them very
difficult to use in SQRs for Updates/Inserts.

Does anyone know why PeopleSoft creates tables with
Not Null constraints on most of its columns?

This practice leads to very inconvenient coding in
SQR, such as checking variables for NULLs prior to
Insert/Update, and then forcing a blank into character
fields and zeros into numeric fields.  However 0 and ‘
‘ are not NULLs and sometimes no value is the only
valid value for the field.

In order to circumvent this problem, we have created a
procedure that joins DBA_CONS_COLUMNS and PSKEYDEFN to
drop constraints on non-key fields.  This has saved us
a lot of trouble and coding, especially on the tables
where we insert/update a huge number of fields, some
of which could potentially be NULL.

Has anyone approached this problem differently?


Greg Rabinovich
Altitude Consulting


__________________________________________________
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com