IBM Presents OS/2 Software Hits 1995

home *** CD-ROM | disk | FTP | other *** search

/ IBM Presents OS/2 Software Hits 1995 / OS-2_SW_HITS_2ND_EDITION_1995.ISO / i17 / ur423841.dsk / CSD1.DFI / DFIDBGT2.BND (.txt) < prev next >

Wrap

DB2 Bind | 1994-03-29 | 44KB | 610 lines

DFIDBGT2vAuPOdDKUSERID 0 BEGIN DECLARE SECTION END DECLARE SECTION BEGIN DECLARE SECTION END DECLARE SECTION SELECT EVENT_TIME, EVENT_DATE, MESSAGE_NO, HOST_FLAG, SEGMENT_NO, ADAPT_ADDR1, VARIABLE_DATA1, ADAPT_ADDR2, VARIABLE_DATA2, VARIABLE_DATA3 INTO :h_achEventTime:hni1, :h_achEventDate:hni1, :h_achEventMessageNo:hni1, :h_fchEventHostFlag:hni1, :h_achEventSegmentNo:hni1, :h_achEventAdaptAddr1:hni1, :h_achEventVariableData1:hni1, :h_achEventAdaptAddr2:hni1, :h_achEventVariableData2:hni1, :h_achEventVariableData3:hni1 FROM LANM.EVENT_LOG WHERE RESERVED = :h_l26GenericLong SELECT SEGMENT_NO, EXPECTED_RESPONSES INTO :h_achResponseSegmentNo:hni1, :h_usResponseExpectedResponses:hni1 FROM LANM.CAU WHERE CAU_ID = :h_ach10CauId SELECT SEV1_COUNTER, SEV2_COUNTER, NOTIFICATION_FLAG, CAU_STATUS INTO :h_usCauNotifSev1Ctr:hni1, :h_usCauNotifSev2Ctr:hni1, :h_fchCauNotifNotificationFlag:hni1, :h_usCauNotifCauStatus:hni1 FROM LANM.CAU WHERE CAU_ID = :h_ach10CauId SELECT CAU_PASSWORD INTO :h_achCauPwCauPassword:hni1 FROM LANM.CAU WHERE CAU_ID = :h_ach10CauId SELECT CAU_ID, REGISTRATION_FLAG INTO :h_achCauIdCauId:hni1, :h_chCauIdRegistrationFlag:hni1 FROM LANM.CAU WHERE RESERVED = :h_l26GenericLong SELECT RESERVED INTO :h_lGenericLong FROM LANM.CAU WHERE CAU_ID = :h_ach10CauId SELECT CAU_STATUS INTO :h_usCauStatusCauStatus:hni1 FROM LANM.CAU WHERE CAU_ID = :h_ach10CauId SELECT SEGMENT_NO INTO :h_achSegSegmentNo:hni1 FROM LANM.CAU WHERE CAU_ID = :h_ach10CauId SELECT CAU_ATTACH_MODULE, CAU_LOBE, CAU_ID INTO :h_chLocationCauAttachModule, :h_usLocationCauLobe, :h_achLocationCauId FROM LANM.LOCATION_DEF WHERE CAU_ID = :h_ach39CauId AND ADAPT_ADDR = :h_ach39AdaptAddr SELECT LD.CAU_ID, CAU_ATTACH_MODULE, CAU_LOBE INTO :h_achLocationCauId:hni1, :h_chLocationCauAttachModule:hni1, :h_usLocationCauLobe:hni1 FROM LANM.LOCATION_DEF LD, LANM.CAU CU WHERE LD.CAU_ID = CU.CAU_ID AND CU.SEGMENT_NO = :h_ach6SegmentNo AND LD.ADAPT_ADDR = :h_ach6AdaptAddr SELECT BUILDING, ROOM_NUMBER INTO :h_achLobeLocBuilding:hni1, :h_achLobeLocRoomNum:hni1 FROM LANM.CAU_LOBE_LOCATION WHERE CAU_ID = :h_ach41CauId AND CAU_ATTACH_MODULE = :h_ch41CauAttachModule AND CAU_LOBE = :h_us41CauLobe SELECT CAU_ID, COMM_ADDR INTO :h_achCommAddrCauId:hni1, :h_achCommAddrCommAddr:hni1 FROM LANM.CAU WHERE RING_IN_ADDR = :h_ach19AdaptAddr OR RING_OUT_ADDR = :h_ach19AdaptAddr OR SECONDARY_ADDR = :h_ach19AdaptAddr SELECT RING_OUT_ADDR, COMM_ADDR, SEGMENT_NO INTO :h_achAddCauRingOutAddr:hni1, :h_achAddCauCommAddr:hni1, :h_achAddCauSegmentNo:hni1 FROM LANM.CAU WHERE CAU_ID = :h_ach10CauId SELECT REGISTRATION_FLAG, RESPONSE_FLAG INTO :h_chCauFlags2RegistrationFlag:hni1, :h_fchCauFlags2ResponseFlag:hni1 FROM LANM.CAU WHERE CAU_ID = :h_ach10CauId SELECT RING_IN_ADDR, RING_OUT_ADDR, SECONDARY_ADDR, COMM_ADDR, SEGMENT_NO, CAU_STATUS, MODULE1_STATUS, MODULE2_STATUS, MODULE3_STATUS, MODULE4_STATUS, BACKUP_PATH_STATUS, DIAG_ERROR_CODE, MICROCODE_LEVEL, REGISTRATION_FLAG, SEV1_COUNTER, SEV2_COUNTER, NOTIFICATION_FLAG, CAU_PASSWORD INTO :h_achCauRingInAddr:hni1, :h_achCauRingOutAddr:hni1, :h_achCauSecondaryAddr:hni1, :h_achCauCommAddr:hni1, :h_achCauSegmentNo:hni1, :h_usCauCauStatus:hni1, :h_chCauModuleStatus1:hni1, :h_chCauModuleStatus2:hni1, :h_chCauModuleStatus3:hni1, :h_chCauModuleStatus4:hni1, :h_chCauBackupPathStatus:hni1, :h_achCauDiagErrCodeStatus:hni1, :h_achCauMicroCodeLevel:hni1, :h_chCauRegistrationFlag:hni1, :h_usCauSev1Ctr:hni1, :h_usCauSev2Ctr:hni1, :h_fchCauNotificationFlag:hni1, :h_achCauCauPassword:hni1 FROM LANM.CAU WHERE CAU_ID = :h_ach10CauId SELECT CAU_ID, CAU_STATUS, SEGMENT_NO, REGISTRATION_FLAG INTO :h_achCauListCauId:hni1, :h_usCauListCauStatus:hni1, :h_achCauListSegmentNo:hni1, :h_chCauListRegistrationFlag:hni1 FROM LANM.CAU WHERE RESERVED = :h_l26GenericLong SELECT CAU_ID, CAU_STATUS, SEGMENT_NO, REGISTRATION_FLAG, RING_IN_ADDR, RING_OUT_ADDR, SECONDARY_ADDR INTO :h_achCauLstMsmId:hni1, :h_usCauLstMsmStatus:hni1, :h_achCauLstMsmSegmentNo:hni1, :h_chCauLstMsmRegistrationFlag:hni1, :h_achCauLstMsmRInAddr:hni1, :h_achCauLstMsmROutAddr:hni1, :h_achCauLstMsmScndryAddr:hni1 FROM LANM.CAU WHERE RESERVED = :h_l26GenericLong SELECT ROOM_NUMBER INTO :h_achCauLocRoomNum:hni1 FROM LANM.CAU WHERE CAU_ID = :h_ach10CauId SELECT CAU_ID INTO :h_achCauAttachCauId:hni1 FROM LANM.LOCATION_DEF WHERE ADAPT_ADDR = :h_ach42AdaptAddr SELECT CAU_ID INTO :h_achCauAttachCauId:hni1 FROM LANM.LOCATION_DEF WHERE ADAPT_ADDR = :h_ach19AdaptAddr SELECT RESERVED INTO :h_lGenericLong FROM LANM.STATION_DEFINITION WHERE ADAPT_ADDR = :h_ach19AdaptAddr SELECT ADAPT_NAME, ADAPT_ADDR, MONITORED_FLAG, TRACE_FLAG INTO :h_achStatListAdaptName, :h_achStatListAdaptAddr:hni1, :h_fchStatListMonitoredFlag:hni1, :h_fchStatListTraceFlag:hni1 FROM LANM.STATION_DEFINITION WHERE ADAPT_ADDR = :h_ach19AdaptAddr SELECT ADAPT_NAME, ADAPT_ADDR, MONITORED_FLAG, TRACE_FLAG INTO :h_achStatListAdaptName, :h_achStatListAdaptAddr:hni1, :h_fchStatListMonitoredFlag:hni1, :h_fchStatListTraceFlag:hni1 FROM LANM.STATION_DEFINITION WHERE RESERVED = :h_l26GenericLong SELECT ADAPT_ADDR, '0', '0', CAU_ATTACHED_FLAG INTO :h_achStatDefAdaptAddr:hni1, :h_fchStatDefTraceFlag, :h_fchStatDefMonitoredFlag, :h_attached FROM LANM.CONFIGURATION WHERE RESERVED = :h_l26GenericLong SELECT CAU_ID, CAU_ATTACH_MODULE, CAU_LOBE INTO :h_achStatDefCauId:hni1, :h_chStatDefCauAttachModule:hni1, :h_usStatDefCauLobe:hni1 FROM LANM.LOCATION_DEF WHERE ADAPT_ADDR = :h_achStatDefAdaptAddr SELECT RESERVED INTO :h_lGenericLong FROM LANM.CONFIGURATION WHERE ADAPT_ADDR = :h_ach6AdaptAddr AND SEGMENT_NO = :h_ach6SegmentNo SELECT ADAPT_NAME, ADAPT_ADDR, USER_COMMENT, MONITORED_FLAG, TRACE_FLAG, DAYS_AUTHOR_FROM, DAYS_AUTHOR_TO, TIME_AUTHOR_FROM, TIME_AUTHOR_TO INTO :h_achStatDefAdaptName:hni1, :h_achStatDefAdaptAddr:hni1, :h_achStatDefUserComment:hni1, :h_fchStatDefMonitoredFlag:hni1, :h_fchStatDefTraceFlag:hni1, :h_usStatDefDaysAuthorFrom:hni1, :h_usStatDefDaysAuthorTo:hni1, :h_usStatDefTimeAuthorFrom:hni1, :h_usStatDefTimeAuthorTo:hni1 FROM LANM.STATION_DEFINITION WHERE ADAPT_NAME = :h_ach16AdaptName SELECT CAU_ID, CAU_ATTACH_MODULE, CAU_LOBE INTO :h_achStatDefCauId:hni1, :h_chStatDefCauAttachModule:hni1, :h_usStatDefCauLobe:hni1 FROM LANM.LOCATION_DEF WHERE ADAPT_ADDR = :h_achStatDefAdaptAddr SELECT ADAPT_ADDR, USER_COMMENT, ADAPT_NAME, MONITORED_FLAG, TRACE_FLAG, DAYS_AUTHOR_FROM, DAYS_AUTHOR_TO, TIME_AUTHOR_FROM, TIME_AUTHOR_TO INTO :h_achStatDefAdaptAddr:hni1, :h_achStatDefUserComment:hni1, :h_achStatDefAdaptName:hni1, :h_fchStatDefMonitoredFlag:hni1, :h_fchStatDefTraceFlag:hni1, :h_usStatDefDaysAuthorFrom:hni1, :h_usStatDefDaysAuthorTo:hni1, :h_usStatDefTimeAuthorFrom:hni1, :h_usStatDefTimeAuthorTo:hni1 FROM LANM.STATION_DEFINITION WHERE RESERVED = :h_l26GenericLong SELECT CAU_ID, CAU_ATTACH_MODULE, CAU_LOBE INTO :h_achStatDefCauId:hni1, :h_chStatDefCauAttachModule:hni1, :h_usStatDefCauLobe:hni1 FROM LANM.LOCATION_DEF WHERE ADAPT_ADDR = :h_achStatDefAdaptAddr SELECT DAYS_AUTHOR_FROM, DAYS_AUTHOR_TO, TIME_AUTHOR_FROM, TIME_AUTHOR_TO INTO :h_usSecurityDaysAuthorFrom:hni1, :h_usSecurityDaysAuthorTo:hni1, :h_usSecurityTimeAuthorFrom:hni1, :h_usSecurityTimeAuthorTo:hni1 FROM LANM.STATION_DEFINITION WHERE ADAPT_ADDR = :h_ach19AdaptAddr SELECT DAYS_AUTHOR_FROM, DAYS_AUTHOR_TO, TIME_AUTHOR_FROM, TIME_AUTHOR_TO INTO :h_usSecurityDaysAuthorFrom:hni1, :h_usSecurityDaysAuthorTo:hni1, :h_usSecurityTimeAuthorFrom:hni1, :h_usSecurityTimeAuthorTo:hni1 FROM LANM.STATION_DEFINITION WHERE ADAPT_ADDR = :h_ach6AdaptAddr SELECT AUTHORIZATION_FLAG INTO :h_fchSecurityAuthorizationFlag:hni1 FROM LANM.CONFIGURATION WHERE ADAPT_ADDR = :h_ach6AdaptAddr AND SEGMENT_NO = :h_ach6SegmentNo SELECT FUNCTIONAL_ADDR, GROUP_ADDR, SEQUENCE_NO, UNIVERSAL_ADDR INTO :h_lStatProfFuncAddr:hni1, :h_achStatProfGroupAddr:hni1, :h_sStatProfSequenceNo:hni1, :h_achStatProfUnivAddr:hni1 FROM LANM.CONFIGURATION WHERE ADAPT_ADDR = :h_ach6AdaptAddr AND SEGMENT_NO = :h_ach6SegmentNo DECLARE nauns CURSOR WITH HOLD FOR SELECT ADAPT_ADDR, SEQUENCE_NO FROM LANM.CONFIGURATION WHERE SEGMENT_NO = :h_ach40SegmentNo AND SEQUENCE_NO > :h_us40SequenceNo ORDER BY SEQUENCE_NO ASC FOR FETCH ONLY OPEN nauns FETCH nauns INTO :h_achNaunAdaptAddr:hni1 CLOSE nauns SELECT ADAPT_ADDR INTO :h_achNaunAdaptAddr:hni1 FROM LANM.CONFIGURATION WHERE SEGMENT_NO = :h_ach40SegmentNo AND SEQUENCE_NO = :h_us40SequenceNo SELECT FUNCTIONAL_ADDR, ADAPT_ADDR INTO :h_lConfigListFunctionalAddr:hni1, :h_achConfigListAdaptAddr:hni1 FROM LANM.CONFIGURATION WHERE RESERVED = :h_l26GenericLong SELECT ADAPT_NAME INTO :h_achConfigListAdaptName:hni1 FROM LANM.STATION_DEFINITION WHERE ADAPT_ADDR = :h_achConfigListAdaptAddr SELECT AUTHORIZATION_FLAG, SEQUENCE_NO INTO :h_fchCauSeqAuthorizationFlag:hni1, :h_sCauSeqSequenceNo:hni1 FROM LANM.CONFIGURATION WHERE ADAPT_ADDR = :h_ach6AdaptAddr AND SEGMENT_NO = :h_ach6SegmentNo SELECT UNIVERSAL_ADDR, SEQUENCE_NO, FUNCTIONAL_ADDR, GROUP_ADDR, AUTHORIZATION_FLAG, ACTIVE_TIME, CAU_ATTACHED_FLAG INTO :h_achConfigUniversalAddr:hni1, :h_usConfigSequenceNo:hni1, :h_lConfigFunctionalAddr:hni1, :h_achConfigGroupAddr:hni1, :h_fchConfigAuthorizationFlag:hni1, :h_lConfigActiveTime:hni1, :h_fchConfigCauAttachedFlag FROM LANM.CONFIGURATION WHERE ADAPT_ADDR = :h_ach6AdaptAddr AND SEGMENT_NO = :h_ach6SegmentNo SELECT SEQUENCE_NO INTO :h_sActSeqSequenceNo:hni1 FROM LANM.CONFIGURATION WHERE ADAPT_ADDR = :h_ach6AdaptAddr AND SEGMENT_NO = :h_ach6SegmentNo SELECT SEQUENCE_NO, AUTHORIZATION_FLAG INTO :h_sActSeqAuthSequenceNo:hni1, :h_fchActSeqAuthAuthorFlag:hni1 FROM LANM.CONFIGURATION WHERE ADAPT_ADDR = :h_ach6AdaptAddr AND SEGMENT_NO = :h_ach6SegmentNo SELECT AUTHORIZATION_FLAG INTO :h_fchFlagRecFlag:hni1 FROM LANM.CONFIGURATION WHERE ADAPT_ADDR = :h_ach6AdaptAddr AND SEGMENT_NO = :h_ach6SegmentNo SELECT CAUSE_TEXT INTO :h_achCauseCauseText FROM LANM.ALERT_CAUSES_TEXT WHERE CAUSE_CODE = :h_ach22CauseCode AND CAUSE_TYPE = :h_ch22CauseType SELECT ALERT_DETAILS1, ALERT_DETAILS2 INTO :h_Alert1Details:hni1, :h_Alert2Details:hni1 FROM LANM.ALERT_DETAILS WHERE RESERVED = :h_l26GenericLong SELECT ADAPT_NO, DLC_LINK_STATION, AUTO_BDG_LINK, AUTO_LINK_TIME_INT, HOST_CONNECTION, TRACING_AUTH, ADAPT_MONITORING, ADAPTS_MONITORED, NUM_MONITOR_RETRY, REM_RESP_TIMEOUT, BEACON_AUTO_RETRY, RETRY_INTERVAL, NUM_RETRIES, REPORT_LINK_NO, REPORT_LINK_PW, SERVICE_PT_NAME, LAN_NAME, EVENT_LOG_LIMIT, BDG_PERFORM_LIMIT, RESYNC_INTERVAL, AGE_OUT, NAUN_CHANGES_FLAG, NAUN_CHANGES_SEG, ALERT_FILTER_DLL, ALERT_PGM_MODULE, ALERT_PGM_STATUS, USER_COMMENT, ACCESS_CONT_FLAG, UNAUTHORIZED_ADAPT, UNAUTHORIZED_TIME, UNAUTHORIZED_MOVE, UNAUTHORIZED_BRG, ADAPTER_REMOVAL, CAU_PASSWORD, LSM_DATA_SAVE_FLAG INTO :h_bSysParmsAdaptNo:hni1, :h_usSysParmsDlcLinkStat:hni1, :h_bSysParmsAutoBdgLink:hni1, :h_usSysParmsAutoLinkTimeInt:hni1, :h_bSysParmsHostConnect:hni1, :h_bSysParmsTraceAuth:hni1, :h_bSysParmsAdaptMonitoring:hni1, :h_usSysParmsAdaptsMonitored:hni1, :h_usSysParmsMonitorRetries:hni1, :h_usSysParmsRemoteResTimeOut:hni1, :h_bSysParmsBeaconAutoRetry:hni1, :h_usSysParmsRetryTimeInterval:hni1, :h_usSysParmsNumOfRetries:hni1, :h_bSysParmsReportLinkNum:hni1, :h_achSysParmsReportLinkPw:hni1, :h_achSysParmsServicePointName:hni1, :h_achSysParmsLanName:hni1, :h_usSysParmsLogLimit:hni1, :h_lSysParmsBdgPerformLimit:hni1, :h_lSysParmsResyncTimeOut:hni1, :h_lSysParmsAgeOut:hni1, :h_bSysParmsLogNaunChanges:hni1, :h_achSysParmsConfigChanges:hni1, :h_achSysParmsUserFileName:hni1, :h_achSysParmsModuleName:hni1, :h_fchSysParmsAlrtProgStatus:hni1, :h_achSysParmsComment:hni1, :h_bSysParmsAccessControl:hni1, :h_bSysParmsUnauthorizedAdap:hni1, :h_bSysParmsUnauthorizedTime:hni1, :h_bSysParmsAdapterMove:hni1, :h_bSysParmsInvalidBridge:hni1, :h_bSysParmsDisableLobe:hni1, :h_achSysParmsCAUPassword:hni1, :h_fchSysParmsLSMDataSaveFlag:hni1 FROM LANM.SYSTEM_PARAMETERS SELECT HOST_CONNECTION, ADAPT_NO, DLC_LINK_STATION, REPORT_LINK_NO, SERVICE_PT_NAME, EVENT_LOG_LIMIT, BDG_PERFORM_LIMIT, USER_COMMENT INTO :h_bRstSysParmsHostConnect:hni1, :h_bRstSysParmsAdaptNo:hni1, :h_usRstSysParmsDlcLinkStat:hni1, :h_bRstSysParmsReportLinkNum:hni1, :h_achRstSysParmsSPName:hni1, :h_usRstSysParmsLogLimit:hni1, :h_lRstSysParmsBdgPerformLimit:hni1, :h_achRstSysParmsComment:hni1 FROM LANM.SYSTEM_PARAMETERS SELECT USER_DEF_DATA, LSM_VER_NO, OPERATING_SYSTEM, WORKSTN_LOCATION, WORKSTN_TYPE, WORKSTN_SER_NO, DISPLAYER_TYPE, DISPLAYER_SER_NO, PRINTER_TYPE, PRINTER_SER_NO, KEYBOARD_TYPE, KEYBOARD_SER_NO, DEVICE1_TYPE, DEVICE1_SER_NO, DEVICE2_TYPE, DEVICE2_SER_NO, ADAPTER_LIST, DISK_LIST, MACHINE_ROM_DATE, BASE_MEMORY, EXTENDED_MEMORY, EXPANDED_MEMORY INTO :h_achPcSpecUd:hni1, :h_chPcSpecLsmProgVer:hni1, :h_achPcSpecOpSys:hni1, :h_achPcSpecLoc:hni1, :h_achPcSpecType:hni1, :h_achPcSpecSerNum:hni1, :h_achPcSpecDspType:hni1, :h_achPcSpecDspSerNum:hni1, :h_achPcSpecPntType:hni1, :h_achPcSpecPntSerNum:hni1, :h_achPcSpecKbdType:hni1, :h_achPcSpecKbdSerNum:hni1, :h_achPcSpecDvcTypeA:hni1, :h_achPcSpecDvcSerNumA:hni1, :h_achPcSpecDvcTypeB:hni1, :h_achPcSpecDvcSerNumB:hni1, :h_achPcSpecAdaptList:hni1, :h_achPcSpecDiskList:hni1, :h_achPcSpecRomDt:hni1, :h_lPcSpecBaseMem:hni1, :h_lPcSpecExtMem:hni1, :h_lPcSpecExpMem:hni1 FROM LANM.PC_INFO WHERE ADAPT_ADDR = :h_ach6AdaptAddr AND SEGMENT_NO = :h_ach6SegmentNo SELECT ADAPTER_NO, WALL_FACEPLATE_LBL, ACCESS_UNIT_LABEL, LOBE_RECEPTACLE_NO INTO :h_chTrAttachAdapNum:hni1, :h_achTrAttachWallFaceLab:hni1, :h_achTrAttachAcuLabel:hni1, :h_achTrAttachLobeRecepNum:hni1 FROM LANM.TR_ATTACH_DATA WHERE ADAPT_ADDR = :h_ach6AdaptAddr AND SEGMENT_NO = :h_ach6SegmentNo SELECT ADAPTER_NO, CABLE_ID, ADAPTER_FREQ, SPLITTER_UNIT_ID, SPLITTER_TAP_NO, DISTRIBUTION_LEG, TRANSLATOR_UNIT_ID, BASEBAND_UNIT_ID, BASEBAND_PORT_NO INTO :h_chPcNetAdapNum:hni1, :h_achPcNetCableID:hni1, :h_chPcNetFreq:hni1, :h_achPcNetSplitID:hni1, :h_achPcNetSplitTpNum:hni1, :h_achPcNetDistLeg:hni1, :h_achPcNetTransID:hni1, :h_achPcNetExtID:hni1, :h_achPcNetExtPtNum:hni1 FROM LANM.PCNET_ATTACH_DATA WHERE ADAPT_ADDR = :h_ach6AdaptAddr AND SEGMENT_NO = :h_ach6SegmentNo SELECT DESCRIPTION INTO :h_achPosIdDescrip:hni1 FROM LANM.POS_IDS WHERE ADAPTER_ID = :h_ach52AdaptID SELECT EL_FILENAME INTO :h_achElPrintfilename FROM LANM.SYSTEM_PARAMETERS SELECT DESCRIPTION, ACTIVE_FLAG, START_DATE, START_TIME, END_DATE, END_TIME, ADAPTER_ADDR, BRIDGE_NAME, CAU_ID, SEGMENT_LIST, EVENT_LIST, RESERVED INTO :h_achEventFilterDescription:hni1, :h_fchEventFilterActive:hni1, :h_achEventFilterStartDate:hni1, :h_achEventFilterStartTime:hni1, :h_achEventFilterEndDate:hni1, :h_achEventFilterEndTime:hni1, :h_achEventFilterAdptAddr:hni1, :h_achEventFilterBridgeName:hni1, :h_achEventFilterCauId:hni1, :h_varsegslist:hni1, :h_vareventlist:hni1, :h_lEventFilterReserved FROM LANM.EVENT_FILTERS WHERE RESERVED = :h_l26GenericLong SELECT MSG_TEXT INTO :h_achMsgTxtMessageText:hni1 FROM LANM.MESSAGE_TEXT WHERE MSG_NO = :h_ach57msgno 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 h_attached