| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC62394 | Status: Closed |
ERROR SQL0901 OR ABNORMAL TERMINATION WHEN ASSIGNING VALUE TO ARRAY ELEMENT OF DBCLOB TYPE | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
| Problem description: | |
A SET statement that assigns a value to an array element of
type DBCLOB may report error SQL0901 at run time, or cause
your database instance to terminate abnormally. In the event
of a -901 error, the reason string "bad element size" may be
given.
For example:
create type arrtype as dbclob(5) array[]
DB20000I The SQL command completed successfully.
create variable GV arrtype
DB20000I The SQL command completed successfully.
set GV[1] = 'abc'
DB21034E The command was processed as an SQL statement because
it was not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0901N The SQL statement failed because of a non-severe
system error.
Subsequent SQL statements can be processed. (Reason "bad
element size".)
SQLSTATE=58004
create procedure proc(OUT a dbclob(5))
begin
declare arrv arrtype;
set arrv[1] = dbclob('abc');
set a = arrv[1];
end
DB20000I The SQL command completed successfully.
call proc(?)
SQL0901N The SQL statement failed because of a non-severe
system error.
Subsequent SQL statements can be processed. (Reason "bad
element size".)
SQLSTATE=58004 | |
| Problem Summary: | |
****************************************************************
* USERS AFFECTED: *
* NONE *
****************************************************************
* PROBLEM DESCRIPTION: *
* A SET statement that assigns a value to an array element of *
* *
* type DBCLOB may report error SQL0901 at run time, or cause *
* *
* your database instance to terminate abnormally. In the *
* event *
* of a -901 error, the reason string "bad element size" may be *
* *
* given. *
* *
* *
* *
* For example: *
* *
* *
* *
* create type arrtype as dbclob(5) array[] *
* *
* DB20000I The SQL command completed successfully. *
* *
* *
* *
* create variable GV arrtype *
* *
* DB20000I The SQL command completed successfully. *
* *
* *
* *
* set GV[1] = 'abc' *
* *
* DB21034E The command was processed as an SQL statement *
* because *
* it was not a *
* *
* valid Command Line Processor command. During SQL processing *
* it *
* returned: *
* *
* SQL0901N The SQL statement failed because of a non-severe *
* *
* system error. *
* *
* Subsequent SQL statements can be processed. (Reason "bad *
* *
* element size".) *
* *
* SQLSTATE=58004 *
* *
* *
* *
* create procedure proc(OUT a dbclob(5)) *
* *
* begin *
* *
* declare arrv arrtype; *
* *
* set arrv[1] = dbclob('abc'); *
* *
* set a = arrv[1]; *
* *
* end *
* *
* DB20000I The SQL command completed successfully. *
* *
* *
* *
* call proc(?) *
* *
* SQL0901N The SQL statement failed because of a non-severe *
* *
* system error. *
* *
* Subsequent SQL statements can be processed. (Reason "bad *
* *
* element size".) *
* *
* SQLSTATE=58004 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.5, Fix Pack 5. *
**************************************************************** | |
| Local Fix: | |
| available fix packs: | |
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows | |
| Solution | |
Fix delivered in DB2 Version 9.5, Fix Pack 5. | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 05.08.2009 17.02.2010 17.02.2010 |
| Problem solved at the following versions (IBM BugInfos) | |
9.5.FP5 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.5.0.5 |
|