10-20-2015 06:02 PM
I am trying to scan through the sas codes to read the number of datasets that are updating the oracle tables . I need some ideas to start with do I need to the string check for "proc db load" or for " prosql insert in to" or is there any better way to scan. Thanks for your help.
10-21-2015 05:37 AM
Sorry, there's not much information there. What "jobs", what software etc? Personally I don't like the idea of people updating databases from SAS. You could try searching logs for the connect to oracle information, e.g in:
connect to oracle (path=....);
However, the question arises why? It sounds like giving the freedom to do this has got a bit out of control, me I would put in place a system where tracked imports, or code is run, preferably at set points and under certain conditions. Would make tracking a whole lot easier.
10-21-2015 06:46 AM
10-21-2015 11:12 AM
Thanks for your responses we are trying to create a metadata thats the reason I was trying to scan through logs and see which sas programs are inserting data in to database tables. I'll see if we have DI studio and go from there.