NC830_UPDATE_DB2.sql 2.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465
  1. --
  2. -- Licensed Materials - Property of IBM
  3. --
  4. -- BI and PM: JSM
  5. --
  6. -- (c) Copyright IBM Corp. 2003, 2010.
  7. --
  8. -- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
  9. --
  10. -------------------------------------------------------------------------------
  11. -- NC830_UPDATE_DB2.SQL *DO NOT EDIT* Data Store Version: 830
  12. -------------------------------------------------------------------------------
  13. -------------------------------------------------------------------------------
  14. --$100-- backup create begin
  15. -------------------------------------------------------------------------------
  16. -------------------------------------------------------------------------------
  17. --$110-- backup inserts begin
  18. -------------------------------------------------------------------------------
  19. -------------------------------------------------------------------------------
  20. --$130-- views drop begin
  21. -------------------------------------------------------------------------------
  22. -------------------------------------------------------------------------------
  23. --$140-- tables drop begin
  24. -------------------------------------------------------------------------------
  25. -------------------------------------------------------------------------------
  26. --$200-- recreate tables begin
  27. -------------------------------------------------------------------------------
  28. -------------------------------------------------------------------------------
  29. --$202-- primary keys add begin
  30. -------------------------------------------------------------------------------
  31. -------------------------------------------------------------------------------
  32. --$210-- views create begin
  33. -------------------------------------------------------------------------------
  34. -------------------------------------------------------------------------------
  35. --$220-- server data inserts begin
  36. -------------------------------------------------------------------------------
  37. INSERT INTO NC_DB_VERSION (DB_VERSION_ID,BUILD) VALUES(830,'build no.');
  38. -------------------------------------------------------------------------------
  39. --$230-- restore inserts begin
  40. -------------------------------------------------------------------------------
  41. -------------------------------------------------------------------------------
  42. --$250-- backup drop begin
  43. -------------------------------------------------------------------------------
  44. -------------------------------------------------------------------------------
  45. --$260-- end sql by function
  46. -------------------------------------------------------------------------------
  47. -- END NC830_UPDATE_DB2.SQL * DO NOT EDIT *
  48. -------------------------------------------------------------------------------