home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 8 Other
/
08-Other.zip
/
10ageout.zip
/
DFIDBADD.BND
(
.txt
)
next >
Wrap
DB2 Bind
|
1993-08-19
|
12KB
|
77 lines
DFIDBADDyA1CKTIJUSERID 0
BEGIN DECLARE SECTION
END DECLARE SECTION
UPDATE LANM.EVENT_LOG SET EVENT_TIME = :hach8_1, EVENT_DATE = :hach10_1, MESSAGE_NO = :hach3_1, HOST_FLAG = :hfch1, SEGMENT_NO = :hach3_2, ADAPT_ADDR1 = :hach12_1, VARIABLE_DATA1 = :hach41_1, ADAPT_ADDR2 = :hach12_2, VARIABLE_DATA2 = :hach41_2, VARIABLE_DATA3 = :hach41_3, DELETE_FLAG = :hfch2, SORT_NUM = :hl2 WHERE RESERVED = :hl1
UPDATE LANM.EVENT_LOG SET EVENT_TIME = :hach8_1, EVENT_DATE = :hach10_1, MESSAGE_NO = :hach3_1, HOST_FLAG = :hfch1, SEGMENT_NO = :hach3_2, ADAPT_ADDR1 = :hach12_1, VARIABLE_DATA1 = :hach41_1, ADAPT_ADDR2 = :hach12_2, VARIABLE_DATA2 = :hach41_2, VARIABLE_DATA3 = :hach41_3, DELETE_FLAG = :hfch2, SORT_NUM = :hl2 WHERE RESERVED = :hl1
UPDATE LANM.EVENT_LOG SET DELETE_FLAG = :hfch2 WHERE RESERVED = :hl1
UPDATE LANM.EVENT_LOG SET EVENT_TIME = :hach8_1, EVENT_DATE = :hach10_1, MESSAGE_NO = :hach3_1, HOST_FLAG = :hfch1, SEGMENT_NO = :hach3_2, ADAPT_ADDR1 = :hach12_1, VARIABLE_DATA1 = :hach41_1, ADAPT_ADDR2 = :hach12_2, VARIABLE_DATA2 = :hach41_2, VARIABLE_DATA3 = :hach41_3, DELETE_FLAG = :hfch2, SORT_NUM = :hl2 WHERE RESERVED = :hl1
SELECT MAX(RESERVED) INTO :hlMaxRsvd:hni FROM LANM.EVENT_LOG
INSERT INTO LANM.EVENT_LOG (RESERVED, DELETE_FLAG) VALUES (:hlRsvd, :hfch1)
INSERT INTO LANM.ALERT_DETAILS (RESERVED) VALUES (:hlRsvd)
COMMIT
PREPARE S1 FROM :hachInsertStr
EXECUTE S1 USING DESCRIPTOR :sqlptr
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_1, :hfch1, :hfch5, :hfch6, CURRENT TIMESTAMP, :hl3, :hfch3, :hfch4, :hl2)
INSERT INTO LANM.LOCATION_DEF ( ADAPT_ADDR, CAU_ID, CAU_ATTACH_MODULE, CAU_LOBE, CAU_REPORT_FLAG, FOUND_FLAG) VALUES ( :hach12_1, :hach8_1, :hch1, :hs1, :hfch1, :hfch2)
INSERT INTO LANM.BRIDGE_DEFINITIONS (BRIDGE_NAME, BRIDGE_NO, AUTOLINK_FLAG, SEGMENT1, SEGMENT1_TYPE, ADDRESS1, SEGMENT2, SEGMENT2_TYPE, ADDRESS2, NOTIFICATION_INT, USER_COMMENT, INTERNAL_USE, RESERVED) VALUES ( :hach8_1, :hch1, :hfch1, :hach3_1, :hach2_1, :hach12_1, :hach3_2, :hach2_2, :hach12_2, :hach2_3, :hach40_1, :hch2, :hl1 )
INSERT INTO LANM.STATION_DEFINITION (ADAPT_ADDR, ADAPT_NAME, USER_COMMENT, MONITORED_FLAG, TRACE_FLAG, DAYS_AUTHOR_FROM, DAYS_AUTHOR_TO, TIME_AUTHOR_FROM, TIME_AUTHOR_TO, RESERVED) VALUES (:hach12_1, :hach16_1, :hach40_1, :hfch1, :hfch2, :hs3, :hs4, :hs1, :hs2, :hl1)
SELECT ADAPT_NAME INTO :hach16_2 FROM LANM.STATION_DEFINITION WHERE ADAPT_NAME = :hach16_1
SELECT ADAPT_ADDR INTO :hach12_2 FROM LANM.STATION_DEFINITION WHERE ADAPT_ADDR = :hach12_1
COMMIT
UPDATE LANM.LOCATION_DEF SET CAU_ID = :hach8_1, CAU_ATTACH_MODULE = :hch1, CAU_LOBE = :hs5, CAU_REPORT_FLAG = :hfch1 WHERE ADAPT_ADDR = :hach12_1
INSERT INTO LANM.LOCATION_DEF ( ADAPT_ADDR, CAU_ID, CAU_ATTACH_MODULE, CAU_LOBE, CAU_REPORT_FLAG, FOUND_FLAG) VALUES (:hach12_1, :hach8_1, :hch1, :hs5, :hfch1, :hfch2)
COMMIT
UPDATE LANM.CONFIGURATION SET AUTHORIZATION_FLAG = :hfch1 WHERE ADAPT_ADDR = :hach12_1
INSERT INTO LANM.CAU ( CAU_ID, COMM_ADDR, SEGMENT_NO, CAU_PASSWORD, RESERVED, MODULE1_STATUS, MODULE2_STATUS, MODULE3_STATUS, MODULE4_STATUS, CAU_STATUS, BACKUP_PATH_STATUS, DIAG_ERROR_CODE, EXPECTED_RESPONSES, RESPONSE_FLAG) VALUES ( :hach8_1, :hach12_1, :hach3_1, :hach8_2, :hl1, :hch1, :hch2, :hch3, :hch4, :hs1, :hch5, :hach2_1, :hs2 , :hfch3)
INSERT INTO LANM.CAU_LOBE_LOCATION ( CAU_ID, CAU_ATTACH_MODULE, CAU_LOBE, BUILDING, ROOM_NUMBER) VALUES ( :hach8_1, :hch1, :hs1, :hach8_2, :hach8_3)
INSERT INTO LANM.CAU ( CAU_ID, ROOM_NUMBER, RESERVED, SEGMENT_NO, MODULE1_STATUS, MODULE2_STATUS, MODULE3_STATUS, MODULE4_STATUS, CAU_STATUS, BACKUP_PATH_STATUS, DIAG_ERROR_CODE, EXPECTED_RESPONSES, RESPONSE_FLAG) VALUES ( :hach8_1, :hach8_2, :hl1, :hach3_1, :hch1, :hch2, :hch3, :hch4, :hs1, :hch5, :hach2_1, :hs2, :hfch3)
INSERT INTO LANM.CAU ( CAU_ID, SEGMENT_NO, RESERVED, MODULE1_STATUS, MODULE2_STATUS, MODULE3_STATUS, MODULE4_STATUS, CAU_STATUS, BACKUP_PATH_STATUS, DIAG_ERROR_CODE, REGISTRATION_FLAG, PREV_ACTIVE_FLAG, EXPECTED_RESPONSES, RESPONSE_FLAG) VALUES ( :hach8_1, :hach3_1, :hl1, :hch1, :hch2, :hch3, :hch4, :hs1, :hch5, :hach2_1, :hfch1, :hfch2, :hs2, :hfch3)
INSERT INTO LANM.CAU_QUALIFIERS ( SEGMENT ) VALUES ( :hach3_1 )
UPDATE LANM.BRIDGE_PERFORMANCE SET PERFORM_TIME = :htime, PERFORM_DATE = :hdate, INTERVAL_SECONDS = :hl13, SEGMENT1 = :hach3_1, SEGMENT2 = :hach3_2, BRIDGE_NUM = :hch1, BC_FRAMES_FORWARD1= :hl1, BC_BYTES_FORWARD1 = :hd1, NBC_FRAME_FORWARD1= :hl2, NBC_BYTES_FORWARD1= :hd2, FRAMES_DISC_SEG1 = :hl3, FRAMES_NR_CONGEST1= :hl4, FRAMES_DISC_LINK1 = :hl5, BYTES_DISC_LINK1 = :hd3, FRAMES_DISC_OTHER1= :hl6, FRAMES_NR_FILTER1 = :hl14, BC_FRAMES_FORWARD2= :hl7, BC_BYTES_FORWARD2 = :hd4, NBC_FRAME_FORWARD2= :hl8, NBC_BYTES_FORWARD2= :hd5, FRAMES_DISC_SEG2 = :hl9, FRAMES_NR_CONGEST2= :hl10, FRAMES_DISC_LINK2 = :hl11, BYTES_DISC_LINK2 = :hd6, FRAMES_DISC_OTHER2= :hl12, FRAMES_NR_FILTER2 = :hl15, LONG_SECONDS = :hl16 WHERE BRIDGE_NAME = :hach8_1 AND SEQUENCE_NO = :hs1
INSERT INTO LANM.BRIDGE_PERFORMANCE (BRIDGE_NAME, PERFORM_TIME, PERFORM_DATE, INTERVAL_SECONDS, SEGMENT1, SEGMENT2, BRIDGE_NUM, BC_FRAMES_FORWARD1, BC_BYTES_FORWARD1, NBC_FRAME_FORWARD1, NBC_BYTES_FORWARD1, FRAMES_DISC_SEG1, FRAMES_NR_CONGEST1, FRAMES_DISC_LINK1, BYTES_DISC_LINK1, FRAMES_DISC_OTHER1, FRAMES_NR_FILTER1, BC_FRAMES_FORWARD2, BC_BYTES_FORWARD2, NBC_FRAME_FORWARD2, NBC_BYTES_FORWARD2, FRAMES_DISC_SEG2, FRAMES_NR_CONGEST2, FRAMES_DISC_LINK2, BYTES_DISC_LINK2, FRAMES_DISC_OTHER2, FRAMES_NR_FILTER2, LONG_SECONDS, SEQUENCE_NO) VALUES (:hach8_1, CURRENT TIME, CURRENT DATE, :hl13, :hach3_1, :hach3_2, :hch1, :hl1, :hd1, :hl2, :hd2, :hl3, :hl4, :hl5, :hd3, :hl6, :hl14, :hl7, :hd4, :hl8, :hd5, :hl9, :hl10, :hl11, :hd6, :hl12, :hl15, :hl16, :hs1)
INSERT INTO LANM.ALERT_FILTERS ( PRIORITY, ALERT_BP, ALERT_ID, RESOURCE_NAME, ERROR_TYPE ) VALUES ( :hch1, :hch2, :hach8_1, :hach8_2, :hch3 )
COMMIT
hfch1
hfch2
hfch3
hfch4
hfch5
hfch6
hach2_1
hach2_2
hach2_3
hach3_1
hach3_2
hach3_3
hach3_4
hach4_1
hach4_2
hach8_1
hach8_2
hach8_3
hach10_1
hach12_1
hach12_2
hach12_3
hach16_1
hach16_2
hach18_1
hach26_1
hach32_1
hach32_2
hach32_3
hach33_1
hach36_1
hach40_1
hach41_1
hach41_2
hach41_3
hach80_1
hach254_1
hach254_2
hlMaxRsvd
hlRsvd
hachInsertStr
htime
hdate