Re: how to tell if LF is a Joined LF

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 01/29/2018 03:43:25
PM:

Allow write operation . . . . . . . . . . . : No
Allow update operation . . . . . . . . . . : ALWUPD *YES
Allow delete operation . . . . . . . . . . : ALWDLT *YES

external dds LF

OK, so it truly isn't insertable just like SYSTABLES said.
SYSTABLES is a view and one of the tables it is based on does have all
three attributes in it. So, perhaps you want to use the based on table,
instead.


Select DBXLIB, DBXFIL, DBXATR, DBXTYP, DBXSYS, DBXSO
, DBXINSERT, DBXUPD, DBXDELETE
FROM QSYS.QADBXREF
WHERE DBXATR in ('LF','VW')
AND DBXSYS <> 'Y'
AND (DBXINSERT <> 'Y' and DBXUPD <> 'Y' and DBXDELETE <> 'Y')
Order by DBXLIB, DBXFIL;


Sincerely,

Dave Clark