VIEW: SYS.KU$_SUBLOBFRAG_VIEW

Source

View Text - Preformatted

select lf.fragobj#, lf.parentobj#, lf.tabfragobj#,
        l.obj#, l.intcol#, lf.frag#,
        (select value(o) from ku$_schemaobj_view o
         where o.obj_num = lf.fragobj#),
        (select value(s) from ku$_storage_view s
         where s.file_num  = lf.file#
         and   s.block_num = lf.block#
         and   s.ts_num    = lf.ts#),
        (select value(s) from ku$_deferred_stg_view s
         where s.obj_num = lf.fragobj#),
        (select ts.name from ts$ ts where lf.ts# = ts.ts#),
        (select ts.blocksize from ts$ ts where lf.ts# = ts.ts#),
        lf.indfragobj#,
        (select value(i) from ku$_sublobfragindex_view i
                 where i.obj_num=lf.indfragobj#),
        lf.chunk, lf.pctversion$, lf.fragflags, lf.fragpro,
        lf.spare1, lf.spare2, lf.spare3
  from  lob$ l, lobcomppart$ lc, lobfrag$ lf
        where lc.partobj#=lf.parentobj#
          and l.lobj#=lc.lobj#

View Text - HTML Formatted

SELECT LF.FRAGOBJ#
, LF.PARENTOBJ#
, LF.TABFRAGOBJ#
, L.OBJ#
, L.INTCOL#
, LF.FRAG#
, (SELECT VALUE(O)
FROM KU$_SCHEMAOBJ_VIEW O
WHERE O.OBJ_NUM = LF.FRAGOBJ#)
, (SELECT VALUE(S)
FROM KU$_STORAGE_VIEW S
WHERE S.FILE_NUM = LF.FILE#
AND S.BLOCK_NUM = LF.BLOCK#
AND S.TS_NUM = LF.TS#)
, (SELECT VALUE(S)
FROM KU$_DEFERRED_STG_VIEW S
WHERE S.OBJ_NUM = LF.FRAGOBJ#)
, (SELECT TS.NAME
FROM TS$ TS
WHERE LF.TS# = TS.TS#)
, (SELECT TS.BLOCKSIZE
FROM TS$ TS
WHERE LF.TS# = TS.TS#)
, LF.INDFRAGOBJ#
, (SELECT VALUE(I)
FROM KU$_SUBLOBFRAGINDEX_VIEW I
WHERE I.OBJ_NUM=LF.INDFRAGOBJ#)
, LF.CHUNK
, LF.PCTVERSION$
, LF.FRAGFLAGS
, LF.FRAGPRO
, LF.SPARE1
, LF.SPARE2
, LF.SPARE3
FROM LOB$ L
, LOBCOMPPART$ LC
, LOBFRAG$ LF
WHERE LC.PARTOBJ#=LF.PARENTOBJ#
AND L.LOBJ#=LC.LOBJ#