DSXchange

That would just give you a standard "usage statement" without the level of detail that the documentation goes into.

I don't have any of the 8.x documentation here now, but in the 7.x world it was all explained in the Command Line Interface chapter in either of the two "Developer Guides". I know it's in the new docs somewhere, just not sure exactly where, sorry.

Oh, good lord. By contrast, I should waste "precious minutes of my life" repeating something over and over when a search would turn up the answer? Please.

:!: I split this from the post you decided to add it to. New problems = new posts, which also gives you the added bonus of being able to control the fate of the thread such as deciding when it is resolved. Please take a moment to edit your post and add the particulars for your particular issue: Data...

Do you have it working in another Project that you could export/import into this one? Have you tried the Multi-Job Compiler? Sometimes it lets you do things that are not otherwise possible on a singleton basis.

Taken on its own, that doesn't make a whole lot of sense. A surrogate key is a unique value and would typically be the PK of the record. Does your target structure allow multiple records to exist with the same surrogate value? Or are you simply saying that subsequent occurances of 'the same client' ...

If you are saying that your Server is not local, i.e. is in a remote location then no, there really is no other solution.

Good luck, would be cool if someone did. :wink: We ended up taking the Java that they had written for singleton calls and having it converted to handle streams. We then took a mid-job Sequential File stage that dropped the target values to a flat file and then immediately picked the file back up and...

I wonder if simply putting a Transformer between the two (rather than the IPC stage) would have done the trick as well?

agpt wrote:Can you please tell me what Column[3] does here exactly?

Without the starting position, it starts from the end so that means to substring off the last 3 characters from the string.

Out of curiousity, did you take your actual error message and do an exact search for it here? I know it has been discussed a number of times in the past, seems like those discussions would be of some help to you.

When I see something like this, it is usually data related. Something has come along in production that you haven't seen or tested for in your other environments. If you are certain about 'everything else' being the same and no changes have been made recently in production, that is sure what I would...

Do you understand what the sql does? Can you spell out in words what kind of information you need from the dataset in question?

Just wanted to make sure you were aware of the Reply to Topic 'button' in the future - it is down at the bottom left-hand side of the page. There's no need to quote an entire post simply to reply - do that when it makes sense or you need to respond to certain segments of other posts, but not all the...