DSXchange

What about making use of the UserStatus area? Once written to, a following Routine Activity stage (via a Sequencer Job) could automatically take the $UserStatus as an input parameter and use that to write out to a flat file or as input to your script. Or another job could use it to write to your tar...

You are going to have to split your inserts from your updates if you are using a different number of columns in the different sqls. Even when using custom sql you must have parameter markers for all of the columns in the stage. Your error message is telling you this as well. Use two separate links a...

I'd suggest using a hash file with a fixed value key and a data field for your max value. Use a Stage Variable to keep track of the max value, in essence putting a new value in it only when it is greater than the previous value. Write the stage variable to the hash with a constant key value (like '1...

Steve, I don't think BigPoppa is around anymore. They haven't posted since around March of this year I believe...

It's basically there in the 7.0 release. I haven't had a chance to see what additional features were added in 7.5 as of yet, but it's pretty powerful right now. Right-click on a derivation and select either 'Find/Replace' or 'Derivation Substitution'.

I'm not in a position where I have to deal with EBCDIC or any other form of Mainframe data, so the CFF stage is not something I make any use of currently. However, my understanding is it was meant to handle everything related to these kinds of files. You really shouldn't have had to fall back on the...

I am trying to find out how to combine multiple parameters and assign the result to another parameter. Perhaps that's the issue, because you can't. Well, at least you can't without writing some intervening BASIC job control code. You would need to pull in the values for the current parameters and t...

Hmm... I don't think that's entirely true. Yah, some 64bit systems get 32bit components, like OCI on HP/UX. However, I'm pretty sure that everything on Tru64 is in fact 64bit.

Not that that helps Peter.

i found the description into the online help but cannot find the symbol to use in my jobs. Look carefully at the background of the help page for that stage and you'll see why you can't find it. It is one of the many 'PX only' stages that are nicely documented even if all you have is plain 'ol Server.

Google is your friend!

Hmmm... no mention of Red Brick in their FAQ.

Check this thread and see if it helps.

Applicable to both the ODBC and UV stages, by the way.

Cool.

You need to go to the Link Properties of the Transformer stage you are doing the lookups from. It is there on the Inputs tab that you'll find a check box for Reference Link with multi row result set.

And if there's concerns about exactly what is going on, step through it with the Debugger a link at a time.