This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).
Shape the future of IBM!
We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:
Search existing ideas
Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,
Post your ideas
Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Specific links you will want to bookmark for future use
Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.
IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.
ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.
IBM Employees should enter Ideas at https://ideas.ibm.com
See this idea on ideas.ibm.com
Use Case:
A table is created with the following column definition: TECHTIMESTAMP GENERATED ALWAYS FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP
The clients use the table (already contains data records), so that values have already been generated for the column, e.g. when inserting or changing the data records. Due to a special regulatory requirement, the data in other columns is to be changed without changing the value of the TECHTIMESTAMP column.
Theoretical solution:
ALTER TABLE TEST ALTER COLUMN TECHTIMESTAMP DROP GENERATED;
UPDATE the data in other columns
ALTER TABLE TEST ALTER COLUMN TECHTIMESTAMP SET GENERATED ALWAYS FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP;
Although it is possible to DROP the GENERATED CLAUSE, currently it is not possible to add it again using ALTER TABLE. The required GENERATED CLAUSE is only possible when creating a new column.
The idea is to enable this column alteration.
Needed By | Not sure -- Just thought it was cool |
By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.
The use case occurs when users must fulfil special regulatory requirements or make special modifications to the data.
Although the workaround is a sound one, there is still room for improvement.
The original table cannot be used during the copying process, as this would result in data being changed. The workaround is very time-consuming (several hours or one business day downtime) for tables with many millions of data records. Mistakes can easily happen.
The feature intends to avoid loading and reloading the data and thus to enable the request to be implemented much more quickly.
Just as it is possible to deactivate and reactivate history-tables, it should also be possible to deactivate and reactivate a GENERATED clause for a column if required. This is already possible with IDENTITY-COLUMNS.
However, this is not yet possible for timestamps with GENERATED ALWAYS FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP.
Therefore this feature request
Hello Daniel -
Thank you for submitting your request. We are reviewing this and need more information. The workaround you outlined is a sound one. Please provide details of the usecase and/or business impact of not having this request.
Thank you.