DSXchange

So, you're not even going to try and figure it out yourself? Arnd showed you how to get the last 'word' or token from the string, now you need to get everything before that. Check the syntax for the FIELD function, there's a way to take multiple fields at once. Hint - try to code something to take a...

You can start an input stream with a Transformer under certain circumstances and that's what you need to do here. Add a Transformer and a link to the reference hash. A transformer can be used to generate data as long as you define a stage variable in it (don't need to use it, just define it) and the...

And there's a little trick you can play with a Transformer as a source when your lookup comes first.

You're slipping, Roy... there's no Poll here.

Then they must have fixed it in your version, Lance. I think some of the issues people have seen in this regard are platform specific as well. Just for the record, what version of DataStage and what O/S are you running?

For a Server job, you should be able to open up the Sequential File stage and switch to the Columns tab. Slide it over to the right and you'll find one called 'Contains terminators'. Set it to yes on the appropriate fields and you should be ok.

You must do the installation as root.

Or upgrade to 7.5 so you have access to the Stored Procedure stage.

Can anyone please let me know what is the significance of that option and what is the correct usage. Why not just look it up yourself? With the OCI stage open, there should be a Help button down in the lower right-hand corner. I haven't been on a 5.x server for years, but pretty sure it has always ...

You're right, it doesn't work.

If you really need to use parameters in your email, you'll have to script up your own call to sendmail and execute it using the Routine Activity stage.

Still plenty of time for that, Arnd.

Sheesh... should have looked harder before posting. Found it buried down in a sub-sub-custom category in and amongst several things I'd loaded as examples for my noobies. It's part of the "Ascential Technical Tips & Tricks CD Version 1 - September 2002" that Mr Totman put together way back when,...

As do I. Trust me, this isn't anything user-written because I'm the only user writing custom routines here. And I never start anything with 'DS'. This is a 7.0.1 install on HP/UX and the only thing out of the ordinary that was installed was the ClickPack - and it created its own category where every...

Most people would use a UV stage to do that.

The name of your hashed file is DSLink2?

Try using the command as written. Arnd said to try COUNT HashedFileName not COUNT 'HashedFileName' - it will work much more betta without the single quotes around the name.