DSXchange

I searched in Google and only found "Web Business Intelligence" but no specific database or data format so I am at a loss as well.

KrazyKoolRohit - Thanks, I see now! I am not sure that the error causes are related, but they are similar and it is certainly worth a try to see if it makes a difference.

And if you look at the test sequential file are all 8 records there as you expect? It is just that it is unlikely for the UPDATE to work correctly for some but not for other record contents so we are trying to eliminate possible error sources .

I think that this is a known V8 bug.

The error message from DSD.RUN looks like it comes from a "reset" of a job sequence, not a Parallel job, ist that right? Or is this the log of the aborted PX job?

If you draw a link from your Oracle stage and change the Oracle stage settings then all rejects will go down that link. There are so many factors affecting throughput that the second question is not easily answered, it is like asking "how can I make my car faster?" and expecting a concise response. ...

If you change your parallel job output to a text file or peek stage do you see any rows there? What stage did you use in the Parallel job, and are you certain you set the commit to 1?

Oddly enough, I used the Search button and got several threads that address the same question.

Have you checked your scratch space?

Your problem stems from the fact that you declare LATIN-1 in your source but have characters that are not in that character set. You will need to discover what mapping is used in the source before you can do anything at all.

Hello and welcome to DSXChange.

Generally an upgrade of DataStage will not have significant issues and problems; but with Version 8 the product has become somewhat more complex and the Information Server has been added.

Version 8 ships with PDF documents describing the upgrade process.

Plus that doesn't look like c++ code in a buildop to me, either

Please read the docs, the function is the opposite of the one you just used to generate the date.

The switch selector doesn't allow string functions. You need to create a column with that substring value in a stage before the switch stage and use that column's value.

Sorry, I just wasn't paying attention to the first post and format there. Ok, so in your modify stage you have now successfully converted the string to a date. Now you need a 2nd modify stage which will convert this formatless date into a char datatype with appropriate formatting.

KrazyKoolRohit - that is an interesting post. I'm unclear as to how those value could affect execution; could you perhaps explain that?