A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
ALTER TABLE - regarding
Joined: Oct 02, 2002
Dec 09, 2008 01:34:00
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.
Joined: Mar 24, 2008
Dec 09, 2008 02:29:00
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
It is sorta covered in the
JavaRanch Style Guide
subject: ALTER TABLE - regarding
Regarding Foreign Key Restricts when Alter data type in sql table
Sql query ignores variable
Struts2 problem with mapping heritance annotations
problem when Columnrenamed
question about deleting a table column
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014