DSXchange

Quick note - 'after job' the job is still running, so that's the only status you'll get. Check for the INTERIM status instead.

Or - since we're talking about a script - capture and interrogate the output from the -jobinfo option.

First suggestion would be to disable/uncheck/not use this option and see if the behaviour changes:

"Log warnings after activities that finish with status other than OK"

As I noted, not sure. Best to check with your official support provider on that and let us know what they say. Unless someone else knows for sure, of course - if so, feel free to jump on in!

mystuff wrote:Its look ok, but I am unable to understand why I am obtaining finished with warnings.

A little lost. You don't understand where the warnings are coming from? Or are you trying to get it to abort so that your Sequence is restartable, but only get warnings instead?

I wouldn't make any such guess. You've resurrected a two year old thread with basically a post that just says 'Me too!'. Suggestion: For times like this start a new thread and document exactly what problem you are having. Provide a link back to the old thread if you feel it would be helpful. Include...

The second value is the substring length to pull, not the ending character position - something a quick check of the documentation would have revealed.

Have you investigated the IsValid() function?

(sorry, misread the requirement - never mind)

Read the file as pipe delimited, write only if Rejects > 0. In a Sequence job, check for rows down your output link and trigger a Notification Activity when that count is > 0 as well. Build a generic custom routine to do the check, you can use DSGetLinkInfo() with DSJ.LINKROWCOUNT (off the top of my...

While multiple parameters *can* be on the command line, you can only use one mode at a time. To emulate the 'Reset if Required then Run' functionality of Sequence jobs, you'll need a script that does 3 things: 1. Checks the status of the job to be run 2. If the job is in an Aborted state, issue the ...

Now you've lost me, what would be the point of that? It's already 'in a sequential file'. However... read / write it as one long varchar column.

Sure, read it as one long varchar column then parse as appropriate. The question is what data do you need to 'extract' from it?

Wow, still running 4.2 eh? You really should be asking your official support provider this question, I seriously doubt many here would have any direct experience with something like this. Well, except perhaps for ICE.

You don't need to ask me questions, just ask. And please do a better job with your choice of subject - it should indicate the problem or question you have, don't just keep saying 'XML' for everything XML related. What does your Sequential file look like if you look at it outside of DataStage? Log i...

If you've solved the problem, then you need to do two things for us please:

1) Explain how you resolved it.
2) Mark the topic as 'Resolved'.

This helps future users of the site.