|
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
|
 |
