IZ42829: SQL0901N "COLUMN NUMBER OUT OF RANGE" WHEN DROPPING A COLUMN

DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as duplicate of another APAR.

Error description

• Problem recreation :
  
  a. Create table A
  b. Create table B
  C. Run RUNSTATS on the tables
  d. Create view using two tables
  e. Tried to drop some column on table A  and got:
  
  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 "column number out of range".)  SQLSTATE=58004
  

Local fix

• N/A
  

Problem summary

Problem conclusion

Temporary fix

Comments

• duplicate of IZ49403
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IZ42638

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels