DSXchange

Well, obviously something is changed or at least different about this run from the last one. The rub is trying to determine what.

Out of curiousity, what exactly does your routine return when it "fails"? And when it executes successfully?

Check this post:

viewtopic.php?t=120334

No, nothing wrong with it and it's out there in posts. DecimalToString() should have worked as well AFAIK, what syntax did you try?

Hmmm... isn't the space a placeholder for the sign? Or is it literally between every column, even the string columns?

Please edit your post and wrap all of the code in

By making sure they all "buy them at the same store" - be that a sequence object or by using the same sdk KeyMgt routine key value or whatnot. Pull them from the same source and be prepared to handle concurrency - database sequences do that automatically and there is a 'Concurrent' version...

Finally got my hands on the official IBM pdf documentation library for 8.1 and I'm not sure what to think. Sure, the number of documents has increased (I count 56 mysteriously named pdf files that I have) but the "IBM style" they are now laid out in seems... lacking. Many of the illustrati...

For something like this, it would be best to involve your official support provider. Your error message only comes up in one other post that isn't really answered. And just want to verify - this is an actual in place upgrade of an existing version to the new version, yes? No clue if this would work,...

That would be similar to constraining it to one node. I haven't seen this behaviour when hashed correctly, seems like there must be something set/going on that you haven't mentioned, something critical to the problem solving effort. This is where it would be handy to be looking over your shoulder. :(

What kind of limit - the number of parameters in a set perhaps? Not that I am aware of.

Yup, that would be the best way.

Seems a little redundant. There is a "Site/Forum" forum which would probably have been more suitable to post in. However, seems to me this really should go into an email to the 'Membership Director' rather than in an open forum. None of us here, including the Moderator, would be able to pr...

At a file level? No, there's nothing built in for that.

What are you considering to be the "unique sequence id"? Do you mean the internal number DataStage assigns at job creation time? If so, you do realize this isn't a static value, yes? It can change over the life of the job.