DSXchange

Err, OK. I linked to it, so just click on the blue bit and you'll be there.

How is this different from your your previous BLOB post? Answers will still be the same.

Start your own post. Explain in detail what your Oracle issue is rather than saying it is 'very similar' to a DB2 problem as that doesn't really tell us much of anything. Then people would stand a chance of actually helping.

Like any good command, dsjob has full 'usage' implemented, so not specifying any parameters will cause it to spit them out. Also check the Command Line Interface chapter in the Server Job Developer's Guide pdf, everything (including source code) is there.

The -1 syntax is shorthand notation for the concept of assignments to the maximum element. So, if there were 3 elements in the array, referencing <-1> would be the same as <4>.

No clue, but what's the extent of the problem? Does this only happen in one Project in particular or all Projects? Does this happen to everyone or just you? Any other details you can provide?

From the home page: http://www.dsxchange.com/memberbenefits/

Compare that to "today's date" and build your list.

I would think you'd also need to be monitoring Oracle with the help of your friendly neighborhood DBAs. We've seen plenty of times here where pressure on any kind of Oracle extract processing can cause it to slow. In other words, if Oracle thinks you are having a problem taking the data as fast as i...

whenry6000 wrote:ODBC is a Windows term.

Windows term? No. Perhaps you are thinking of Microsoft, as they were one of the creators.

To the best of my knowledge, yes - the Java PACK is what you would need to leverage JDBC in DataStage.

Well... the short answer is they aren't supported. For more on the subject, search the forums for BLOB and see if any of them help.

skp wrote:33521 Type Fatal
Event Load_Ivd_TA_ACCOUNTS,1 Array execute failed for insert (...)

Data problem, I would think. You need to double-click on these Fatal messages with ellipses (...) as that means there is more information to be dug out. Let us know what you find.

I've said all I can say on this subject. I know how it works and it works just fine for me. So we're either missing some vital bit of information or they've broken some aspect of this in the 8.x version. Going to repeat this one last time... Open a case with your official Support provider. Have them...

What are you doing wrong? Not searching before posting. This has been discussed a bajillion times, please have a go at searching for a significant portion your error message, such as:

ParamValue/Limitvalue is not appropriate

In a sense, who cares what errors you get when you View Data - does the job run, do you get those same errors then as well?