DB2 FOR LUW / DB2FORLUW / 970 - DB2

An anchored data type defines a data type based on another SQL 
object such as a column, global variable, SQL variable, SQL 
parameter, or the row of a table or view.  Unexpected errors 
including SQL0901N can occur when using anchored data types to 
anchor to the row of a table with implicitly hidden columns. 
 
Here is an example of the type of error that can occur when 
using these data types: 
 
create table tt1(c0 timestamp not null implicitly hidden 
generated always for each row on update as row change timestamp, 
c1 int, c2 varchar(10), c3 decimal(5,2)) 
DB20000I  The SQL command completed successfully. 
 
create type r1 as row anchor row tt1 
DB20000I  The SQL command completed successfully. 
 
create type a1 as r1 array[] 
DB20000I  The SQL command completed successfully. 
 
create variable gv1 a1 
DB20000I  The SQL command completed successfully. 
 
set gv1[1] = null 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason "Invalid 
collation ID".) 
SQLSTATE=58004

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to product version 9.7 fix pack 8.  Row data types   * 
* anchored to a table with implicitly hidden columns that were * 
* created on an earlier release will need to be dropped and    * 
* recreated.                                                   * 
****************************************************************

DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in version 9.7 fix pack 8

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

02.10.2012
01.04.2013
01.04.2013

9.7.FP8