JR32965: MS OLEDB PLUGIN - GENERATED SQL INCORRECT

APAR status

• Closed as fixed if next.

Error description

• MS OLEDB plugin - Generated SQL incorrect
  
  The statement generated includes values marked as "Keys" in
  the UPDATE clause of the statement as well as in the WHERE
  clause.  For example, given an MS OLEDB stage with columns
  TaskID (Key=Yes),
  EndTime (Key=No), Status (Key=No), and Description (Key=No).
  The generated SQL is:
  UPDATE TaskLog SET TaskID=?,EndTime=?,Status=?,Description=?
  WHERE
  TaskID=?;  This fails because (as is often the case in SQL
  Server), the TaskID is
  an identity column and cannot be updated.  The generated SQL
  should NOT
  include the Key columns in the UPDATE clause.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  user who uses msoledb stage with update action and generated
  sqlwith IS81
  ****************************************************************
  PROBLEM DESCRIPTION:
  when there's a key field in the column, that key field should
  not be included in the update action with generated sql
  ****************************************************************
  RECOMMENDATION:
  install patch for JR32965
  This change is included in 8.1 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

• fixed in 8.1 Fix Pack 1.
  

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

• MSOLEDB
  

Fix information

Applicable component levels

• R801 PSN

     UP