PH65997: EDIT - SQLCODE -798 WHEN EDITING A VIEW WITH 'GENERATED ALWAYS' COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Optim user gets SQLCODE = -798 when attempting to insert
  into a VIEW using the Edit online function when the VIEW's
  BASE column is defined as GENERATED ALWAYS AS.
  

Local fix

• Use option, Single View Mode ===> N
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Optim users performing EDIT using VIEWs.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: See Error Description.                  *
  ****************************************************************
  Incorrect program logic may cause SQL errors to be issued.
  

Problem conclusion

• Optim processing will be made sensitive to table columns defined
  as GENERATED ALWAYS AS being base table columns of a VIEW.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• FOP1OSFN FOP2RRSQ FOP9APIM FOPCFPMN FOPCXLIB FOPD2    FOPD2V41
  FOPD2V51 FOPD2V61 FOPD2V71 FOPD2V81 FOPD2V85 FOPD2V91 FOPD2VA5
  FOPD2VC5 FOPD2VNN FOPHSTM  FOPMADDE FOPMAIN  FOPMAMAI FOPMARCN
  FOPMCBMN FOPMCMAI FOPMCMMN FOPMCOLA FOPMCOLP FOPMDBMN FOPMDDDL
  FOPMDPRC FOPMDXTR FOPMECMN FOPMEMAI FOPMMCMN FOPMMCMR FOPMMJBS
  FOPMMUNU FOPMMUTL FOPMUXIM FOPOMN   FOPRS6   FOPRS7   FOPRS8
  FOPTPCSC FOPTSTBL FOPUMCBT FOPZFMMN FOPZMAIN FOPZSUB
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB70 PSY UO03028

     UP25/05/06 I 1000

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.