4211 - Alter SKN_TOP_TEN inside IB_BANCNET_LIST from VARCHAR to DECIMAL.txt

Rayvandy Gabbytian , April 16, 2014 19:19

Download (392 Bytes)

 
1 
ALTER TABLE DBO.IB_BANCNET_LIST DROP COLUMN SKN_TOP_TEN RESTRICT;
2 
CALL SYSPROC.ADMIN_CMD( 'REORG TABLE DBO.IB_BANCNET_LIST' );
3 
CALL SYSPROC.ADMIN_CMD( 'RUNSTATS ON TABLE DBO.IB_BANCNET_LIST' );
4 

    		
  

  

    
      5
    
    
      
ALTER TABLE DBO.IB_BANCNET_LIST ADD COLUMN SKN_TOP_TEN DECIMAL(3,0);


    		
  

  

    
      6
    
    
      
CALL SYSPROC.ADMIN_CMD( 'REORG TABLE DBO.IB_BANCNET_LIST' );


    		
  

  

    
      7
    
    
      
CALL SYSPROC.ADMIN_CMD( 'RUNSTATS ON TABLE DBO.IB_BANCNET_LIST' );