File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
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
I agree. Here's the link:
subject: ALTER TABLE - regarding
question about deleting a table column
Regarding Foreign Key Restricts when Alter data type in sql table
Sql query ignores variable
Struts2 problem with mapping heritance annotations
problem when Columnrenamed
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015