Re: RPG does not recognize values list in file

[Glenn Gundermann <glenn.gundermann@xxxxxxxxx>]

Hi Jim,

"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."

Unfortunately, your understanding is not correct.
The only way to enforce this is with constraints.


Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Work: (905) 486-1162 x 239
Cell: (416) 317-3144


On 10 July 2017 at 09:40, Jim Hawkins <jhawkins@xxxxxxxxxxxx> wrote:

> Something that I have encountered a few times now at my current employment.
> I am using a utility to modify data in a file to correct a user keying
> error.  What I am running into is that the utility is finding fields that
> are not populated with valid data in a field (not the field that I need to
> fix) according to the values list associated with a particular field.
>
> Example: today I am fixing a mis-keyed date field, but the utility is
> telling me that the product type is not valid.  In this particular case, I
> know that the product type should be valid as it a recent addition to our
> product lines and one of our most popular customer choices, but in was not
> in the values list for the product type field.
>
> Data is being initially put into the file through an SQL procedure or RPG
> program.  (I am not sure in this particular case how this record was added
> as we have multiple options of how it could have been done.)   The vast
> majority of the time (95% +), the entries are created via data coming
> through a dataq and an RPG procedure continuously monitors the dataq and
> uses the data to populate this and other files. This job is under a user
> profile that has *allobj and *jobctl special authorities.
>
>  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?  Can a profile with special security setting (and if so what
> setting) be the issue?
>
> This is not the only file I have encountered this type of issue with, but
> this is the one where this is the biggest issue.
>
> V7.1  security level 40
>
>
> Regards,
>
> Jim Hawkins
> Programmer Analyst
> Interkal LLC
> Kalamazoo, MI
>
> --
> This is the RPG programming on the IBM i (AS/400 and 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD