NC831_UPDATE_IFX.sql 2.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
  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. -- NC831_UPDATE_IFX.SQL * DO NOT EDIT * Data Store Version: 831
  12. -------------------------------------------------------------------------------
  13. -------------------------------------------------------------------------------
  14. --$130-- views drop begin
  15. -------------------------------------------------------------------------------
  16. -------------------------------------------------------------------------------
  17. --$120-- foreign keys drop begin
  18. -------------------------------------------------------------------------------
  19. -------------------------------------------------------------------------------
  20. --$135-- build/rebuild/populate tables
  21. -------------------------------------------------------------------------------
  22. -------------------------------NC_DB_VERSION-----------------------------------
  23. INSERT INTO NC_DB_VERSION (DB_VERSION_ID,BUILD) VALUES(831,'build no.');
  24. --$200-- table create begin
  25. -------------------------------------------------------------------------------
  26. --$210-- views create begin
  27. -------------------------------------------------------------------------------
  28. -------------------------------------------------------------------------------
  29. --$230-- restore inserts begin
  30. -------------------------------------------------------------------------------
  31. -------------------------------------------------------------------------------
  32. --$240-- foreign keys add begin
  33. -------------------------------------------------------------------------------
  34. -------------------------------------------------------------------------------
  35. --$260-- end sql by function
  36. -------------------------------------------------------------------------------
  37. -- END NC831_UPDATE_IFX.SQL * DO NOT EDIT *
  38. -------------------------------------------------------------------------------