1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

Can you get a log file of 'reads' on specific RECID(Tablename) in Progress-4GL/Openedge at...

Discussão em 'StackOverflow' iniciado por fdantas, Outubro 28, 2017.

  1. fdantas

    fdantas Administrator Moderador

    I want to know which tables are being read by a query.

    for each Customer where CustomerID = 12345.

    Eventually this customer will be found in the following example, but progress must 'read' many tables before getting to customer 12345.

    How do I know exactly which tables are read (By CustomerID), prior to getting to customer 12345?

    *NOTE: I do not have access to modify the code being run for this selection. Ideally I would run a separate set of code that is executed at the same time as the customer query above to track the reads.

    EDIT: More clearly - Can you track reads from a given program (.p) OR ProcessID and output either a RECID or the PrimaryKey to a file?
    I understand the information is being read off the Disk and probably stored in a database buffer. So how would I get at the information in the database buffer?

    Continue reading...

Compartilhe esta Página