DB2 FOR LUW / DB2FORLUW / 970 - DB2

Insert or update may cause wrong result when the target table
has a GENERATED ALWAYS expression that references a built-in
function with more than one string input.

example:

create table t1 (
  i int,
  c1 varchar (18),
  c2 varchar (18) GENERATED ALWAYS AS
     (sysibm.ltrim( c1, X'E6BCA2' ) ));


create or replace variable v varchar(18) for bit data;

set v = X'E6BCA2E6BCA1';

insert into t1 values (1, v, default );
insert into t1 values (2, X'E6BCA2E6BCA1', default );

select hex(c1), hex(c2 ) from t1 order by i;

1                                    2
------------------------------------
------------------------------------
E6BCA2E6BCA1                         A1
E6BCA2E6BCA1                         E6BCA1

  2 record(s) selected.

****************************************************************
* USERS AFFECTED:                                              *
* All                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description. Install release and fixpak that has   *
* this fix.                                                    *
****************************************************************
* RECOMMENDATION:                                              *
* Install release and fixpak that has this fix.                *
****************************************************************

Avoid using function with more than one string argument  in the
definition  OF GENERATED ALWAYS
column

not known / see Local fix

forerunner  : IT18170 
follow-up : 

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

01.12.2016
30.05.2017
30.05.2017