Re: Error Control Table for Oracle Staging table

RamKumar · Posted 08-11-2014 01:35 AM

I've a requirement to create a error control table via status handling in DI job. But I couldn't do it (getting error) since my staging and target table is Oracle.

Please suggest to come past the error.

Kurt_Bremser · Posted 08-11-2014 04:04 AM

Code?

Log?

Error Message?

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

RamKumar · Posted 08-12-2014 09:48 AM

I don't have any of the details either. It was a question thrown to me during seminar. Any possibilities to guess the solution without the log?

LinusH · Posted 08-12-2014 11:33 AM

Guess, yes, but guessing right, no.

It could be thousands of reasons for this.

Data never sleeps

SASKiwi · Posted 08-13-2014 01:10 AM

What do you mean by "error control table"? It could mean different things to different people.

It is important to remember that it is impossible to trap every possible error that might happen in a data staging job and deal with it programmatically.

However it is easy to ensure that if an error does occur, that your job deals with it in a standard way - for example automatically doing no further processing by going into syntax-check mode (OPTIONS SYNTAXCHECK;).

Error Control Table for Oracle Staging table