How to query the LOG table in Aeries to find changes made using the query CHANGE command in Query
To find all CHANGE queries executed:
LIST LOG IF CD = "NETQRYCHGCMD"
The record column displays the number of records changed, the Aeries Query, and the SQL equivalent of the CHANGE query
To find CHANGE queries executed on a specific table, replace [xxx] with the desired table code
LIST LOG IF CD = "NETQRYCHGCMD" AND OB = "[xxx]"
To find CHANGE queries performed by a specific user, replace [username] with the desired username
LIST LOG IF CD = "NETQRYCHGCMD" AND USR = "[username]"