Support #8720
SCP ID :##4662##] : Change Length Column ACCOUNT_HOLDER_NAME
Status: | Closed - End of life cycle | Start date: | July 26, 2018 | |
---|---|---|---|---|
Priority: | Normal | Due date: | August 03, 2018 | |
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | - | Spent time: | - | |
Target version: | - |
Description
Hi Gabby,
Kindly attend below request.
we need help to change length column ACCOUNT_HOLDER_NAME(60) at table IB_CUST_ACCOUNTS.
because there a name of product have a length greater than 60, we want change from 60 to 100.
History
#1 Updated by Rayvandy Gabbytian about 6 years ago
- Due date set to August 03, 2018
- Status changed from New - Begin Life Cycle to Development / Work In Progress
Already replied to Ivan on 3rd August 2018 11:09
Dear Ivan, Kindly execute this query in development first and apply to production: ALTER TABLE DBO.IB_CUST_ACCOUNTS ALTER COLUMN ACCOUNT_HOLDER_NAME SET DATA TYPE VARCHAR(100); CALL SYSPROC.ADMIN_CMD( 'REORG TABLE DBO.IB_CUST_ACCOUNTS' ); CALL SYSPROC.ADMIN_CMD( 'RUNSTATS ON TABLE DBO.IB_CUST_ACCOUNTS' ); Thank you.
#2 Updated by Rayvandy Gabbytian about 6 years ago
- % Done changed from 0 to 100
#3 Updated by Rayvandy Gabbytian about 6 years ago
- Status changed from Development / Work In Progress to Pending Customer Feedback
- Assignee changed from Rayvandy Gabbytian to Zahir Abd Latif
- % Done changed from 100 to 0
Dear Zahir,
This fixes will go into production by around 9th August 2018.
Thanks.
#4 Updated by Zahir Abd Latif about 6 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
- % Done changed from 0 to 100
Issue closed in SCP.