DSXchange

One option is to not use XML, a dsx export is perfectly readable and won't be so freaking huge. Second option is to use a better editor like UltraEdit which can handle large files. Third option - go to Chuck Smith's site and from his Tools section grab some of his stuff. Simplest might be "Sear...

UCDI wrote:Otherwise I am just going to proceed now that, 2 days later, this 5 min task is finally done.

Funny and sad, all at the same time. And I hate crap like that.

I'm not really sure what Rick meant by his "not intended" comment, hoping he'll clarify when next he swings by. As we all know, the whole "wait for file" doesn't mean anything like wait for it to be complete, it means wait for it to appear (or disappear) with no regard for if is ...

Why is this marked as Resolved, did you figure out your issue? If so, could you post it please?

I'm going to go out on a limb here and guess they meant in their current version.

Isn't the SalesForce API... published?

Except that I've done exactly what they are doing in the past and it has worked just fine. I think the difference might simply be this: (If Len(trim(col1))=0 then "col1 is invalid" else ""): (If Len(trim(col2))=0 then "col2 is invalid" else ""): (If Len(trim(c...

So, in other words, the link from the documentation I posted where it says "To get the files for the examples, go to". Did you think it would be too hard to find it there, Andy?

Back up a little bit to here:

http://www.ibm.com/support/knowledgecen ... stage.html

Sorry but how do 'the symptoms match' here? Is this an ISD job failing with the error that they mention? I thought it a normal Sequence job that just waited... forever... without any kind of failure.

Check for 99 / DSJS_NOTRUNNING and call it COMPILED if you like. Not running implies runnable and it must be compiled to be in that state. This as opposed to 98 / Not Compiled.

Well... it's an official way and orders of magnitude safer than when I've seen people roll their own and run delete SQL against the repository.

From the link: The preferred way to run this command is in the istool command-line window. If you run this command in your operating system command-line window or in scripts, you must add istool to the command name. Based on your initial requirements of doing this from a script, it sounds like you s...

You can use istool to delete DataStage assets as noted here. You'll need to know what type of job it is in order to leverage that.

Be curious what you find. Perhaps you should involve support because when push comes to shove it really should be that simple, so perhaps there's an issue with the stage in your platform / version. Never mind that it seems to me that we are way past remote suggestions being helpful, sounds like it r...

My biggest question right now is - where is part 1? A (mostly) honest question as I figured it must have been something I didn't recall reading but a search failed to turn any such thing up. Hence the question.