Desktop productivity for business analysts and programmers

How can we perform rollback on SAS Datasets?

Reply
N/A
Posts: 0

How can we perform rollback on SAS Datasets?

I am running a job in DI Studio job. I am using a permanent cross reference table(SAS dataset) to load an oracle dimension table. So if some error occurs while loading to the oracle table i want that the data that is loaded in cross reference table should be rolled back. Is that possible? I tried ERRLIMIT = 1. But this works only for rdbms tables or pc files. What is the option for sas datasets?
Super Contributor
Super Contributor
Posts: 3,174

Re: How can we perform rollback on SAS Datasets?

Can you DI Studio job create a backup-copy of the SAS dataset, then detect an Oracle table load error, and conditionally restore the SAS dataset on an error condition? I expect that you will find SAS automatic macro variable(s) set with a code depending in the success of your Oracle connection, as long as you can continue executing your job after the error occurs to clean-up (your application code) as needed.

You may find useful information at the SAS support http://support.sas.com/ website either using the SEARCH facility or with using the Google advanced search argument listed below:

oracle error handling site:sas.com


Scott Barry
SBBWorks, Inc.
N/A
Posts: 0

Re: How can we perform rollback on SAS Datasets?

Thanks Scott for your suggestion Smiley Happy I am working on it.
Ask a Question
Discussion stats
  • 2 replies
  • 610 views
  • 0 likes
  • 2 in conversation