DSXchange

You'll need to write your own, I'm pretty sure. Check the online help for the MY conversion code. It "Converts ASCII characters to hexadecimal values on input, and vice versa on output." - see if that will work for you.

Upgrade to 7.5 - that's the first time that parameters are supported in that stage.

What we do is "hard code" email notification groups there. That way we can change who gets the emails without having to touch the jobs.

Or... write your own email routine.

Search is your friend as most questions have been asked before. For example, this thread, while covering other topics should also provide some help for your error message. There were others, so if this fails to help try searching for "39202" again... and if after that you're still stumped - come bac...

True, true. I've seen the same thing with the Sort stage, but haven't had the time lately to run any comprehensive benchmarks versus a UNIX level sort, let's say, on this particular server. There *is* SyncSort in the house, but "we" don't have (and can't seem to get) a license for it. In people's ex...

It won't "fail" in the sense that you'll get an error message, it will just fail to update any rows. Perhaps some other databases are different, but Oracle (and what I recall of Informix) is perfectly happy updating zero records.

Martin, you're going to need to restate your problem. We can't really tell what your issue is or why you "could not do update" from your post. Are you using one of the OCI stages? Did you notice you could change the "Update Action", and that there are several that do various forms of updates? When y...

Actually, the easiest way to solve this problem is to not use the "Load" button to bring your metadata in. I dislike the way it loads the "full path" to a field in the derivation and prefer to leave it blank, so poked around and found another way to do it! In the Designer, make sure you have the Rep...

Not that I am aware of. In my opinion, it's always better to use a 'native' stage rather than a generic one, if available.

You might want to consider using an OCI stage, or better yet (if on 7.5) the Stored Procedure stage.

Thanks Tony.

You are only going to be able to do this if your hash file is in the project or you've created a VOC record for it. If it is "pathed", i.e. is living in a directory outside your project, then this won't work. Otherwise, the syntax is simply:

Just do math on it and DataStage will "convert" it to a number. Fastest thing seems to be to add 0 to it, or you could multiply it by 1. Anything that doesn't change the value.

Out of curiousity, have you verified that it is unlimited in the environment your jobs run in? Not just from the same user at the command line as they can be different.

Hey, there's an echo in here!

What O/S? 2GB is a suspicious number, being the typical file size limit for sequential files on UNIX systems. What is your "ulimit"?