There is currently no option to be able to specify a list of accepted values for a column on a table through the Alter panels.
|Who would benefit from this IDEA?||DB2 Administration Tool Users|
How should it work?
ALT on a table.
Provide an option which can be specified on indvidual columns that will take you to a panel where a list of accepted values can be specified for the column.
Generate proper WSL to alter/drop/recreate objects as appropriate.
|Priority Justification||PFG is in the process of migrating from BMC Admin tools to IBM. We often need to be able to provide a list of acceptable values for individual columns on our tables.|
|Customer Name||Principal Financial Group|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "firstname.lastname@example.org" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions