#1014072 ADASEL SELECT ALL FROM USER... sh. allow WITH FILES

With ADABAS V8.2 ADASEL is enabled to select data from PLOG via USER statement, which includes all files found on PLOG. Selection via USER is a necessary and useful feature to find out for example which modifications were initiated by a certain user at a certain time, without the need to code a SELECT statement for every file on the database. But practically the solution can produce an enormous output of data with SELECT ALL FROM USER WITH… DISPLAY ALL.
To complete this solution I whished a possibility to limit SELECT ALL FROM USER to a range of interesting files for example with the supplement WITH FILES = … and/or DISPLAY FILE.

At the moment I have to limit the first SELECT …FROM USER by DISPLAY USERID and in a second run with SELECT …FROM FILE…WITH USERID… finally I can list the changed data for up to 20 files for a certain user. This procedure would be simplified by allowing WITH FILES = in SELECT …FROM USER statement.

DBA-AK voted EP as “Important”