text: CREATE VIEW HISTOGRAMSERVICECLASSES AS
    SELECT DISTINCT SUBSTR(HISTOGRAM_TYPE,1,24) AS HISTOGRAM_TYPE,
           SUBSTR(PARENTSERVICECLASSNAME,1,24) AS SERVICE_SUPERCLASS,
           SUBSTR(SERVICECLASSNAME,1,24) AS SERVICE_SUBCLASS
    FROM HISTOGRAMBIN_DB2STATISTICS AS H,
         SYSCAT.SERVICECLASSES AS S
    WHERE H.SERVICE_CLASS_ID = S.SERVICECLASSID
  