A new topic, 'How do I change a column from NOT NULL to NULL in DB2?', has been
made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=602.new#new
The text of the topic is shown below:
Hi,
When I use Liquibase to try to remove the NOT NULL constraint of a column I'm
getting the following error:
Code:
Migration failed for change set
/var/tmp/2817394908676666105-diff.xml::1279899379588-1::root (generated):
Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER
TABLE TEST_SCHEMA.NOT_NULL_TBL ALTER COLUMN BIGINT_ DROP NOT NULL:
Caused By: Error executing SQL ALTER TABLE TEST_SCHEMA.NOT_NULL_TBL
ALTER COLUMN BIGINT_ DROP NOT NULL:
Caused By: DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC:
NOT NULL;COLUMN BIGINT_ DROP;<space>
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601,
SQLERRMC: NOT NULL;COLUMN BIGINT_ DROP;<space>
If I manually try to run "ALTER TABLE TEST_SCHEMA.NOT_NULL_TBL ALTER COLUMN
BIGINT_ DROP NOT NULL" on my DB2 database I also get the error. Does anyone
know what the right command is to make my 'BIGINT_' column nullable?
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The Liquibase Community Forum Team.------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
