×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Assuming that you run RTVDIRINF,
and you know how to change the following sql statement to use the most
recent tables you created using RTVDIRINF,
then you can run this:
Notice: SQL comments use the dash dash, which can play heck with some
mail readers. Oh well...
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
;
Rob Berendt
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
