Alter Table causes SQL0901N ( SQLSTATE=58004 )

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Chris
    #1

    Alter Table causes SQL0901N ( SQLSTATE=58004 )

    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.
    Tags: None
    • Serge Rielau
      #2
      Re: Alter Table causes SQL0901N ( SQLSTATE=58004 )

      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

        Comment

        Previous template Next
        Working...