DFIDBUPDKBxTOdDKUSERID 0 BEGIN DECLARE SECTION END DECLARE SECTION BEGIN DECLARE SECTION END DECLARE SECTION UPDATE LANM.CONFIGURATION SET AUTHORIZATION_FLAG = :h_fchFlagRecFlag WHERE SEGMENT_NO = :h_ach6SegmentNo AND ADAPT_ADDR = :h_ach6AdaptAddr UPDATE LANM.CONFIGURATION SET AUTHORIZATION_FLAG = '1' WHERE AUTHORIZATION_FLAG <> '1' UPDATE LANM.CAU SET ROOM_NUMBER = :h_achCauLocRoomNum WHERE CAU_ID = :h_ach10CauId UPDATE LANM.CAU SET REGISTRATION_FLAG = :h_fchFlagRecFlag, CAU_STATUS = 4, RESPONSE_FLAG = '0' UPDATE LANM.CAU SET REGISTRATION_FLAG = :h_chCauFlags2RegistrationFlag, PREV_ACTIVE_FLAG = :h_fchCauFlags2PrevActiveFlag, RESPONSE_FLAG = :h_fchCauFlags2ResponseFlag WHERE CAU_ID = :h_ach10CauId UPDATE LANM.EVENT_LOG SET HOST_FLAG = :h_fchFlagRecFlag WHERE RESERVED = :h_l26GenericLong UPDATE LANM.LOCATION_DEF SET CAU_ATTACH_MODULE = :h_chLocationCauAttachModule, CAU_LOBE = :h_usLocationCauLobe, CAU_ID = :h_achLocationCauId WHERE ADAPT_ADDR = :h_ach19AdaptAddr UPDATE LANM.CONFIGURATION SET SEGMENT_NO = :h_achSegSegmentNo WHERE SEGMENT_NO = :h_ach3SegmentNo COMMIT UPDATE LANM.CAU SET SEGMENT_NO = :h_achSegSegmentNo WHERE SEGMENT_NO = :h_ach3SegmentNo UPDATE LANM.STATION_DEFINITION SET TRACE_FLAG = :h_fchFlagRecFlag WHERE ADAPT_ADDR = :h_ach19AdaptAddr UPDATE LANM.SYSTEM_PARAMETERS SET EL_FILENAME = :h_achElPrintfilename UPDATE LANM.EVENT_FILTERS SET DESCRIPTION = :h_achEventFilterDescription, ACTIVE_FLAG = :h_fchEventFilterActive, START_DATE = :h_achEventFilterStartDate, START_TIME = :h_achEventFilterStartTime, END_DATE = :h_achEventFilterEndDate, END_TIME = :h_achEventFilterEndTime, ADAPTER_ADDR = :h_achEventFilterAdptAddr, BRIDGE_NAME = :h_achEventFilterBridgeName, CAU_ID = :h_achEventFilterCauId, SEGMENT_LIST = :h_varsegslist, EVENT_LIST = :h_vareventlist WHERE RESERVED = :h_l26GenericLong COMMIT UPDATE LANM.CONFIGURATION SET UNIVERSAL_ADDR = :h_achSProfUniversalAddr, FUNCTIONAL_ADDR = :h_lSProfFunctionalAddr, GROUP_ADDR = :h_achSProfGroupAddr, ACTIVE_TIMESTAMP = CURRENT TIMESTAMP, ACTIVE_TIME = :h_lSProfActiveTime WHERE SEGMENT_NO = :h_ach6SegmentNo AND ADAPT_ADDR = :h_ach6AdaptAddr UPDATE LANM.CONFIGURATION SET UNIVERSAL_ADDR = :h_achSProfUniversalAddr, FUNCTIONAL_ADDR = :h_lSProfFunctionalAddr, GROUP_ADDR = :h_achSProfGroupAddr, AUTHORIZATION_FLAG = :h_fchSProfAuthorizationFlag, ACTIVE_TIMESTAMP = CURRENT TIMESTAMP, ACTIVE_TIME = :h_lSProfActiveTime WHERE SEGMENT_NO = :h_ach6SegmentNo AND ADAPT_ADDR = :h_ach6AdaptAddr INSERT INTO LANM.CONFIGURATION ( ADAPT_ADDR, UNIVERSAL_ADDR, SEGMENT_NO, SEQUENCE_NO, FUNCTIONAL_ADDR, GROUP_ADDR, CAU_ATTACHED_FLAG, AUTHORIZATION_FLAG, ACTIVE_TIMESTAMP, ACTIVE_TIME, RESERVED) VALUES ( :h_ach6AdaptAddr, :h_achSProfUniversalAddr, :h_ach6SegmentNo, 0, :h_lSProfFunctionalAddr, :h_achSProfGroupAddr, '0', :h_fchSProfAuthorizationFlag, CURRENT TIMESTAMP, :h_lSProfActiveTime, :h_Reserved) UPDATE LANM.CONFIGURATION SET UNIVERSAL_ADDR = :h_achConfigUniversalAddr, FUNCTIONAL_ADDR = :h_lConfigFunctionalAddr, SEQUENCE_NO = :h_usConfigSequenceNo, GROUP_ADDR = :h_achConfigGroupAddr, ACTIVE_TIMESTAMP = CURRENT TIMESTAMP, ACTIVE_TIME = :h_lConfigActiveTime, MICROCODE_LEVEL = :h_achConfigMicrocode WHERE SEGMENT_NO = :h_ach6SegmentNo AND ADAPT_ADDR = :h_ach6AdaptAddr UPDATE LANM.CONFIGURATION SET UNIVERSAL_ADDR = :h_achConfigUniversalAddr, FUNCTIONAL_ADDR= :h_lConfigFunctionalAddr, SEQUENCE_NO = :h_usConfigSequenceNo, GROUP_ADDR = :h_achConfigGroupAddr, AUTHORIZATION_FLAG = :h_fchConfigAuthorizationFlag, ACTIVE_TIMESTAMP = CURRENT TIMESTAMP, ACTIVE_TIME = :h_lConfigActiveTime, MICROCODE_LEVEL = :h_achConfigMicrocode WHERE SEGMENT_NO = :h_ach6SegmentNo AND ADAPT_ADDR = :h_ach6AdaptAddr INSERT INTO LANM.CONFIGURATION ( ADAPT_ADDR, UNIVERSAL_ADDR, SEGMENT_NO, SEQUENCE_NO, FUNCTIONAL_ADDR, GROUP_ADDR, CAU_ATTACHED_FLAG, AUTHORIZATION_FLAG, ACTIVE_TIMESTAMP, ACTIVE_TIME, RESERVED, MICROCODE_LEVEL) VALUES ( :h_ach6AdaptAddr, :h_achConfigUniversalAddr, :h_ach6SegmentNo, :h_usConfigSequenceNo, :h_lConfigFunctionalAddr, :h_achConfigGroupAddr, '0', :h_fchConfigAuthorizationFlag, CURRENT TIMESTAMP, :h_lConfigActiveTime, :h_Reserved, :h_achConfigMicrocode) UPDATE LANM.BRIDGE_DEFINITIONS SET BRIDGE_NAME = :h_achBridgeDefBridgeName, BRIDGE_NO = :h_chBridgeDefBridgeNo, AUTOLINK_FLAG = :h_fchBridgeDefAutoLinkFlag, SEGMENT1 = :h_achBridgeDefSegmentNo2, SEGMENT1_TYPE = :h_achBridgeDefSegment2Type, ADDRESS1 = :h_achBridgeDefAdaptAddr2, SEGMENT2 = :h_achBridgeDefSegmentNo1, SEGMENT2_TYPE = :h_achBridgeDefSegment1Type, ADDRESS2 = :h_achBridgeDefAdaptAddr1, NOTIFICATION_INT = :h_achBridgeDefNotifInterval, USER_COMMENT = :h_achBridgeDefComment, INTERNAL_USE = :h_chBridgeDefInternalUse, BRIDGE_TYPE = :h_achBridgeDefBridgeType WHERE BRIDGE_NAME = :h_ach12BridgeName UPDATE LANM.BRIDGE_DEFINITIONS SET BRIDGE_NAME = :h_achBridgeDefBridgeName, BRIDGE_NO = :h_chBridgeDefBridgeNo, AUTOLINK_FLAG = :h_fchBridgeDefAutoLinkFlag, SEGMENT1 = :h_achBridgeDefSegmentNo1, SEGMENT1_TYPE = :h_achBridgeDefSegment1Type, ADDRESS1 = :h_achBridgeDefAdaptAddr1, SEGMENT2 = :h_achBridgeDefSegmentNo2, SEGMENT2_TYPE = :h_achBridgeDefSegment2Type, ADDRESS2 = :h_achBridgeDefAdaptAddr2, NOTIFICATION_INT = :h_achBridgeDefNotifInterval, USER_COMMENT = :h_achBridgeDefComment, INTERNAL_USE = :h_chBridgeDefInternalUse, BRIDGE_TYPE = :h_achBridgeDefBridgeType WHERE BRIDGE_NAME = :h_ach12BridgeName SELECT COUNT(*) INTO :hlcount FROM LANM.BRIDGE_DEFINITIONS WHERE (ADDRESS1 = :h_achBridgeDefAdaptAddr1 OR ADDRESS2 = :h_achBridgeDefAdaptAddr1) AND BRIDGE_NAME <> :h_ach12BridgeName SELECT COUNT(*) INTO :hlcount FROM LANM.BRIDGE_DEFINITIONS WHERE (ADDRESS2 = :h_achBridgeDefAdaptAddr2 OR ADDRESS1 = :h_achBridgeDefAdaptAddr2) AND BRIDGE_NAME <> :h_ach12BridgeName UPDATE LANM.CAU SET COMM_ADDR = :h_achNaunAdaptAddr WHERE CAU_ID = :h_ach10CauId UPDATE LANM.CAU SET MODULE_ORDER = :h_achCauModOrder WHERE CAU_ID = :h_ach10CauId UPDATE LANM.CONFIGURATION SET CAU_ATTACHED_FLAG = :h_fchCauFlagsCauAttachedFlag WHERE SEGMENT_NO = :h_ach6SegmentNo AND ADAPT_ADDR = :h_ach6AdaptAddr UPDATE LANM.CAU SET CAU_STATUS=:h_usCauStatusCauStatus, REGISTRATION_FLAG = '0', RESPONSE_FLAG = '0' WHERE SEGMENT_NO = :h_ach36SegmentNo AND PREV_ACTIVE_FLAG = :h_fch36PrevActiveFlag UPDATE LANM.CAU SET PREV_ACTIVE_FLAG = :h_fchCauFlags2PrevActiveFlag, RESPONSE_FLAG = :h_fchCauFlags2ResponseFlag WHERE SEGMENT_NO = :h_ach11SegmentNo AND CAU_STATUS = :h_us11CauStatus UPDATE LANM.CAU SET SEV1_COUNTER = :h_usCauNotifSev1Ctr, SEV2_COUNTER = :h_usCauNotifSev2Ctr, NOTIFICATION_FLAG = :h_fchCauNotifNotificationFlag, CAU_STATUS = :h_usCauNotifCauStatus WHERE CAU_ID = :h_ach10CauId UPDATE LANM.CAU SET SEV1_COUNTER = 0, SEV2_COUNTER = 0, NOTIFICATION_FLAG = :h_ClearBit UPDATE LANM.CAU SET NOTIFICATION_FLAG = :h_ClearBit WHERE CAU_ID = :h_ach10CauId UPDATE LANM.CAU SET NOTIFICATION_FLAG = :h_ClearBit WHERE SEGMENT_NO = :h_ach3SegmentNo UPDATE LANM.CAU SET NOTIFICATION_FLAG = :h_ClearBit UPDATE LANM.CAU SET RING_IN_ADDR = :h_achCauRingInAddr, RING_OUT_ADDR = :h_achCauRingOutAddr, SECONDARY_ADDR = :h_achCauSecondaryAddr, COMM_ADDR = :h_achCauCommAddr, SEGMENT_NO = :h_achCauSegmentNo, MODULE1_STATUS = :h_chCauModuleStatus1, MODULE2_STATUS = :h_chCauModuleStatus2, MODULE3_STATUS = :h_chCauModuleStatus3, MODULE4_STATUS = :h_chCauModuleStatus4, CAU_STATUS = :h_usCauCauStatus, BACKUP_PATH_STATUS = :h_chCauBackupPathStatus, DIAG_ERROR_CODE = :h_achCauDiagErrCodeStatus, MICROCODE_LEVEL = :h_achCauMicroCodeLevel, REGISTRATION_FLAG = :h_chCauRegistrationFlag, SEV2_COUNTER = :h_usCauSev2Ctr WHERE CAU_ID = :h_ach10CauId UPDATE LANM.CAU SET CAU_PASSWORD = :h_caupwEncrypt WHERE CAU_ID = :h_ach10CauId UPDATE LANM.CAU SET MODULE1_STATUS = :h_chGenericChar WHERE CAU_ID = :h_ach37CauId UPDATE LANM.CAU SET MODULE2_STATUS = :h_chGenericChar WHERE CAU_ID = :h_ach37CauId UPDATE LANM.CAU SET MODULE3_STATUS = :h_chGenericChar WHERE CAU_ID = :h_ach37CauId UPDATE LANM.CAU SET MODULE4_STATUS = :h_chGenericChar WHERE CAU_ID = :h_ach37CauId UPDATE LANM.CAU SET CAU_STATUS = :h_usCauStatusCauStatus, REGISTRATION_FLAG = :h_chCauStatusRegistrationFlag UPDATE LANM.CAU SET CAU_STATUS = :h_usCauStatusCauStatus, REGISTRATION_FLAG = :h_chCauStatusRegistrationFlag WHERE SEGMENT_NO = :h_ach6SegmentNo UPDATE LANM.CAU SET CAU_STATUS = :h_usCauStatusCauStatus, REGISTRATION_FLAG = :h_chCauStatusRegistrationFlag, MODULE1_STATUS = '0', MODULE2_STATUS = '0', MODULE3_STATUS = '0', MODULE4_STATUS = '0' WHERE CAU_ID = :h_ach10CauId UPDATE LANM.CAU SET RING_IN_ADDR = :h_achCauAddrsRingInAddr, RING_OUT_ADDR = :h_achCauAddrsRingOutAddr, SECONDARY_ADDR = :h_achCauAddrsSecondaryAddr, COMM_ADDR = :h_achCauAddrsCommAddr, SEGMENT_NO = :h_achCauAddrsSegmentNo, MICROCODE_LEVEL = :h_achCauAddrsMicroCodeLevel, REGISTRATION_FLAG = :h_chCauAddrsRegistrationFlag WHERE CAU_ID = :h_ach10CauId UPDATE LANM.SYSTEM_PARAMETERS SET NAUN_CHANGES_FLAG = :h_fchCnfgChgConfigChangesFlag, NAUN_CHANGES_SEG = :h_achCnfgChgSegmentNo UPDATE LANM.LOCATION_DEF SET CAU_ATTACH_MODULE = :h_chLocationCauAttachModule, CAU_LOBE = :h_usLocationCauLobe WHERE CAU_ID = :h_ach39CauId AND ADAPT_ADDR = :h_ach39AdaptAddr UPDATE LANM.CAU_LOBE_LOCATION SET BUILDING = :h_achLobeLocBuilding, ROOM_NUMBER = :h_achLobeLocRoomNum WHERE CAU_ID = :h_ach41CauId AND CAU_ATTACH_MODULE = :h_ch41CauAttachModule AND CAU_LOBE = :h_us41CauLobe UPDATE LANM.STATION_DEFINITION SET ADAPT_ADDR = :h_achStatDefAdaptAddr, ADAPT_NAME = :h_achStatDefAdaptName, TRACE_FLAG = :h_fchStatDefTraceFlag, MONITORED_FLAG = :h_fchStatDefMonitoredFlag, DAYS_AUTHOR_FROM = :h_usStatDefDaysAuthorFrom, DAYS_AUTHOR_TO = :h_usStatDefDaysAuthorTo, TIME_AUTHOR_FROM = :h_usStatDefTimeAuthorFrom, TIME_AUTHOR_TO = :h_usStatDefTimeAuthorTo, USER_COMMENT = :h_achStatDefUserComment WHERE ADAPT_NAME = :h_ach16AdaptName UPDATE LANM.STATION_DEFINITION SET ADAPT_ADDR = :h_achStatDefAdaptAddr, ADAPT_NAME = :h_achStatDefAdaptName, TRACE_FLAG = :h_fchStatDefTraceFlag, MONITORED_FLAG = :h_fchStatDefMonitoredFlag, DAYS_AUTHOR_FROM = :h_usStatDefDaysAuthorFrom, DAYS_AUTHOR_TO = :h_usStatDefDaysAuthorTo, TIME_AUTHOR_FROM = :h_usStatDefTimeAuthorFrom, TIME_AUTHOR_TO = :h_usStatDefTimeAuthorTo, USER_COMMENT = :h_achStatDefUserComment WHERE ADAPT_ADDR = :h_ach19AdaptAddr COMMIT UPDATE LANM.LOCATION_DEF SET CAU_ID = :h_achStatDefCauId, CAU_ATTACH_MODULE = :h_chStatDefCauAttachModule, CAU_LOBE = :h_usStatDefCauLobe WHERE ADAPT_ADDR = :h_achStatDefAdaptAddr INSERT INTO LANM.LOCATION_DEF ( ADAPT_ADDR, CAU_ID, CAU_ATTACH_MODULE, CAU_LOBE) VALUES (:h_achStatDefAdaptAddr, :h_achStatDefCauId, :h_chStatDefCauAttachModule, :h_usStatDefCauLobe) DELETE FROM LANM.LOCATION_DEF WHERE ADAPT_ADDR = :h_achStatDefAdaptAddr UPDATE LANM.SYSTEM_PARAMETERS SET ADAPT_NO = :h_bSysParmsAdaptNo, DLC_LINK_STATION = :h_usSysParmsDlcLinkStat, AUTO_BDG_LINK = :h_bSysParmsAutoBdgLink, AUTO_LINK_TIME_INT = :h_usSysParmsAutoLinkTimeInt, HOST_CONNECTION = :h_bSysParmsHostConnect, TRACING_AUTH = :h_bSysParmsTraceAuth, ADAPT_MONITORING = :h_bSysParmsAdaptMonitoring, ADAPTS_MONITORED = :h_usSysParmsAdaptsMonitored, NUM_MONITOR_RETRY = :h_usSysParmsMonitorRetries, REM_RESP_TIMEOUT = :h_usSysParmsRemoteResTimeOut, BEACON_AUTO_RETRY = :h_bSysParmsBeaconAutoRetry, RETRY_INTERVAL = :h_usSysParmsRetryTimeInterval, NUM_RETRIES = :h_usSysParmsNumOfRetries, REPORT_LINK_NO = :h_bSysParmsReportLinkNum, REPORT_LINK_PW = :h_bridgepwEncrypt, SERVICE_PT_NAME = :h_achSysParmsServicePointName, LAN_NAME = :h_achSysParmsLanName, EVENT_LOG_LIMIT = :h_usSysParmsLogLimit, BDG_PERFORM_LIMIT = :h_lSysParmsBdgPerformLimit, RESYNC_INTERVAL = :h_lSysParmsResyncTimeOut, AGE_OUT = :h_lSysParmsAgeOut, ACCESS_CONT_FLAG = :h_bSysParmsAccessControl, UNAUTHORIZED_ADAPT = :h_bSysParmsUnauthorizedAdap, UNAUTHORIZED_TIME = :h_bSysParmsUnauthorizedTime, UNAUTHORIZED_MOVE = :h_bSysParmsAdapterMove, UNAUTHORIZED_BRG = :h_bSysParmsInvalidBridge, ADAPTER_REMOVAL = :h_bSysParmsDisableLobe, CAU_PASSWORD = :h_caupwEncrypt, USER_COMMENT = :h_achSysParmsComment, ALERT_FILTER_DLL = :h_achSysParmsUserFileName, ALERT_PGM_MODULE = :h_achSysParmsModuleName, ALERT_PGM_STATUS = :h_fchSysParmsAlrtProgStatus UPDATE LANM.SYSTEM_PARAMETERS SET LSM_DATA_SAVE_FLAG = :h_fchFlagRecFlag UPDATE LANM.PC_INFO SET USER_DEF_DATA = :h_achPcSpecUd, WORKSTN_LOCATION = :h_achPcSpecLoc, WORKSTN_TYPE = :h_achPcSpecType, WORKSTN_SER_NO = :h_achPcSpecSerNum, LSM_VER_NO = :h_chPcSpecLsmProgVer, OPERATING_SYSTEM = :h_achPcSpecOpSys, DISPLAYER_TYPE = :h_achPcSpecDspType, PRINTER_TYPE = :h_achPcSpecPntType, KEYBOARD_TYPE = :h_achPcSpecKbdType, DEVICE1_TYPE = :h_achPcSpecDvcTypeA, DEVICE2_TYPE = :h_achPcSpecDvcTypeB, DISPLAYER_SER_NO = :h_achPcSpecDspSerNum, PRINTER_SER_NO = :h_achPcSpecPntSerNum, KEYBOARD_SER_NO = :h_achPcSpecKbdSerNum, DEVICE1_SER_NO = :h_achPcSpecDvcSerNumA, DEVICE2_SER_NO = :h_achPcSpecDvcSerNumB, DISK_LIST = :h_achPcSpecDiskList, ADAPTER_LIST = :h_achPcSpecAdaptList, MACHINE_ROM_DATE = :h_achPcSpecRomDt, BASE_MEMORY = :h_lPcSpecBaseMem, EXTENDED_MEMORY = :h_lPcSpecExtMem, EXPANDED_MEMORY = :h_lPcSpecExpMem WHERE ADAPT_ADDR = :h_ach6AdaptAddr AND SEGMENT_NO = :h_ach6SegmentNo INSERT INTO LANM.PC_INFO ( ADAPT_ADDR, SEGMENT_NO, USER_DEF_DATA, WORKSTN_LOCATION, WORKSTN_TYPE, WORKSTN_SER_NO, LSM_VER_NO, OPERATING_SYSTEM, DISPLAYER_TYPE, PRINTER_TYPE, KEYBOARD_TYPE, DEVICE1_TYPE, DEVICE2_TYPE, DISPLAYER_SER_NO, PRINTER_SER_NO, KEYBOARD_SER_NO, DEVICE1_SER_NO, DEVICE2_SER_NO, DISK_LIST, ADAPTER_LIST, MACHINE_ROM_DATE, BASE_MEMORY, EXTENDED_MEMORY, EXPANDED_MEMORY ) VALUES ( :h_ach6AdaptAddr, :h_ach6SegmentNo, :h_achPcSpecUd, :h_achPcSpecLoc, :h_achPcSpecType, :h_achPcSpecSerNum, :h_chPcSpecLsmProgVer, :h_achPcSpecOpSys, :h_achPcSpecDspType, :h_achPcSpecPntType, :h_achPcSpecKbdType, :h_achPcSpecDvcTypeA, :h_achPcSpecDvcTypeB, :h_achPcSpecDspSerNum, :h_achPcSpecPntSerNum, :h_achPcSpecKbdSerNum, :h_achPcSpecDvcSerNumA, :h_achPcSpecDvcSerNumB, :h_achPcSpecDiskList, :h_achPcSpecAdaptList, :h_achPcSpecRomDt, :h_lPcSpecBaseMem, :h_lPcSpecExtMem, :h_lPcSpecExpMem ) UPDATE LANM.TR_ATTACH_DATA SET ADAPTER_NO = :h_chTrAttachAdapNum, WALL_FACEPLATE_LBL = :h_achTrAttachWallFaceLab, ACCESS_UNIT_LABEL = :h_achTrAttachAcuLabel, LOBE_RECEPTACLE_NO = :h_achTrAttachLobeRecepNum WHERE ADAPT_ADDR = :h_ach6AdaptAddr AND SEGMENT_NO = :h_ach6SegmentNo INSERT INTO LANM.TR_ATTACH_DATA ( ADAPT_ADDR, SEGMENT_NO, ADAPTER_NO, WALL_FACEPLATE_LBL, ACCESS_UNIT_LABEL, LOBE_RECEPTACLE_NO) VALUES ( :h_ach6AdaptAddr, :h_ach6SegmentNo, :h_chTrAttachAdapNum, :h_achTrAttachWallFaceLab, :h_achTrAttachAcuLabel, :h_achTrAttachLobeRecepNum) UPDATE LANM.PCNET_ATTACH_DATA SET ADAPTER_NO = :h_chPcNetAdapNum, CABLE_ID = :h_achPcNetCableID, ADAPTER_FREQ = :h_chPcNetFreq, SPLITTER_UNIT_ID = :h_achPcNetSplitID, SPLITTER_TAP_NO = :h_achPcNetSplitTpNum, DISTRIBUTION_LEG = :h_achPcNetDistLeg, TRANSLATOR_UNIT_ID = :h_achPcNetTransID, BASEBAND_UNIT_ID = :h_achPcNetExtID, BASEBAND_PORT_NO = :h_achPcNetExtPtNum WHERE ADAPT_ADDR = :h_ach6AdaptAddr AND SEGMENT_NO = :h_ach6SegmentNo INSERT INTO LANM.PCNET_ATTACH_DATA ( ADAPT_ADDR, SEGMENT_NO, ADAPTER_NO, CABLE_ID, ADAPTER_FREQ, SPLITTER_UNIT_ID, SPLITTER_TAP_NO, DISTRIBUTION_LEG, TRANSLATOR_UNIT_ID, BASEBAND_UNIT_ID, BASEBAND_PORT_NO) VALUES ( :h_ach6AdaptAddr, :h_ach6SegmentNo, :h_chPcNetAdapNum, :h_achPcNetCableID, :h_chPcNetFreq, :h_achPcNetSplitID, :h_achPcNetSplitTpNum, :h_achPcNetDistLeg, :h_achPcNetTransID, :h_achPcNetExtID, :h_achPcNetExtPtNum) h_achEventDate h_achEventTime h_achEventMessageNo h_achEventSegmentNo h_achEventAdaptAddr1 h_achEventVariableData1 h_achEventAdaptAddr2 h_achEventVariableData2 h_achEventVariableData3 h_fchEventHostFlag h_lEventReserved h_lEventSortNum h_lDetailsReserved h_Alert1Details h_Alert2Details h_achStatDefAdaptName h_achStatDefAdaptAddr h_fchStatDefTraceFlag h_fchStatDefMonitoredFlag h_achStatDefCauId h_chStatDefCauAttachModule h_usStatDefCauLobe h_achStatDefUserComment h_usStatDefDaysAuthorFrom h_usStatDefDaysAuthorTo h_usStatDefTimeAuthorFrom h_usStatDefTimeAuthorTo h_achStatListAdaptName h_achStatListAdaptAddr h_fchStatListTraceFlag h_fchStatListMonitoredFlag h_achStatListSegmentNo h_lStatRsvdRsvd h_achStatRsvdAdaptAddr h_achConfigAdaptAddr h_achConfigUniversalAddr h_achConfigSegmentNo h_usConfigSequenceNo h_lConfigFunctionalAddr h_achConfigGroupAddr h_fchConfigActiveFlag h_fchConfigCauFlag h_fchConfigCauAttachedFlag h_fchConfigPrevActiveFlag h_fchConfigAuthorizationFlag h_lConfigActiveTime h_fchConfigNotificationFlag h_fchConfigRegisteredFlag h_fchConfigRingUtFlag h_fchConfigEarlyTknRelease h_achConfigMicrocode h_achConfigListAdaptName h_achConfigListAdaptAddr h_lConfigListFunctionalAddr h_fchConfigListActiveFlag h_lConfigRsvdRsvd h_sConfigRsvdSequenceNo h_lFuncRsvdRsvd h_lFuncRsvdFunctionalAddr h_achFuncRsvdAdaptAddr h_fchStatProfTraceFlag h_fchStatProfMonitoredFlag h_fchStatProfActiveFlag h_achStatProfUserComment h_lStatProfFuncAddr h_achStatProfGroupAddr h_sStatProfSequenceNo h_fchStatProfRingUtFlag h_fchStatProfEarlyTknRelease h_achStatProfUnivAddr h_usSecurityDaysAuthorFrom h_usSecurityDaysAuthorTo h_usSecurityTimeAuthorFrom h_usSecurityTimeAuthorTo h_fchSecurityAuthorizationFlag h_fchFlagRecFlag h_achBridgeDefBridgeName h_chBridgeDefBridgeNo h_fchBridgeDefAutoLinkFlag h_achBridgeDefSegmentNo1 h_achBridgeDefSegment1Type h_achBridgeDefAdaptAddr1 h_achBridgeDefSegmentNo2 h_achBridgeDefSegment2Type h_achBridgeDefAdaptAddr2 h_achBridgeDefNotifInterval h_usBridgeDefNotificationRecs h_achBridgeDefComment h_chBridgeDefInternalUse h_achBridgeDefBridgeType h_achBrgNameBridgeName h_lBridgeRsvdRsvd h_achBridgeRsvdBridgeName h_achCauCauId h_achCauRingInAddr h_achCauRingOutAddr h_achCauSecondaryAddr h_achCauCommAddr h_achCauSegmentNo h_chCauModuleStatus1 h_chCauModuleStatus2 h_chCauModuleStatus3 h_chCauModuleStatus4 h_usCauCauStatus h_chCauBackupPathStatus h_achCauDiagErrCodeStatus h_achCauMicroCodeLevel h_achCauInternalUse h_chCauRegistrationFlag h_usCauSev1Ctr h_usCauSev2Ctr h_fchCauNotificationFlag h_achCauCauPassword h_achAddCauCauId h_achAddCauCommAddr h_achAddCauSegmentNo h_achAddCauCauPassword h_achAddCauRingOutAddr h_usCauNotifSev1Ctr h_usCauNotifSev2Ctr h_fchCauNotifNotificationFlag h_usCauNotifCauStatus h_achCauPwCauPassword h_usCauStatus h_achCauListCauId h_usCauListCauStatus h_achCauListSegmentNo h_chCauListRegistrationFlag h_fchCauListPrevActiveFlag h_achCauAddrsRingInAddr h_achCauAddrsRingOutAddr h_achCauAddrsSecondaryAddr h_achCauAddrsCommAddr h_achCauAddrsSegmentNo h_achCauAddrsMicroCodeLevel h_chCauAddrsRegistrationFlag h_achCauIdCauId h_chCauIdRegistrationFlag h_achCauLstMsmId h_usCauLstMsmStatus h_achCauLstMsmSegmentNo h_chCauLstMsmRegistrationFlag h_achCauLstMsmRInAddr h_achCauLstMsmROutAddr h_achCauLstMsmScndryAddr h_achBrgPrfBridgeName h_achBrgPrfTime h_achBrgPrfDate h_lBrgPrfIntervalSeconds h_achBrgPrfSegment1 h_achBrgPrfSegment2 h_chBrgPrfBridgeNum h_lBrgPrfBdgFramesForw1 h_dBrgPrfBdgBytesForw1 h_lBrgPrfNonBdgFramesForw1 h_dBrgPrfNonBdgBytesForw1 h_lBrgPrfFramesNotForwSegInOp1 h_lBrgPrfFramesNotForwCongest1 h_lBrgPrfFramesNotForwLinkErr1 h_dBrgPrfBytesNotForwLinkErr1 h_lBrgPrfFramesNotForwOther1 h_dBrgPrfFramesNrFilter1 h_lBrgPrfBdgFramesForw2 h_dBrgPrfBdgBytesForw2 h_lBrgPrfNonBdgFramesForw2 h_dBrgPrfNonBdgBytesForw2 h_lBrgPrfFramesNotForwSegInOp2 h_lBrgPrfFramesNotForwCongest2 h_lBrgPrfFramesNotForwLinkErr2 h_dBrgPrfBytesNotForwLinkErr2 h_lBrgPrfFramesNotForwOther2 h_dBrgPrfFramesNrFilter2 h_usBrgPrfSequenceNo h_lBrgPrfLongSeconds h_achBrgPf2BridgeName h_achBrgPf2Time h_achBrgPf2Date h_lBrgPf2IntervalSeconds h_achBrgPf2Segment1 h_achBrgPf2Segment2 h_chBrgPf2BridgeNum h_lBrgPf2BdgFramesForw1 h_dBrgPf2BdgBytesForw1 h_lBrgPf2NonBdgFramesForw1 h_dBrgPf2NonBdgBytesForw1 h_lBrgPf2FramesNotForwSegInOp1 h_lBrgPf2FramesNotForwCongest1 h_lBrgPf2FramesNotForwLinkErr1 h_dBrgPf2BytesNotForwLinkErr1 h_lBrgPf2FramesNotForwOther1 h_dBrgPf2FramesNrFilter1 h_lBrgPf2BdgFramesForw2 h_dBrgPf2BdgBytesForw2 h_lBrgPf2NonBdgFramesForw2 h_dBrgPf2NonBdgBytesForw2 h_lBrgPf2FramesNotForwSegInOp2 h_lBrgPf2FramesNotForwCongest2 h_lBrgPf2FramesNotForwLinkErr2 h_dBrgPf2BytesNotForwLinkErr2 h_lBrgPf2FramesNotForwOther2 h_dBrgPf2FramesNrFilter2 h_usBrgPf2SequenceNo h_lBrgPf2LongSeconds h_chGenericChar h_sGenericShort h_lGenericLong h_achCauseCauseText h_achSpcsSpcsText h_achAlrtAlertEbc h_achLabelText h_achSnz h_achProfileAdaptName h_achProfileAdaptAddr h_achProfileUniversalAddr h_achProfileSegmentNo h_usProfileSequenceNo h_lProfileFunctionalAddr h_achProfileGroupAddr h_fchProfileTraceFlag h_fchProfileMonitoredFlag h_fchProfileActiveFlag h_fchProfileRegisterFlag h_achProfileUserComment h_achProfileCauId h_chProfileCauAttachModule h_fchProfileCauAttachedFlag h_usProfileCauLobe h_usProfileDaysAuthorFrom h_usProfileDaysAuthorTo h_usProfileTimeAuthorFrom h_usProfileTimeAuthorTo h_usSpciCommandCommand h_usSpciCommandSubCommand h_achSpciCommandCommandText h_achSpciCommandConfirm h_usSpciParamsCommand h_usSpciParamsSubCommand h_usSpciParamsParmID h_achSpciParamsParmText h_usSpciParamsParmTyp h_achSpciParamsValueTyp h_usSpciParamsValMinSiz h_usSpciParamsValMaxSiz h_usSpciEnumsCommand h_usSpciEnumsSubCommand h_usSpciEnumsParmID h_usSpciEnumsEnumID h_achSpciEnumsEnumText h_chAlertFilterPriority h_chAlertFilterAlertBp h_achAlertFilterAlertId h_achAlertFilterResourceName h_chAlertFilterErrorType h_achMonitorAdaptAddr h_achMonitorSegmentNo h_fchMonitorMonitoredFlag h_bSysParmsAdaptNo h_usSysParmsDlcLinkStat h_bSysParmsAutoBdgLink h_usSysParmsAutoLinkTimeInt h_bSysParmsHostConnect h_bSysParmsTraceAuth h_bSysParmsAdaptMonitoring h_usSysParmsAdaptsMonitored h_usSysParmsMonitorRetries h_usSysParmsRemoteResTimeOut h_bSysParmsBeaconAutoRetry h_usSysParmsRetryTimeInterval h_usSysParmsNumOfRetries h_bSysParmsReportLinkNum h_achSysParmsReportLinkPw h_achSysParmsServicePointName h_achSysParmsLanName h_usSysParmsLogLimit h_lSysParmsBdgPerformLimit h_lSysParmsResyncTimeOut h_lSysParmsAgeOut h_bSysParmsLogNaunChanges h_achSysParmsConfigChanges h_bSysParmsSoftErrorReports h_achSysParmsUserFileName h_achSysParmsModuleName h_fchSysParmsAlrtProgStatus h_lSysParmsReserved h_bSysParmsAccessControl h_bSysParmsUnauthorizedAdap h_bSysParmsUnauthorizedTime h_bSysParmsAdapterMove h_bSysParmsInvalidBridge h_bSysParmsDisableLobe h_achSysParmsCAUPassword h_achSysParmsComment h_fchSysParmsLSMDataSaveFlag h_fchSysParmsGV2ModeFlag h_bRstSysParmsAdaptNo h_usRstSysParmsDlcLinkStat h_bRstSysParmsReportLinkNum h_usRstSysParmsLogLimit h_lRstSysParmsBdgPerformLimit h_bRstSysParmsHostConnect h_achRstSysParmsSPName h_achRstSysParmsComment h_fchCnfgChgConfigChangesFlag h_achCnfgChgSegmentNo h_fchInactActiveFlag h_lInactActiveTime h_fchActSeqActiveFlag h_sActSeqSequenceNo h_lActSeqActiveTime h_fchActSeqAuthActiveFlag h_sActSeqAuthSequenceNo h_fchActSeqAuthAuthorFlag h_lActSeqAuthActiveTime h_achLocationAdaptAddr h_achLocationCauId h_chLocationCauAttachModule h_usLocationCauLobe h_chLocationCauReportFlag h_achSProfUniversalAddr h_lSProfFunctionalAddr h_achSProfGroupAddr h_fchSProfActiveFlag h_fchSProfPrevActiveFlag h_fchSProfCauFlag h_fchSProfCauAttachedFlag h_fchSProfAuthorizationFlag h_lSProfActiveTime h_fchSProfEarlyTknRelease h_achSegSegmentNo h_achCauQSegmentNo h_achNaunAdaptAddr h_lCauRsvdRsvd h_usCauRsvdCauStatus h_fchCauFlagsCauFlag h_fchCauFlagsCauAttachedFlag h_fchCauSeqCauFlag h_fchCauSeqCauAttachedFlag h_fchCauSeqAuthorizationFlag h_sCauSeqSequenceNo h_achLobeLocAddCauId h_chLobeLocCauAddAttachModule h_usLobeLocCauAddLobe h_achLobeLocAddBuilding h_achLobeLocAddRoomNum h_achLobeLocBuilding h_achLobeLocRoomNum h_fchCauAttachCauAttachedFlag h_achCauAttachCauId h_achCauLocRoomNum h_achAddCauLocCauId h_achAddCauLocRoomNum h_achCommAddrCauId h_achCommAddrCommAddr h_fchConfigNotifActiveFlag h_fchConfigNotifNotifFlag h_achConfigViewAdaptName h_achConfigViewAdaptAddr h_fchConfigViewActiveFlag h_fchConfigViewCauFlag h_fchConfigViewCauAttachedFlag h_lConfigViewFunctionalAddr h_achCauViewAdaptName h_achCauViewAdaptAddr h_fchCauViewActiveFlag h_fchCauViewCauAttachModule h_usCauStatusCauStatus h_chCauStatusRegistrationFlag h_fchCauFlags2PrevActiveFlag h_chCauFlags2RegistrationFlag h_fchCauFlags2ResponseFlag h_achResponseSegmentNo h_usResponseExpectedResponses h_achLocation2AdaptAddr h_achLocation2CauId h_chLocation2CauAttachModule h_usLocation2CauLobe h_chLocation2CauReportFlag h_chLocation2FoundFlag h_achLocation3CauId h_chLocation3CauAttachModule h_usLocation3CauLobe h_fchLocation3Registration h_achSegTypeSegType h_achSegTypeSegLabel h_achPcSpecAdaptAddr h_achPcSpecSegmentNo h_achPcSpecUd h_achPcSpecLoc h_achPcSpecType h_achPcSpecSerNum h_chPcSpecLsmProgVer h_achPcSpecOpSys h_achPcSpecDspType h_achPcSpecPntType h_achPcSpecKbdType h_achPcSpecDvcTypeA h_achPcSpecDvcTypeB h_achPcSpecDspSerNum h_achPcSpecPntSerNum h_achPcSpecKbdSerNum h_achPcSpecDvcSerNumA h_achPcSpecDvcSerNumB h_achPcSpecDiskList h_achPcSpecAdaptList h_achPcSpecRomDt h_lPcSpecBaseMem h_lPcSpecExtMem h_lPcSpecExpMem h_achTrAttachAdaptAddr h_achTrAttachSegmentNo h_chTrAttachAdapNum h_achTrAttachWallFaceLab h_achTrAttachAcuLabel h_achTrAttachLobeRecepNum h_achPcNetAdaptAddr h_achPcNetSegmentNo h_chPcNetAdapNum h_achPcNetCableID h_chPcNetFreq h_achPcNetSplitID h_achPcNetSplitTpNum h_achPcNetDistLeg h_achPcNetTransID h_achPcNetExtID h_achPcNetExtPtNum h_achPosIdAdaptID h_achPosIdDescrip h_achElPrintfilename h_achCauModOrder h_achMsgTxtMessageNo h_achMsgTxtMessageText h_varsegslist h_vareventlist h_achEventFilterDescription h_fchEventFilterActive h_achEventFilterStartDate h_achEventFilterStartTime h_achEventFilterEndDate h_achEventFilterEndTime h_achEventFilterAdptAddr h_achEventFilterBridgeName h_achEventFilterCauId h_lEventFilterReserved h_achDisplayFilterDescription h_fchDisplayFilterActive h_lDisplayFilterReserved h_chUserFilterActiveFlag h_achUserFilterUserFilter h_lReservedStations h_lReservedIAUS h_lReservedEvents h_lReservedBridges h_sEventLogLimit h_lBridgePerfLimit h_ach3SegmentNo h_ach4SegmentNo h_fch4ActiveFlag h_ach5SegmentNo h_fc5ActiveFlag h_ach5ActiveDate h_ach5ActiveTime h_ach6SegmentNo h_ach6AdaptAddr h_ach7SegmentNo h_s7SequenceNo h_ach8SegmentNo h_us8SequenceNo h_ach9SegmentNo h_ach9ActiveDate h_ach9ActiveTime h_ach10CauId h_ach11SegmentNo h_us11CauStatus h_ach12BridgeName h_fch13Flag h_ach15StartDate h_ach15StartTime h_ach15EndDate h_ach15EndTime h_ach15AdaptAddr h_ach15MessageNo h_ach15SegmentNo h_ach15BridgeName h_ach16AdaptName h_ach17AdaptAddr h_ach17AdaptName h_l18CurrentSecs h_l18AgedOutSecs h_ach19AdaptAddr h_ach20TimeStamp h_ach21Time h_ach21Date h_ach21MsgNo h_ch22CauseType h_ach22CauseCode h_s23GenericShort h_s24GenericChar h_ch25Priority h_ch25AlertBp h_ach25AlertId h_ach25ResourceName h_ch25ErrorType h_l26GenericLong h_ach27SegmentNo h_us27SequenceNo1 h_us27SequenceNo2 h_fch28Link h_us28Intvl h_ach28SegmentNo h_ach31SegmentNo h_fch31TraceFlag h_fch31MonitoredFlag h_ach36SegmentNo h_fch36PrevActiveFlag h_ach37CauId h_ch37CauAttachModule h_ach39CauId h_ach39AdaptAddr h_ach40SegmentNo h_us40SequenceNo h_fch40ActiveFlag h_ach41CauId h_ch41CauAttachModule h_us41CauLobe h_ach42SegmentNo h_ach42AdaptAddr h_fch42ActiveFlag h_ach44BridgeName h_s44SequenceNo h_ach52AdaptID h_ach53SegmentNo h_fch53ActiveFlag h_fch53RingUtFlag h_ach54StartDate h_ach54StartTime h_ach54EndDate h_ach54EndTime h_ach54BridgeName h_ach55SegmentNo h_ach55AdaptAddr h_ach55CauId h_ach55BridgeName h_l56TimeSlot h_s56Interval h_ach56BridgeName h_ach57msgno hlcount h_Reserved hacBridgeNameSv hacSegmentNoSv hsSequenceNoSv h_ClearBit h_caupwEncrypt h_bridgepwEncrypt