DSXchange

No worries... sometimes people search for "too much", too specific of a search string. Can help to cut it back, to use a more generic portion of the message. Sure it gives you more to weed thru, but your fish is in the net. Somewhere. :wink: Do you still need help? If so, please do give us...

Exactly. You are trying to 'solve' a non-existent problem.

Really got nothing to do with DataStage, it is just another client like any other app or tool. That failover is all in the hands of your DBAs, how they have configured RAC and what's in your tnsnames file. The fact that it is 'RAC' under the covers is completely transparent to the outside world.

Yes, it can.

Search just for "newTime". That and give us some idea of your job design.

So... no pressure, eh Andy? :? Are you saying that you have no shot at getting the original pgp file from the server before this "Cast Iron" thing puts it securely away somewhere you can't get at? Or is that the ssh approach? Nothing is jumping out at me in the "it can't be done"...

And yet - somehow - we've seen that reported here as already having happened. From what I recall, they needed custom/specific dml to resolve the issue and correct the "out-of-sync-ness" of the XMETA repository.

First off, there's really no need to explain to us how a hashed reference lookup works. Pretty sure we've got that down. :wink: Doesn't matter how many records there are in the hashed file, if the keys don't all match exactly, it's not going to return anything on the reference link. Seems to me your...

Sheesh. Why not simply split off a link to an Aggregator, write the count to a header file and cat the two together after job. No pesky script required.

nkln@you wrote:I mapped the fileds of the hash file into a sequential file and ran job B

We'd need a better explanation of this to be able to help.

Yes... as long as it's just "old" files as you've noted.

Ah... it throws me sometimes because it will always log things you don't send it, critical or not, like it's no big deal. So make sure you are passing in the mail server and see if that fixes things.

There's no explicit conversion needed in Server, just strip the delimiters before you move it to the target field. One easy way to do that is to use the DIGITS transform.

ray.wurlod wrote:If you had two failover boxes would that be a HAHA configuration?

Ah, there you are Mr Wurlod. You know you're not supposed to be out wandering the halls on your own, now don't you? Let's just get you back to your room, shall we...that's a good boy... this way...

asorrell wrote:you can just "unalias vi" to get the original vi command

That worked! Very nice, thanks Andy.