SELECT e.tsno, e.fileno, e.blockno,
CEIL(e.length * ((
SELECT t1$.blocksize
FROM sys.ts$ t1$
WHERE t1$.ts# = e.tsno) / (
SELECT t0$.blocksize
FROM sys.ts$ t0$
WHERE t0$.ts# = 0)))
FROM sys.exu9tneb e
SELECT E.TSNO
, E.FILENO
, E.BLOCKNO
,
CEIL(E.LENGTH * ((
SELECT T1$.BLOCKSIZE
FROM SYS.TS$ T1$
WHERE T1$.TS# = E.TSNO) / (
SELECT T0$.BLOCKSIZE
FROM SYS.TS$ T0$
WHERE T0$.TS# = 0)))
FROM SYS.EXU9TNEB E
|
|
|