DSXchange

Yes.

Welcome aboard... a couple of things. First, I've put you into your own post and linked back to the 'similar' thing you are trying to do. Secondly, this meant I had to guess at some things, can you clarify for us: 1) Your DataStage version 2) Your server Operating System Thanks. I'd also be curious ...

If you've just loaded it and can use the link row count from the load job, then that works. I was thinking you wanted to check a table and that a single count of the records in the table would be a way to go.

It's been discussed quite a bit so there's a lot to wade through when you search for it. I've found a fairly representative example in this post. If that all gets too complicated, you could always simply write the count to a flat file and then use something to read it back into the sequence job... i...

In your shoes I would involve support if you haven't done so already.

Simplest way? Use a Server job to get the count and store it in USERSTATUS then interrogate that to trigger the second job or not.

I would wager that your spacing is just fine as it's not something that DataStage would change. Betting that it is whatever tool you are using to view the data after it has been inserted - it's probably using a proportional font which makes it look messed up when in fact it isn't. Try forcing it to ...

UAUITSBI wrote:I think my post is not showing the formatting issue correctly though it did while typing. Is there a way I can attach a screenshot in the post ?

Sure. Upload it to a file sharing site and then use the [Img] tags.

You'll need to be more specific as to your exact issue as all of your formatting is removed by the forum software unless you use

Exactly what I was thinking of... didn't run off and look up any specifics, however.

Thanks for the clarification. I'm not in a position to be able to help with that, have you checked to see if there are any PX functions that might serve here? Or failing that, a Server function you could leverage in a Server Shared Container, perhaps?

It's far too late to rollback anything except Job3's work if Job3 fails. The work done in any previous jobs has already been comitted so no rollback is possible. If you really want the data gone you need to run some kind of 'cleanup' job to do that provided you have some way to identify the records ...

Can you be more specific as to what you are doing? Typically this would be coming from a flat file and the CFF stage would be used and would translate that for you.

I'm a little lost... why not show us the code you are using? What are you trying to replace them with or are you in fact trying to strip them? Also unclear why you would be worried about hexadecimal anything when all characters have a decimal equivalent. EReplace is useful when you need to replace a...

Or attend some training if you haven't yet. FYI - one of the first things we check when we see someone new on the site is how they rank themselves when they set up their profile. You've marked yourself for DataStage as a 5 for Teacher level, no offense but you might want to dial that down a notch. A...