DSXchange

By using built in stage ,I am able to send only job status( finished/finished with warning/aborted) only.. I honestly don't believe this to be true. It's been awhile, but from what I remember it actually does include the failure message(s) from any problem job when you enable that option. If I get ...

You cannot have 'five records with the same key' in a hashed file, so... no. Hashed files are destructive overwrite or 'last one in wins' when it comes to key handling. Now, you can create a hashed file with a composite key and then use a UV stage over it where you specify a lesser number of the key...

I did not list the Job Status Code, indeed but just listed out Job Status in words. But the fact that you numbered them was... misleading. ps. I'm a little confused by both locations mentioned where you can find this information on your own. There's no DSINCLUDE directory on my server, nor a DS_JOB...

DSRajesh -

Please understand that no-one here is recommending that you ever delete anything under the covers in DataStage. Purge your job logs from the GUI whenever possible. Sometimes extreme corruption can make that... difficult, but those times are very rare.

PrasannaLkashmiBurri wrote:The job is running fine but the key values generated are junk values

Junk values? What exactly does that mean? What are you seeing?

Or instead, add that bin directory to your path so you can execute 'dsjob' from anywhere.

Rather than ask Larry, who hasn't posted here in over two years if you check his stats, start your own post. That way we'll know your particulars and you can spell out all the gory details of your problem, not Larry's.

Sorry, but neither do I. I don't understand the conclusion you seem to be coming to at all, let alone in the light of the documentation you quoted.

New to the XML Output stage or XML in general? Regardless, there are a couple of documents you need to become familiar with. First would be the XMLPACK_20_Designer pdf in the Docs directory on your client PC. The second would be the 'Best Practices' document we've stored on Kim Duke's website in his...

You'll need to redirect the output for the 'to a file' part, which means adding " > filenname" or perhaps " >> filename" to the end of the command.

Same answer for Windows.

Interesting... I'm going to keep an eye on this and see what comes of it, that and if it attracts our resident XML gadfly Ernie. We very rarely have this issue, tending instead getting a large number of smaller files rather then getting a small number of larger files. And when we've seen the giganto...

The LOGTO does happen but then exits and only then is the second statement is issued, which defeats the purpose. You need to do multiple commands in the same session. As Arnd noted, if you 'cd' to the project in question before launching the shell, the LOGTO is automatic. That way you're down to a s...

Or download the one Chuck wrote and gives away on his website.