I sent Bill the same SQL last week. Oh well.
I specifically stated that I hadn't linked to the UDC table, though the values were in H98|DT. My SQL was based on having built the cross reference - and was as follows. This allows you to get the same info out of Standalone - without having central object specs....
<font class="small">Code:</font><hr /><pre>
select
F980021.sjobnm,
F9860.SIPFX||F980021.sjdtan,
f9202.frdscr,
F980021.sjkysq,
f9210.frowtp,
f9210.frdtas,
f9210.frerul,
f9210.frero1,
f9210.frero2
from jdevl900.f980021 F980021
inner join jdeol900.f9860 f9860 on f980021.sjobnm = f9860.siobnm
inner join jdedd900.f9202 f9202 on f980021.sjdtan = f9202.frdtai
inner join jdedd900.f9210 f9210 on f980021.sjdtan = f9210.frdtai
where
f980021.sjfmt <> 'INDEX'
order by f980021.SJOBNM, F980021.sjkysq
</pre><hr />