Re: RPG does not recognize values list in file

Jim said:

It has always been my understanding that by have a values list, SQL and RPG
would NOT allow other values to be entered for that field. Is my
understanding of this incorrect, or is there something else that I need to
look for?

-----------------------------------------------

If you are referring to the DDS VALUES keyword, your understanding is unfortunately incorrect. The DDS field-level validity checking keywords, (CMP, COMP, VALUES, RANGE, etc.) only apply if the field concerned is referenced in a Display File. Nothing to do with RPG or SQL; the checking is done at the workstation level.

The confusion arises because these keywords <can> be coded in Physical/Logical files - but only for reference on Display Files. (Some may also be used to form select/omit criteria.)

The best way to enforce such database rules universally is through Check Constraints, (e.g. ADDPFCST).

Brian.