2384501 - Audit record does not display actual value - SAP ASE

• 'Full-Text Auditing' is a new feature started from ASE 16.0.  Full text with parameter values (local variables / dynamic prepare statements) of DML with option select/insert/update/delete will be printed in column ‘extrainfo’ on sysaudits table.
     
• When having BOTH configuration parameter 'statement cache size' and 'enable literal autoparam' on, audit record does not show actual value but @@@V0_VCHAR1 / @@@V1_INT etc.
           
  For example: on column ‘extrainfo’ of sysaudits table, it shows full text but no actual parameter values.
          
  event  eventmod spid   eventtime                       sequence suid
           dbid   objid       xactid
           loginname
           dbname
  objname                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 objowner
   extrainfo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               nodeid
  ==========================================================  
     
       70        1     20             Oct  26 2016 10:31AM        1           1
                4  1328004731 NULL
           sa
           pubs2
   test                                                                                                                                                                                                                                                                                                                                                                                                                                               dbo
           sa_role sso_role oper_role sybase_ts_role mon_role; update test set a=@@@V0_INT where b=@@@V1_VCHAR1; ; ; ; ; sa/ase;   
             NULL

SAP Adaptive Server Enterprise (ASE) 16.0 and higher

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To