Code:
- select
- QEZDIRIDX, -- The parent directory index
- QEZOBJNAM, -- The object name
- QEZOBJTYPE, -- The object type
- QEZNONSAV, -- Object can be saved or not
- QEZALCSIZE, -- Number of bytes allocated for the object
- QEZDTASIZE, -- Size in bytes of the data in the object
- QEZPCSYS, -- Object is a system file
- QEZTMPOBJ, -- Object is temporary or not
- QEZSYSRSSV, -- System restricts save or not
- d.qezdirnam1
- from routines.QAEZD0022O o,
- lateral (select qezdirnam1 from routines.qaezd0022d where qezdiridx=o.qezdiridx) as d (qezdirnam1)
- where ((QEZNONSAV = '1') or (QEZSYSRSSV = '1'))
- order by QEZDIRIDX asc
- ;
-
|
|