PH22151: 'DEL IN <COL_NAME>' CMD RETURNS 'CANNOT FIND COLUMN'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If an Optim user issues the command 'DEL IN colname' while in
  an Access session and the colname value happens to also be a
  valid Optim command keyword Optim will treat it as an error
  issuing the message 'CANNOT FIND COLUMN'.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Optim users performing using Access to edit  *
  *                 a table.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: If a user is in an Access edit session  *
  *                      and issues a CHAnge or DELEte primary   *
  *                      command and the target column name is   *
  *                      a single character Optim may            *
  *                      incorrectly misinterpret it as a        *
  *                      command keyword and treat the           *
  *                      command as invalid.                     *
  ****************************************************************
  * RECOMMENDATION: Apply the fix provided.                      *
  ****************************************************************
  The parsing of the DELETE command was flawed causing the
  column name to be misinterpreted.
  

Problem conclusion

• Optim's command parser was incorrectly treating the single
  character column name within the command as a keyword if it is
  found within its command parameter keyword table.
  

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

• FOP00203 FOP00303 FOP9APIM FOPCFPMN FOPCXLIB FOPHSTM  FOPMAIN
  FOPMAMAI FOPMARCN FOPMCMAI FOPMCOLA FOPMDPRC FOPMDXTR FOPMECMN
  FOPMMCMR FOPMMJBS FOPMMUTL FOPMUXIM FOPODPP  FOPOMN   FOPRS10
  FOPRS4   FOPTPECH FOPTPEDE FOPZFMMN
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB70 PSY UI69233

     UP20/04/30 P F004

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.