Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC65002 Status: Closed

DML STATEMENT IN THE FUNCTION RETURNS SQLCODE -204 IF THE SCHEMA NAME
IS LONGER THAN THE 8 CHARACTERS.

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
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. 
 
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( ) 
@ 
----------------------------------------------------------------
Problem Summary:
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( ) 
@ 
----------------------------------------------------------------
Local Fix:
Use schema name upto 8 charactes long.
available fix packs:
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

Solution
Problem was first fixed in Version 9.1 Fix Pack 9
Workaround
Use schema name upto 8 charactes long.
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC66721 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
08.12.2009
16.04.2010
16.04.2010
Problem solved at the following versions (IBM BugInfos)
9.1.FP9
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.9 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.