SEO

#1 (**permalink**) 05-07-2008, 10:15 AM

Hi,

I am trying to run the following SQL through the DB2 command line for
version 9.1.0:

alter table SCHEMA.TABLE1
drop column A;

alter table SCHEMA.TABLE2
alter column B set data type decimal(15,4);

* Column B was Integer.

The commands both successfully return:
DB20000I The SQL command completed successfully.

However, when I try and run a seemingly un-related query (i.e. The
query does not directly reference either TABLE1 or TABLE2 although
they do both have foreign key relationships with the query) I get the
following error:

ERROR [58004] [IBM][DB2/NT] SQL0901N The SQL statement failed because
of a non-severe system error. Subsequent SQL statements can be
processed. (Reason "column number out of range".) SQLSTATE=58004

I have tried reorg on all the tables in both the above SQL and my
query.
Any help would be much appreciated.

#2 (**permalink**) 05-10-2008, 02:02 PM

Chris wrote:
> Hi,
>
> I am trying to run the following SQL through the DB2 command line for
> version 9.1.0:
>
> alter table SCHEMA.TABLE1
> drop column A;
>
> alter table SCHEMA.TABLE2
> alter column B set data type decimal(15,4);
>
> * Column B was Integer.
>
> The commands both successfully return:
> DB20000I The SQL command completed successfully.
>
> However, when I try and run a seemingly un-related query (i.e. The
> query does not directly reference either TABLE1 or TABLE2 although
> they do both have foreign key relationships with the query) I get the
> following error:
>
> ERROR [58004] [IBM][DB2/NT] SQL0901N The SQL statement failed because
> of a non-severe system error. Subsequent SQL statements can be
> processed. (Reason "column number out of range".) SQLSTATE=58004
>
> I have tried reorg on all the tables in both the above SQL and my
> query.
> Any help would be much appreciated.
As always with -901s please call support. I recall issues with "column
number out of range" after ALTERs. So there is a reasonable chance that
support will point you to an existing APAR.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Alter Table causes SQL0901N ( SQLSTATE=58004 )