Question & Answer
Question
How to remove extended database columns in IBM order management on cloud ?
Answer
1. Remove the mentioned extended database column related extension details from extension.xml
2. Recreate entity jar using deployer.cmd utility.
3. After step 2, product will create the DDL to drop the non required columns.
4. Note that the IBM Order Management system will not remove any tables/columns on its own. However, it generates corresponding SQLs which can be reviewed and applied manually. Lookout for *.lst files after dbverify utility is run.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS6PEW","label":"Sterling Order Management"},"Component":"","Platform":[{"code":"PF002","label":"AIX"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
01 November 2021
UID
ibm10795440