If the UPDATE command uses a derived field on the SET parameter, the view needs to be DATABASE(*SEQUEL), since you cannot refer to a derived field using *LOCALSYS

The full error is:

Message ID . . . . . . : SQL0206 Severity . . . . . . . : 30Message type . . . . . : Diagnostic
Message . . . . : Column or global variable fieldname not found.
Cause . . . . . : fieldname was not found as a column of table *N in *N and was not found as a global variable in *N. If the table is *N, fieldname is not a column of any table or view that can be referenced.
Recovery . . . : Do one of the following and try the request again: -- Ensure that the column and table names are specified correctly in the
statement.

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: March 25, 2019