topic Re: How can we perform rollback on SAS Datasets? in SAS Enterprise Guide

How can we perform rollback on SAS Datasets?

deleted_user — Mon, 25 May 2009 08:48:42 GMT

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?

Re: How can we perform rollback on SAS Datasets?

sbb — Mon, 25 May 2009 15:13:26 GMT

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.

Re: How can we perform rollback on SAS Datasets?

deleted_user — Fri, 29 May 2009 06:29:29 GMT

Thanks Scott for your suggestion 🙂 I am working on it.