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