Audit Trail

[Asmam]

Hi, I am trying to know the  user ID and the code that is associated with a modification so I ran this code , but nothing is displayed

proc sql;
  select
         reason_code,
         _atopcode_,
         _atuserid_ format=$6.,
         _atdatetime_
         from la_prod.ADM_GLOBAL_VARS (type=audit);
quit;

someone can help me please. 

[LinusH]

Are your sure that audit is activated for this table, and that has been changes since that time?
Please provide the log.

[Asmam]

@LinusH thanks for answering me !
Well I activated the audit and I made some changes and I add the variables _ATRETURNCODE_ , _ATMESSAGE_ .

it works for the datetime and the user name ! but i got nothing for _ATRETURNCODE_ and _ATMESSAGE_ .

 

[LinusH]

I can't test it right now, but my guess is that those are only populated when there is an issue, like a violated constraint or similar.