PM93812: SQL codes -104 in Browse, -181 using LOOKUP

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The following problems are being addressed by this APAR:
  1) SQL code -104 when browsing a DB2 table using SQL/Selection
  Criteria containing the 'NOT' clause.
  2) SQL code -181 during INSERT processing using a LOOKUP
  function involving a DB2 TIMESTAMP column.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Optim/z users browsing or editing DB2 tables using Access    *
  * Optim/z users performing an Insert or Update process mapping *
  * DB2 TIMESTAMP columns to TIME, DATE or other TIMESTAMP       *
  * columns using a LOOKUP expression.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Optim/z users browsing or editing DB2 tables using Access    *
  * may experience an SQL error with code -104 if selection      *
  * criteria contains the 'NOT' keyword.  Optim was converting   *
  * the literal 'NOT' to the symbol '^' in the generated SQL     *
  * causing an error.                                            *
  * Optim/z users performing an Insert or Update process mapping *
  * DB2 TIMESTAMP columns to TIME, DATE or other TIMESTAMP       *
  * columns using a LOOKUP expression may experience an SQL      *
  * error with code -181 if the Column Map in use requests       *
  * transformation of a non-TIMESTAMP column to a TIMESTAMP      *
  * column.                                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the provided fix.                                      *
  ****************************************************************
  Due to errors in program logic incorrect values were being
  employed when generating the SQL statements required to process
  the user's request.
  

Problem conclusion

• The code has been modified to generate the SQL statements
  properly and without error.
  

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:

  PM97631

Modules/Macros

• FOPZFMMN FOPMEMAI
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• R710 PSY UK96963

     UP13/08/27 P F308

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.