Skip to Main Content
Due to the recent acquisition by IBM, the Adabas & Natural Ideas Portal does not contain ideas from products ApplinX and EntireX any longer. Please refer to the IBM Ideas Portal for these products from now on (IBMid required). Existing content will be migrated during the next few weeks.
Status Not in Plan
Workspace Adabas for z/OS
Created by Guest
Created on Jul 13, 2021

#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. :wink:

Created on Brainstorm 04.29.2010 01:00 pm
Brainstorm ID 218
  • Admin
    Juergen Lind
    Reply
    |
    Sep 9, 2021

    We currently think that is too much of an effort.
    Probably it would be good to know an exact and more precise example.

  • +9