DSXchange

I think we already know what the problem is, it's coded to run from the command line via std in/out rather than coded to work against the DataStage engine links via the Javapack API. Not saying I know how to code this up, just that Ernie has already noted the nature of the problem.

Sure but... why? And then try to figure out where the comma should be put back? Me I'd just keep it simple and not manipulate the source file.

Did you get this working? If not, are you having an issue with the command itself (which a search would have turned up) or the actual means of how to incorporate it into your processing? For the latter, it would seem like you could do this either at the very beginning or end of your processing. Do y...

It's certainly a track but you have to decide what's right for your situation / needs. Give it a shot, let us know how it goes and if you have any specific questions. And one last comment, I for one wouldn't use an email address as any kind of 'key'. Use it for your matching criteria but a surrogate...

Or just read the file 'like normal' and then concatenate the two values together with a comma between them.

Never mind the fact that it looks like you already 'solved' your problem. What kind of suggestions are you looking for?

Please be more specific - 'cube' is far too generic.

Yes, strangely popular recently and interesting how the phrasing is so similar. Makes one... suspicious.

Asked and answered. There was a suggestion to search as you're not the first person to ask that question and I posted a link to one such search result. There are several.

So a global sequence... that's fine. Just wanted to make sure we understood how it was being used.

For the recipient's email address, you can specify a parameter. What happens when you click the Browse button to open the External Parameter Helper, which shows you all parameters available at this point in the job sequence? Does yours show and if you pick it from the Helper does it then function pr...

One such example here. However, if your sequence always starts at zero each run then there's really no need to be using a sequence. Why not simply increment a counter?

ray.wurlod wrote:It's not.

Phooey. Should be.

Set the 'Delimiter string' property.