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
question about deleting a table column
problem when Columnrenamed
Sql query ignores variable
Struts2 problem with mapping heritance annotations
Regarding Foreign Key Restricts when Alter data type in sql table
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014