Implementer needs to have the ability to promote SQL TABLE changes with out ALTER TABLE command in Implementer
We have a SQL TABLE file where we are changing a DATE type field to TIMESTAMP type field this is not supported by IBM with the ALTER TABLE command.
The only solution today is to delete (DROP) the SQL TABLE and all SQLVIEWS before compiling the request. This means that you cannot stage your move requests for a nightly process but require your staff to work after hours to create and compile move requests.
We should have the option to create and compile the request without having to remove the table file first which requires us to shut down our system to prevent users from getting on the system for a simple table change.
What it should work is like the issue where we have DDS for a file and converting ALPHA type to a NUMERIC type. We are able to compile the request and manually handle the conversion of the data. Per Article https://www.ptc.com/appserver/cs/view/solution.jsp?n=CS119458
Currently IBM only supports this type changes.IBM Knowledge Center
