DFIDBCNTaBFTOdDKUSERID  0
BEGIN DECLARE SECTION
END DECLARE SECTION
SELECT COUNT (*)                                                                  INTO :hsCount                    FROM LANM.CONFIGURATION                                                    WHERE SEGMENT_NO = :hacSegmentNo
SELECT COUNT (*)                    INTO :hsCount                    FROM LANM.BRIDGE_DEFINITIONS
SELECT COUNT (*)                    INTO :hsCount                    FROM LANM.BRIDGE_DEFINITIONS                    WHERE AUTOLINK_FLAG = :hfch1
SELECT COUNT (*)                    INTO :hsCount                    FROM LANM.CAU
SELECT COUNT (*)                    INTO :hsCount                    FROM LANM.STATION_DEFINITION                    WHERE MONITORED_FLAG = :hfch1
SELECT COUNT (*)                    INTO :hsCount                    FROM LANM.BRIDGE_PERFORMANCE                    WHERE BRIDGE_NAME =  :hacBridgeName
SELECT COUNT (*)                    INTO :hsCount                    FROM LANM.BRIDGE_PERFORMANCE                    WHERE BRIDGE_NAME =  :hacBridgeName                      AND PERFORM_DATE BETWEEN :hacStartDate AND :hacEndDate
SELECT COUNT (*)                       INTO :hs1                       FROM LANM.BRIDGE_PERFORMANCE                       WHERE BRIDGE_NAME =  :hacBridgeName                         AND PERFORM_TIME < :hacStartTime                         AND PERFORM_DATE = :hacStartDate
SELECT COUNT (*)                       INTO :hs2                       FROM LANM.BRIDGE_PERFORMANCE                       WHERE BRIDGE_NAME =  :hacBridgeName                         AND PERFORM_TIME > :hacEndTime                         AND PERFORM_DATE = :hacEndDate
SELECT COUNT (*)                    INTO :hsCount                    FROM LANM.MESSAGE_TEXT
SELECT COUNT (*)                                  INTO :hsCount                                  FROM LANM.CONFIGURATION                                  WHERE SEGMENT_NO = :hach3_1 AND                                          SEQUENCE_NO <= :hs1
COMMIT
hfch1
hach3_1
hacSegmentNo
hacBridgeName
hacStartTime
hacEndTime
hacStartDate
hacEndDate
hsCount