BookmarkSubscribeRSS Feed
deepakpara
Calcite | Level 5

Hi Everyone,

I have to write a code to check which code has called teradata query and also copy that query if possible..

Want to write a macro and evry code  will have that macro at the top.. kind of an audit macro.

will have to chase the log while the code is running.

Please help..

Thanks in advance.

DeepakPara

3 REPLIES 3
deepakpara
Calcite | Level 5
basically I wana search 'Teradata' or maybe anyother string at run time.
Tom
Super User Tom
Super User

It might be easier to search the query logs in your Teradata server.

Otherwise you might want to tell all of your SAS programmers to add options that will insure that messages from Teradata appear in the log. Then there will be more things to search for in the log.

 

options sastrace=',,,ds' sastraceloc=saslog ;
Kurt_Bremser
Super User

Look at the log of a job that you know uses the Teradata connection.

Find a characteristic string that is typical for that (say, a schema name or similar).

Use grep with that string on all your logs.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 358 views
  • 0 likes
  • 3 in conversation