SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

How to capturing Sql statistics or log from teradata into SAS

Reply
Occasional Contributor
Posts: 13

How to capturing Sql statistics or log from teradata into SAS

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.

Super User
Posts: 5,876

Re: How to capturing Sql statistics or log from teradata into SAS

For the error "record"?, have you tried &SYSDBMSG and &SYSDBRC?

If you are using SQL pass through, you also have &SQLXMSG and &SQLXRC.

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 113 views
  • 0 likes
  • 2 in conversation