DB2 FOR LUW / DB2FORLUW / 910 - DB2

DML statement in the function returns SQLCODE -204 and the 
function is marked bad, if the schema name is longer than the 8 
characters. 
 
Run following to recreate the error: 
---------------------------------------------------------------- 
set current schema = longschemaname 
@ 
set current path = longschemaname 
@ 
 
create table t1 ( 
a varchar(10) not null 
) 
@ 
 
create function f1 ( ) 
returns integer 
language sql 
begin atomic 
return ( select 1 from t1 fetch first row only ); 
end 
@ 
 
alter table t1 alter column a set data type varchar(15) 
@ 
 
-- If schema name is longer than 8 characters: 
-- SQL0727N An error occurred during implicit system action type 
"8". 
-- Information returned for the error includes SQLCODE "-204", 
SQLSTATE "42704" 
-- and message tokens "LONGSCHE.T1". LINE NUMBER=0. 
SQLSTATE=56098 
values f1( ) 
@ 
----------------------------------------------------------------

Users Affected: ALL 
 
Problem Description: 
DML statement in the function returns SQLCODE -204 and the 
 
function is marked bad, if the schema name is longer than the 8 
characters. 
 
Problem Summary: 
Run following to recreate the error: 
 
---------------------------------------------------------------- 
set current schema = longschemaname 
@ 
set current path = longschemaname 
@ 
 
create table t1 ( 
a varchar(10) not null 
) 
@ 
 
create function f1 ( ) 
returns integer 
language sql 
begin atomic 
return ( select 1 from t1 fetch first row only ); 
end 
@ 
 
alter table t1 alter column a set data type varchar(15) 
@ 
 
-- If schema name is longer than 8 characters: 
-- SQL0727N An error occurred during implicit system action type 
"8". 
-- Information returned for the error includes SQLCODE "-204", 
SQLSTATE "42704" 
-- and message tokens "LONGSCHE.T1". LINE NUMBER=0. 
SQLSTATE=56098 
values f1( ) 
@ 
----------------------------------------------------------------

Use schema name upto 8 charactes long.

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
 

Problem was first fixed in Version 9.1 Fix Pack 9

Use schema name upto 8 charactes long.

Vorgänger  : APAR is sysrouted TO one or more of the following: IC66721 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

08.12.2009
16.04.2010
16.04.2010

9.1.FP9