Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > IBM DB2 > Alter Table cau...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 8861 of 9055
Post > Topic >>

Alter Table causes SQL0901N ( SQLSTATE=58004 )

by Chris <christopher.mark.jones@[EMAIL PROTECTED] > May 6, 2008 at 06:49 PM

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 relation****ps 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 Posts in Topic:
Alter Table causes SQL0901N ( SQLSTATE=58004 )
Chris <christopher.mar  2008-05-06 18:49:11 
Re: Alter Table causes SQL0901N ( SQLSTATE=58004 )
Serge Rielau <srielau@  2008-05-07 06:45:30 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 6 16:05:15 CDT 2008.