JR27613: columns not listed in the FOR UPDATE OF clause should not be marked updatable in the extended describe

DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• select * from test for update works
  
  select * from test for update of field3
  ...returns an error
  
  *-->  <KO> Method: doSQLQuery > Exception occured: DB2 SQL
  error:
   SQLCODE: -503, SQLSTATE: 42912, SQLERRMC:
  

Local fix

• Do not use of field3
  

Problem summary

• columns not listed in the FOR UPDATE OF clause should not
  marked updatable in the extended describe
  
  ERROR DESCRIPTION:
  select * from test for update works
  
  select * from test for update of field3
  ...returns an error
  
  *-->  <KO> Method: doSQLQuery > Exception occured: DB2 SQL
  error:
   SQLCODE: -503, SQLSTATE: 42912, SQLERRMC:
  
  User Affected: DB2 V8, DB2 V9, DB2 V95
  

Problem conclusion

• First fixed in DB2 UDB Version V9 FP5
  

Temporary fix

Comments

APAR Information

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

  JR27562

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

  JR27799

Fix information

• Fixed component name

  DB2 UDB ESE WIN

• Fixed component ID

  5765F4101

Applicable component levels

• R820 PSY

     UP

• R910 PSY

     UP

• R950 PSY

     UP