DSXchange

OK... perhaps use "--interactive=0" to disallow desktop interaction? Other than that I got nothing.

Re-read Ray's post.

Off you go to your own post...

Re-read my post.

Agreed... no stage variables needed. And you need to use concatenation, not math for this.

Never mind the fact that the Aggregator stages would then have much less work to do.

OK... that seems like a pretty straight-forward derivation to me. What have you tried? What issues are you seeing?

It depends entirely on if you are doing a Direct Path load or not: DIRECT=TRUE is speedy but does no commits so there's no way to rollback a partial load. DIRECT=FALSE means a conventional load with inserts and commits. Your best bet it to make sure there are no "bad" records when you load...

I would be extremely leery of using Convert() for this. However, when you said "I have to remove some part of the string" you never mentioned what part you need to remove. Details like that could help allay those fears.

Well... I doubt the -raw option is the issue but in your shoes I'd make the two blat command lines identical and see if that changes anything.

First off, not sure why you aren't using a job to do this rather than a routine. Regardless, I doubt any of your questions can be answered without you posting the routine code.

Thanks Andy!

I would imagine IBM does these kind of comparisons in order to help sell the product, have you tried contacting them?

sreesuku2 wrote:if necessary adjust the 'dssendmail_template.txt' file in the project directory.

Did you check this? Compare the template contents between the two versions?

When you run it from the command line, are you prompted for anything? That would be the classic reason for a 'hang', it's trying to ask you a question and is sitting there waiting for a response that will never come.