This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes ALTER TABLE - regarding Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "ALTER TABLE - regarding" Watch "ALTER TABLE - regarding" New topic
Author

ALTER TABLE - regarding

Sub swamy
Ranch Hand

Joined: Oct 02, 2002
Posts: 121
I get the below exception during ALTER TABLE statement

SQL0109N ALTER TABLE "<>" specified attributes for column "" that are not compatible with the existing column. SQLSTATE=42837.

I tried a google and didnt get any useful information - or perhaps i was unable to interpret the information suitably. Any reason why this exception occurs during the ALTER table statement.

Datatbase: DB2 on z/OS.
Vijitha Kumara
Bartender

Joined: Mar 24, 2008
Posts: 3670

Can you please post your current table structure and your ALTER TABLE sql statement, that way people will be able to see the problem if any.
[ December 09, 2008: Message edited by: Vijitha Kumara ]

SCJP 5 | SCWCD 5
[How to ask questions] [Twitter]
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: ALTER TABLE - regarding
 
Similar Threads
question about deleting a table column
Sql query ignores variable
Regarding Foreign Key Restricts when Alter data type in sql table
problem when Columnrenamed
Struts2 problem with mapping heritance annotations