NC16_UPDATE_ORA.sql 2.8 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  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. -- NC15_UPDATE_ORA.SQL *DO NOT EDIT* Data Store Version: 16
  12. -------------------------------------------------------------------------------
  13. ---- Ver 16 is a DB2 only upgrade, need empty script here for completeness ----
  14. -------------------------------------------------------------------------------
  15. --$100-- backup create begin
  16. -------------------------------------------------------------------------------
  17. -------------------------------------------------------------------------------
  18. --$110-- backup inserts begin
  19. -------------------------------------------------------------------------------
  20. -------------------------------------------------------------------------------
  21. --$130-- views drop begin
  22. -------------------------------------------------------------------------------
  23. -------------------------------------------------------------------------------
  24. --$140-- tables drop begin
  25. -------------------------------------------------------------------------------
  26. -------------------------------------------------------------------------------
  27. --$200-- recreate tables begin
  28. -------------------------------------------------------------------------------
  29. -------------------------------------------------------------------------------
  30. --$202-- primary keys add begin
  31. -------------------------------------------------------------------------------
  32. -------------------------------------------------------------------------------
  33. --$210-- views create begin
  34. -------------------------------------------------------------------------------
  35. -------------------------------------------------------------------------------
  36. --$220-- server data inserts begin
  37. -------------------------------------------------------------------------------
  38. INSERT INTO NC_DB_VERSION (DB_VERSION_ID,BUILD) VALUES(16,'build no.');
  39. -------------------------------------------------------------------------------
  40. --$230-- restore inserts begin
  41. -------------------------------------------------------------------------------
  42. -------------------------------------------------------------------------------
  43. --$250-- backup drop begin
  44. -------------------------------------------------------------------------------
  45. -------------------------------------------------------------------------------
  46. --$260-- end sql by function
  47. -------------------------------------------------------------------------------
  48. -- END NC16_UPDATE_ORA.SQL * DO NOT EDIT *
  49. -------------------------------------------------------------------------------