VIEW: SYS.EXPTABSUBPART

Source

View Text - Preformatted

SELECT
              tsp.obj#                                                 OBJNO,
              tsp.pobj#                                                POBJNO,
              row_number() OVER
                   (partition by tsp.pobj# order by tsp.subpart#) - 1  SUBPARTNO,
              bhiboundval                                              BHIBOUNDVAL,
              ts#                                                      TSNO
        FROM sys.tabsubpart$ tsp

View Text - HTML Formatted

SELECT TSP.OBJ# OBJNO
, TSP.POBJ# POBJNO
, ROW_NUMBER() OVER (PARTITION BY TSP.POBJ# ORDER BY TSP.SUBPART#) - 1 SUBPARTNO
, BHIBOUNDVAL BHIBOUNDVAL
, TS# TSNO
FROM SYS.TABSUBPART$ TSP