Home Explore Help
Register Sign In
GlobalCube
/
analytics
3
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
analytics
/
configuration
/
schemas
/
delivery
/
db2
/
NC6_UPDATE_DB2.sql

NC6_UPDATE_DB2.sql 2.1 KB
Permalink History Raw

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556 
  1. 

  2. 

  3. --
    4. 

  4. --    Licensed Materials - Property of IBM
    5. 

  5. --    
    6. 

  6. --    BI and PM: JSM
    7. 

  7. --    
    8. 

  8. --    (c) Copyright IBM Corp. 2003, 2010.
    9. 

  9. --    
    10. 

  10. --    US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
    11. 

  11. --    
    12. 

  12. 

  13. 

  14. -------------------------------------------------------------------------------
    15. 

  15. --	NC6_UPDATE_ORA.SQL			*	DO NOT EDIT	 *			Data Store Version: 6 		 
    16. 

  16. -------------------------------------------------------------------------------
    17. 

  17. -------------------------------------------------------------------------------
    18. 

  18. --$140-- tables drop begin
    19. 

  19. -------------------------------------------------------------------------------
    20. 

  20. DROP TABLE NC_SCHEDULE_QUEUE
    21. 

  21. ;
    22. 

  22. 

  23. -------------------------------------------------------------------------------
    24. 

  24. --$200-- recreate tables begin
    25. 

  25. -------------------------------------------------------------------------------
    26. 

  26. CREATE TABLE NC_SCHEDULE_QUEUE(
    27. 

  27.    	SCHEDULE_ID CHAR(32) NOT NULL,
    28. 

  28. 	RUN_DATE NUMBER
    29. 

  29. )
    30. 

  30. ;
    31. 

  31. 

  32. -------------------------------------------------------------------------------
    33. 

  33. --$201-- indices create begin
    34. 

  34. -------------------------------------------------------------------------------
    35. 

  35. CREATE INDEX I1N_SCHEDULE_QUEUE ON NC_SCHEDULE_QUEUE (
    36. 

  36.    SCHEDULE_ID)
    37. 

  37. ;
    38. 

  38. 

  39. -------------------------------------------------------------------------------
    40. 

  40. --$202-- primary keys add begin
    41. 

  41. -------------------------------------------------------------------------------
    42. 

  42. ALTER TABLE NC_SCHEDULE_QUEUE
    43. 

  43.    ADD CONSTRAINT PN_SCHEDULE_QUEUEI PRIMARY KEY (SCHEDULE_ID)
    44. 

  44. ;
    45. 

  45. 

  46. -------------------------------------------------------------------------------
    47. 

  47. --$220-- server data inserts begin
    48. 

  48. -------------------------------------------------------------------------------
    49. 

  49. INSERT INTO NC_DB_VERSION (DB_VERSION_ID,BUILD) VALUES (6,'build no.')
    50. 

  50. ;
    51. 

  51. 

  52. -------------------------------------------------------------------------------
    53. 

  53. --$260-- end sql by function
    54. 

  54. -------------------------------------------------------------------------------
    55. 

  55. --	END NC6_UPDATE_ORA.SQL			*	DO NOT EDIT	 * 		 
    56. 

  56. -------------------------------------------------------------------------------
    57.