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 / DFIDBCNT.BND (.txt) < prev    next >
DB2 Bind  |  1994-03-29  |  3KB  |  25 lines
  1. DFIDBCNTaBFTOdDKUSERID  0
  2. BEGIN DECLARE SECTION
  3. END DECLARE SECTION
  4. SELECT COUNT (*)                                                                  INTO :hsCount                    FROM LANM.CONFIGURATION                                                    WHERE SEGMENT_NO = :hacSegmentNo
  5. SELECT COUNT (*)                    INTO :hsCount                    FROM LANM.BRIDGE_DEFINITIONS
  6. SELECT COUNT (*)                    INTO :hsCount                    FROM LANM.BRIDGE_DEFINITIONS                    WHERE AUTOLINK_FLAG = :hfch1
  7. SELECT COUNT (*)                    INTO :hsCount                    FROM LANM.CAU
  8. SELECT COUNT (*)                    INTO :hsCount                    FROM LANM.STATION_DEFINITION                    WHERE MONITORED_FLAG = :hfch1
  9. SELECT COUNT (*)                    INTO :hsCount                    FROM LANM.BRIDGE_PERFORMANCE                    WHERE BRIDGE_NAME =  :hacBridgeName
  10. SELECT COUNT (*)                    INTO :hsCount                    FROM LANM.BRIDGE_PERFORMANCE                    WHERE BRIDGE_NAME =  :hacBridgeName                      AND PERFORM_DATE BETWEEN :hacStartDate AND :hacEndDate
  11. SELECT COUNT (*)                       INTO :hs1                       FROM LANM.BRIDGE_PERFORMANCE                       WHERE BRIDGE_NAME =  :hacBridgeName                         AND PERFORM_TIME < :hacStartTime                         AND PERFORM_DATE = :hacStartDate
  12. SELECT COUNT (*)                       INTO :hs2                       FROM LANM.BRIDGE_PERFORMANCE                       WHERE BRIDGE_NAME =  :hacBridgeName                         AND PERFORM_TIME > :hacEndTime                         AND PERFORM_DATE = :hacEndDate
  13. SELECT COUNT (*)                    INTO :hsCount                    FROM LANM.MESSAGE_TEXT
  14. SELECT COUNT (*)                                  INTO :hsCount                                  FROM LANM.CONFIGURATION                                  WHERE SEGMENT_NO = :hach3_1 AND                                          SEQUENCE_NO <= :hs1
  15. COMMIT
  16. hfch1
  17. hach3_1
  18. hacSegmentNo
  19. hacBridgeName
  20. hacStartTime
  21. hacEndTime
  22. hacStartDate
  23. hacEndDate
  24. hsCount
  25.