SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Error Control Table for Oracle Staging table

Reply
Regular Contributor
Posts: 168

Error Control Table for Oracle Staging table

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.

Super User
Posts: 6,935

Re: Error Control Table for Oracle Staging table

Code?

Log?

Error Message?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Regular Contributor
Posts: 168

Re: Error Control Table for Oracle Staging table

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?

Super User
Posts: 5,256

Re: Error Control Table for Oracle Staging table

Guess, yes, but guessing right, no.

It could be thousands of reasons for this.

Data never sleeps
Super User
Posts: 3,102

Re: Error Control Table for Oracle Staging table

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 SYNTAXCHECKSmiley Wink.


Ask a Question
Discussion stats
  • 4 replies
  • 356 views
  • 0 likes
  • 4 in conversation