https://communities.sas.com/t5/SAS-Data-Management/How-to-capturing-Sql-statistics-or-log-from-teradata-into-SAS/m-p/442874#M13671 <P>Hi, I'm running a query on Teradata connecting from SAS. I would like to capture the error record into SAS or number of records that have been inserted into the table. Please advise, I tried sas trace but could not get the required output.</P> Tue, 06 Mar 2018 13:36:25 GMT raj231 2018-03-06T13:36:25Z https://communities.sas.com/t5/SAS-Data-Management/How-to-capturing-Sql-statistics-or-log-from-teradata-into-SAS/m-p/442874#M13671 <P>Hi, I'm running a query on Teradata connecting from SAS. I would like to capture the error record into SAS or number of records that have been inserted into the table. Please advise, I tried sas trace but could not get the required output.</P> Tue, 06 Mar 2018 13:36:25 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-capturing-Sql-statistics-or-log-from-teradata-into-SAS/m-p/442874#M13671 raj231 2018-03-06T13:36:25Z https://communities.sas.com/t5/SAS-Data-Management/How-to-capturing-Sql-statistics-or-log-from-teradata-into-SAS/m-p/442877#M13672 <P>For the error "record"?, have you tried &amp;SYSDBMSG and &amp;SYSDBRC?</P> <P>If you are using SQL pass through, you also have &amp;SQLXMSG and &amp;SQLXRC.</P> Tue, 06 Mar 2018 13:43:14 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-capturing-Sql-statistics-or-log-from-teradata-into-SAS/m-p/442877#M13672 LinusH 2018-03-06T13:43:14Z