DB2 FOR LUW / DB2FORLUW / A50 - DB2

In this example we should return 'ab'  because row has 
varchar(2 CODEUNITS32) - 2 characters, 
but we return 'abc' : 
 
create type rtype as row ( A varchar(2 CODEUNITS32) )@ 
 
create or replace function func001_row() 
 specific func001_row 
 returns varchar(2 CODEUNITS32) 
 language sql 
 no external action 
 begin 
   declare r rtype; -- 
   set r = ( cast('abc' as char(3)) );-- 
   return r.A; -- 
 end@ 
 
values func001_row()@

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description. Apply the fix or workaround           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* See Error Description. Apply the fix or workaround           * 
****************************************************************

avoid cast: 
 
create or replace function func001() 
  specific func001 
  returns varchar(2 codeunits32) 
  language sql 
  no external action 
  begin 
    declare r rtype; -- 
    set r.A = 'abc';-- 
    return r.A; -- 
  end@ 
 
values func001()@ 
 
or avoid row data type: 
create or replace function func001() 
specific func001 
returns VARCHAR(2 CODEUNITS32) 
language sql 
no external action 
begin 
  return cast('abc' as char(3)) ;-- 
end@ 
 
values func001()@

See Error Description. Apply the fix or workaround

not known / see Local fix

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

08.08.2017
27.09.2017
12.10.2017