Support #8720

SCP ID :##4662##] : Change Length Column ACCOUNT_HOLDER_NAME

Added by Zahir Abd Latif about 6 years ago. Updated about 6 years ago.

Status:Closed - End of life cycleStart date:July 26, 2018
Priority:NormalDue 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.

Screen Shot 2018-07-26 at 13.50.48.png (226 KB) Zahir Abd Latif, July 26, 2018 15:16

History

#1 Avatar?id=2607&size=24 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 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian about 6 years ago

  • % Done changed from 0 to 100

#3 Avatar?id=2607&size=24 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.

Also available in: Atom PDF