home *** CD-ROM | disk | FTP | other *** search
/ OS/2 Shareware BBS: 8 Other / 08-Other.zip / 10ageout.zip / DFIDBUPD.BND (.txt) < prev    next >
DB2 Bind  |  1993-08-19  |  20KB  |  117 lines
  1. DFIDBUPDDAZEKTIJUSERID  0
  2. BEGIN DECLARE SECTION
  3. END DECLARE SECTION
  4. UPDATE LANM.CONFIGURATION                    SET ACTIVE_FLAG = :hfch1,                        SEQUENCE_NO = :hs1,                        AUTHORIZATION_FLAG = :hfch2,                        ACTIVE_TIME = :hl1                    WHERE SEGMENT_NO = :hach3_1 AND                          ADAPT_ADDR  = :hach12_1                     AND (ACTIVE_FLAG = '1' OR                          PREV_ACTIVE_FLAG = '1')
  5. INSERT INTO LANM.CONFIGURATION                ( ADAPT_ADDR, UNIVERSAL_ADDR, SEGMENT_NO, SEQUENCE_NO,                  FUNCTIONAL_ADDR, GROUP_ADDR,                  ACTIVE_FLAG, PREV_ACTIVE_FLAG,                  AUTHORIZATION_FLAG, ACTIVE_TIMESTAMP, ACTIVE_TIME,                  CAU_FLAG, CAU_ATTACHED_FLAG, RESERVED)                VALUES                ( :hach12_1, :hach12_2, :hach3_1, :hs1,                  :hl3, :hach8_1,                  :hfch1, :hfch5,                  :hfch2, CURRENT TIMESTAMP, :hl1,                  :hfch3, :hfch4, :hl2)
  6. UPDATE LANM.CONFIGURATION                    SET AUTHORIZATION_FLAG = :hfch1                    WHERE SEGMENT_NO = :hach3_1 AND                          ADAPT_ADDR  = :hach12_1
  7. UPDATE LANM.CONFIGURATION                    SET AUTHORIZATION_FLAG = :hfch1                    WHERE AUTHORIZATION_FLAG <> :hfch1
  8. UPDATE LANM.CAU                    SET ROOM_NUMBER = :hach8_2                    WHERE CAU_ID = :hach8_1
  9. UPDATE LANM.CAU                    SET REGISTRATION_FLAG = :hfch1,                        CAU_STATUS = :hs1,                                                    RESPONSE_FLAG = :hfch2
  10. UPDATE LANM.CAU                    SET REGISTRATION_FLAG = :hfch2, PREV_ACTIVE_FLAG = :hfch1,                        RESPONSE_FLAG = :hfch3                    WHERE CAU_ID = :hach8_1
  11. UPDATE LANM.CAU                    SET EXPECTED_RESPONSES = :hs1                    WHERE CAU_ID = :hach8_1
  12. UPDATE LANM.LOCATION_DEF                    SET FOUND_FLAG = :hfch1                    WHERE ADAPT_ADDR = :hach12_1
  13. UPDATE LANM.LOCATION_DEF                    SET FOUND_FLAG = :hfch1                    WHERE CAU_ID = :hach8_1
  14. UPDATE LANM.EVENT_LOG                    SET HOST_FLAG = :hfch1                    WHERE RESERVED = :hl1
  15. UPDATE LANM.LOCATION_DEF                  SET CAU_ATTACH_MODULE = :hch1,                      CAU_LOBE = :hs1,                      CAU_REPORT_FLAG = :hfch1,                      CAU_ID = :hach8_1                  WHERE ADAPT_ADDR = :hach12_1
  16. UPDATE LANM.CONFIGURATION                    SET SEGMENT_NO = :hach3_2                    WHERE SEGMENT_NO = :hach3_1
  17. COMMIT
  18. UPDATE LANM.CAU                    SET SEGMENT_NO = :hach3_2                    WHERE SEGMENT_NO = :hach3_1
  19. UPDATE LANM.STATION_DEFINITION                    SET ADAPT_NAME = :hach16_2                    WHERE ADAPT_NAME = :hach16_1
  20. UPDATE LANM.STATION_DEFINITION                    SET TRACE_FLAG = :hfch1                    WHERE ADAPT_ADDR = :hach12_1
  21. UPDATE LANM.CONFIGURATION                    SET PREV_ACTIVE_FLAG = :hfch1,                                              ACTIVE_FLAG   = :hfch1                    WHERE SEGMENT_NO = :hach3_1 AND                          PREV_ACTIVE_FLAG = :hfch2
  22. UPDATE LANM.CONFIGURATION                    SET ACTIVE_FLAG = :hfch1,                        ACTIVE_TIME = :hl1                    WHERE SEGMENT_NO = :hach3_1 AND                          SEQUENCE_NO < :hs1 AND SEQUENCE_NO > :hs2                     AND (ACTIVE_FLAG = '1' OR                          PREV_ACTIVE_FLAG = '1')
  23. UPDATE LANM.CONFIGURATION                    SET ACTIVE_FLAG = :hfch1,                        ACTIVE_TIME = :hl1                    WHERE SEGMENT_NO = :hach3_1 AND                          SEQUENCE_NO > :hs1                     AND (ACTIVE_FLAG = '1' OR                          PREV_ACTIVE_FLAG = '1')
  24. UPDATE LANM.CONFIGURATION                    SET ACTIVE_TIME = :hl1                    WHERE SEGMENT_NO = :hach3_1 AND                          ACTIVE_FLAG = :hfch2                     AND (ACTIVE_FLAG = '1' OR                          PREV_ACTIVE_FLAG = '1')
  25. UPDATE LANM.CONFIGURATION                    SET ACTIVE_FLAG = :hfch1,                        ACTIVE_TIME = :hl1                    WHERE SEGMENT_NO = :hach3_1 AND                          ADAPT_ADDR  = :hach12_1                     AND (ACTIVE_FLAG = '1' OR                          PREV_ACTIVE_FLAG = '1')
  26. UPDATE LANM.CONFIGURATION                    SET PREV_ACTIVE_FLAG = :hfch1,                                              ACTIVE_FLAG   = :hfch1,                        ACTIVE_TIME = :hl1                    WHERE SEGMENT_NO = :hach3_1 AND                          PREV_ACTIVE_FLAG = :hfch2                     AND (ACTIVE_FLAG = '1' OR                          PREV_ACTIVE_FLAG = '1')
  27. UPDATE LANM.CONFIGURATION                    SET PREV_ACTIVE_FLAG = :hfch1,                                              ACTIVE_FLAG   = :hfch1,                        ACTIVE_TIME = :hl1                    WHERE SEGMENT_NO = :hach3_1 AND                          PREV_ACTIVE_FLAG = :hfch2 AND                          SEQUENCE_NO <= :hs1                     AND (ACTIVE_FLAG = '1' OR                          PREV_ACTIVE_FLAG = '1')
  28. UPDATE LANM.CONFIGURATION                    SET ACTIVE_TIME = :hl1                    WHERE ACTIVE_FLAG = :hfch2                     AND (ACTIVE_FLAG = '1' OR                          PREV_ACTIVE_FLAG = '1')
  29. UPDATE LANM.CONFIGURATION                    SET ACTIVE_FLAG = :hfch1,                        SEQUENCE_NO = :hs1,                        ACTIVE_TIME = :hl1                                            WHERE SEGMENT_NO = :hach3_1 AND                          ADAPT_ADDR = :hach12_1                     AND (ACTIVE_FLAG = '1' OR                          PREV_ACTIVE_FLAG = '1')
  30. UPDATE LANM.CONFIGURATION                  SET UNIVERSAL_ADDR = :hach12_2,                      FUNCTIONAL_ADDR= :hl1,                      GROUP_ADDR = :hach8_2,                      ACTIVE_FLAG = :hfch1,                      PREV_ACTIVE_FLAG = :hfch3,                      CAU_FLAG = :hfch4,                      CAU_ATTACHED_FLAG = :hfch5,                      ACTIVE_TIMESTAMP = CURRENT TIMESTAMP,                      ACTIVE_TIME = :hl2                  WHERE SEGMENT_NO = :hach3_1 AND                       ADAPT_ADDR = :hach12_1
  31. INSERT INTO LANM.CONFIGURATION                ( ADAPT_ADDR, UNIVERSAL_ADDR, SEGMENT_NO, SEQUENCE_NO,                  FUNCTIONAL_ADDR, GROUP_ADDR,                  ACTIVE_FLAG, PREV_ACTIVE_FLAG,                  AUTHORIZATION_FLAG, ACTIVE_TIMESTAMP, ACTIVE_TIME,                  CAU_FLAG, CAU_ATTACHED_FLAG, RESERVED)                VALUES                ( :hach12_1, :hach12_2, :hach3_1, :hs1,                  :hl1, :hach8_2,                  :hfch1, :hfch3,                  :hfch6, CURRENT TIMESTAMP, :hl2,                  :hfch4, :hfch5, :hl3)
  32. UPDATE LANM.CONFIGURATION                  SET UNIVERSAL_ADDR = :hach12_2,                      FUNCTIONAL_ADDR= :hl1,                      GROUP_ADDR = :hach8_2,                      ACTIVE_FLAG = :hfch1,                      PREV_ACTIVE_FLAG = :hfch3,                      ACTIVE_TIMESTAMP = CURRENT TIMESTAMP,                      ACTIVE_TIME = :hl2                  WHERE SEGMENT_NO = :hach3_1 AND                       ADAPT_ADDR = :hach12_1
  33. UPDATE LANM.CONFIGURATION                  SET UNIVERSAL_ADDR = :hach12_2,                      FUNCTIONAL_ADDR= :hl1,                      GROUP_ADDR = :hach8_2,                      ACTIVE_FLAG = :hfch1,                      PREV_ACTIVE_FLAG = :hfch3,                      AUTHORIZATION_FLAG = :hfch6,                      ACTIVE_TIMESTAMP = CURRENT TIMESTAMP,                      ACTIVE_TIME = :hl2                  WHERE SEGMENT_NO = :hach3_1 AND                       ADAPT_ADDR = :hach12_1
  34. INSERT INTO LANM.CONFIGURATION                ( ADAPT_ADDR, UNIVERSAL_ADDR, SEGMENT_NO, SEQUENCE_NO,                  FUNCTIONAL_ADDR, GROUP_ADDR,                  ACTIVE_FLAG, PREV_ACTIVE_FLAG,                  AUTHORIZATION_FLAG, ACTIVE_TIMESTAMP, ACTIVE_TIME,                  CAU_FLAG, CAU_ATTACHED_FLAG, RESERVED)                VALUES                ( :hach12_1, :hach12_2, :hach3_1, :hs1,                  :hl1, :hach8_2,                  :hfch1, :hfch3,                  :hfch6, CURRENT TIMESTAMP, :hl2,                  :hfch4, :hfch5, :hl3)
  35. UPDATE LANM.ALERT_FILTERS                    SET PRIORITY = :hch2,                        ALERT_BP = :hch3,                        ALERT_ID = :hach8_1,                        RESOURCE_NAME = :hach8_2,                        ERROR_TYPE = :hch4                    WHERE PRIORITY = :hch1
  36. UPDATE LANM.BRIDGE_DEFINITIONS                    SET BRIDGE_NAME = :hach8_1,                        BRIDGE_NO = :hch1,                        AUTOLINK_FLAG = :hfch1,                        SEGMENT1 = :hach3_1,                        SEGMENT1_TYPE = :hach2_1,                        ADDRESS1 = :hach12_1,                        SEGMENT2 = :hach3_2,                        SEGMENT2_TYPE = :hach2_2,                        ADDRESS2 = :hach12_2,                        NOTIFICATION_INT = :hach2_3,                        USER_COMMENT = :hach40_1,                        INTERNAL_USE = :hch2                    WHERE BRIDGE_NAME = :hacBridgeNameSv
  37. UPDATE LANM.CAU                    SET COMM_ADDR = :hach12_1                    WHERE CAU_ID = :hach8_1
  38. UPDATE LANM.CONFIGURATION                  SET CAU_FLAG = :hfch2, CAU_ATTACHED_FLAG = :hfch3                  WHERE SEGMENT_NO = :hach3_1                  AND   ADAPT_ADDR = :hach12_1
  39. UPDATE LANM.CAU                  SET CAU_STATUS=:hs1,                      REGISTRATION_FLAG = :hfch2,                      RESPONSE_FLAG = :hfch3                  WHERE SEGMENT_NO = :hach3_1                  AND   PREV_ACTIVE_FLAG = :hfch1
  40. UPDATE LANM.CAU                  SET PREV_ACTIVE_FLAG = :hfch1,                                      RESPONSE_FLAG = :hfch2                                          WHERE SEGMENT_NO = :hach3_1                  AND   CAU_STATUS = :hs1
  41. UPDATE LANM.CAU                    SET                       CAU_ID = :hach8_2,                       RING_IN_ADDR =  :hach12_1,                       RING_OUT_ADDR = :hach12_2,                       SECONDARY_ADDR = :hach12_3,                       COMM_ADDR =  :hach12_4,                       SEGMENT_NO = :hach3_1,                       MODULE1_STATUS = :hch1,                       MODULE2_STATUS = :hch2,                       MODULE3_STATUS = :hch3,                       MODULE4_STATUS = :hch4,                       CAU_STATUS = :hs1,                       BACKUP_PATH_STATUS = :hch5,                       DIAG_ERROR_CODE = :hach2_1,                       MICROCODE_LEVEL = :hach32_1,                       REGISTRATION_FLAG = :hfch1                    WHERE CAU_ID = :hach8_1
  42. UPDATE LANM.CAU                    SET CAU_PASSWORD  = :hach8_2                    WHERE CAU_ID = :hach8_1
  43. UPDATE LANM.CAU                    SET MODULE1_STATUS = :hch2                    WHERE CAU_ID = :hach8_1
  44. UPDATE LANM.CAU                    SET MODULE2_STATUS = :hch2                    WHERE CAU_ID = :hach8_1
  45. UPDATE LANM.CAU                    SET MODULE3_STATUS = :hch2                    WHERE CAU_ID = :hach8_1
  46. UPDATE LANM.CAU                    SET MODULE4_STATUS = :hch2                    WHERE CAU_ID = :hach8_1
  47. UPDATE LANM.CAU                  SET CAU_STATUS = :hs1, REGISTRATION_FLAG = :hch2
  48. UPDATE LANM.CAU                  SET CAU_STATUS = :hs1, REGISTRATION_FLAG = :hch2                  WHERE SEGMENT_NO = :hach3_1
  49. UPDATE LANM.CAU                    SET                       RING_IN_ADDR =  :hach12_1,                       RING_OUT_ADDR = :hach12_2,                       SECONDARY_ADDR = :hach12_3,                       COMM_ADDR =  :hach12_4,                       SEGMENT_NO = :hach3_1,                                          MICROCODE_LEVEL = :hach32_1,                                    REGISTRATION_FLAG = :hfch1                                   WHERE CAU_ID = :hach8_1
  50. UPDATE LANM.SYSTEM_PARAMETERS                    SET NAUN_CHANGES_FLAG = :hfch1,                        NAUN_CHANGES_SEG = :hach3_1
  51. UPDATE LANM.LOCATION_DEF                  SET CAU_ATTACH_MODULE = :hch1,                      CAU_LOBE = :hs1,                      CAU_REPORT_FLAG = :hfch1                  WHERE CAU_ID = :hach8_1 AND                        ADAPT_ADDR = :hach12_1
  52. UPDATE LANM.CAU_LOBE_LOCATION                  SET BUILDING = :hach8_2,                      ROOM_NUMBER = :hach8_3                  WHERE CAU_ID = :hach8_1 AND                        CAU_ATTACH_MODULE = :hch1 AND                        CAU_LOBE = :hs1
  53. UPDATE LANM.CONFIGURATION                    SET PREV_ACTIVE_FLAG = :hfch1                                           WHERE SEGMENT_NO = :hach3_1 AND                          ACTIVE_FLAG = :hfch2
  54. UPDATE LANM.CONFIGURATION                    SET SEQUENCE_NO = SEQUENCE_NO + :hs1                    WHERE SEGMENT_NO = :hacSegmentNoSv AND                          SEQUENCE_NO > :hsSequenceNoSv AND                          ACTIVE_FLAG = :hfch2
  55. UPDATE LANM.CONFIGURATION                    SET SEQUENCE_NO =  :hs1                    WHERE SEGMENT_NO = :hach3_1 AND                          ADAPT_ADDR = :hach12_1
  56. SELECT ADAPT_ADDR  INTO :hach12_2             FROM LANM.STATION_DEFINITION             WHERE ADAPT_NAME = :hach16_2
  57. UPDATE LANM.STATION_DEFINITION                    SET                       ADAPT_ADDR = :hach12_1,                       ADAPT_NAME = :hach16_1,                       TRACE_FLAG = :hfch2,                       MONITORED_FLAG = :hfch1,                       DAYS_AUTHOR_FROM = :hs1,                       DAYS_AUTHOR_TO   = :hs2,                       TIME_AUTHOR_FROM = :hs3,                       TIME_AUTHOR_TO   = :hs4,                       USER_COMMENT = :hach40_1                    WHERE ADAPT_NAME = :hach16_2
  58. UPDATE LANM.STATION_DEFINITION                    SET                       ADAPT_ADDR = :hach12_1,                       ADAPT_NAME = :hach16_1,                       TRACE_FLAG = :hfch2,                       MONITORED_FLAG = :hfch1,                       DAYS_AUTHOR_FROM = :hs1,                       DAYS_AUTHOR_TO   = :hs2,                       TIME_AUTHOR_FROM = :hs3,                       TIME_AUTHOR_TO   = :hs4,                       USER_COMMENT = :hach40_1                    WHERE ADAPT_ADDR = :hach12_2
  59. COMMIT
  60. UPDATE LANM.LOCATION_DEF                     SET                       ADAPT_ADDR = :hach12_1,                       CAU_ID = :hach8_1,                       CAU_ATTACH_MODULE = :hch1,                       CAU_LOBE = :hs5,                       CAU_REPORT_FLAG = :hfch1                    WHERE ADAPT_ADDR = :hach12_2
  61. INSERT INTO LANM.LOCATION_DEF                ( ADAPT_ADDR, CAU_ID,                  CAU_ATTACH_MODULE, CAU_LOBE, CAU_REPORT_FLAG)             VALUES (:hach12_1, :hach8_1, :hch1, :hs5, :hfch1)
  62. DELETE FROM LANM.LOCATION_DEF                    WHERE ADAPT_ADDR = :hach12_2
  63. UPDATE LANM.SYSTEM_PARAMETERS            SET ADAPT_NO = :hch1,                DLC_LINK_STATION = :hs1,                AUTO_BDG_LINK = :hch2,                AUTO_LINK_TIME_INT = :hs9,                HOST_CONNECTION = :hch3,                TRACING_AUTH = :hch4,                ADAPT_MONITORING = :hch5,                ADAPTS_MONITORED = :hs2,                NUM_MONITOR_RETRY = :hs3,                REM_RESP_TIMEOUT = :hs5,                BEACON_AUTO_RETRY = :hch6,                RETRY_INTERVAL = :hs6,                NUM_RETRIES = :hs7,                REPORT_LINK_NO = :hch7,                REPORT_LINK_PW = :hach8_1,                SERVICE_PT_NAME = :hach8_2,                LAN_NAME = :hach8_3,                EVENT_LOG_LIMIT = :hs8,                BDG_PERFORM_LIMIT = :hl3,                RESYNC_INTERVAL = :hl1,                AGE_OUT = :hl2,                ACCESS_CONT_FLAG = :hch11,                UNAUTHORIZED_ADAPT = :hch12,                UNAUTHORIZED_TIME  = :hch13,                UNAUTHORIZED_MOVE  = :hch14,                UNAUTHORIZED_BRG   = :hch15,                ADAPTER_REMOVAL    = :hch16,                CAU_PASSWORD       = :hach8_5,                USER_COMMENT = :hach40_1,                ALERT_FILTER_DLL = :hach8_4,                ALERT_PGM_MODULE = :hach32_1,                ALERT_PGM_STATUS = :hfch1
  64. COMMIT
  65. hfch1
  66. hfch2
  67. hfch3
  68. hfch4
  69. hfch5
  70. hfch6
  71. hch10
  72. hch11
  73. hch12
  74. hch13
  75. hch14
  76. hch15
  77. hch16
  78. hach2_1
  79. hach2_2
  80. hach2_3
  81. hach3_1
  82. hach3_2
  83. hach3_3
  84. hach3_4
  85. hach4_1
  86. hach4_2
  87. hach8_1
  88. hach8_2
  89. hach8_3
  90. hach8_4
  91. hach8_5
  92. hach9_1
  93. hach10_1
  94. hach12_1
  95. hach12_2
  96. hach12_3
  97. hach12_4
  98. hach16_1
  99. hach16_2
  100. hach18_1
  101. hach20_1
  102. hach20_2
  103. hach26_1
  104. hach32_1
  105. hach32_2
  106. hach32_3
  107. hach33_1
  108. hach40_1
  109. hach41_1
  110. hach41_2
  111. hach41_3
  112. hach80_1
  113. hlcount
  114. hacBridgeNameSv
  115. hacSegmentNoSv
  116. hsSequenceNoSv
  117.