DSXchange

There may very well be, it's just that I'm not aware of any. But perhaps someone else is! :D

Not that I know of but perhaps others are aware of a mechanism. I would copy them (name, derivation, initial value, etc.) out to a scratch document and then paste them in the new job. If you are feeling adventurous, export the two jobs and copy in the stage variables portion from first job's dsx fil...

Done properly, there's no way that it can't "execute the function". How about some details, please. What database, target stage, actual SQL used, options in the stage, messages in the log - anything that can help us help you.

That smells like a bug to me... have you reported it to IBM?

Use your own 'user defined' SQL to do that insert, modeled after what the stage is currently using, but with the function call you need added.

Depends. Or again... more. Look, no one can tell you unequivocally what would be better for your job running on your hardware with your data with everything else your server has running except... well, you. Try both. More than once. Compare and contrast, then decide. Let us know. Or just go with the...

... was wondering if that might be the case but you didn't mention the "O" word.

So... resolved?

You may not need to pass in the timestamp, the DSJobStarttime macro should be able to be used directly in the parallel job as part of the filename in the connector stage. Unless you need to reformat it, as noted, then that would need to happen in the sequence job before passing it to the job.

This may help...

But not yet expired! Unless someone waits another three years to check.

That's a pretty open question without a single answer... except for "depends". I'm sure others will come along and help as I've been away from the tool for quite some time but generally speaking more is better - within limits - as there are far too many variables to hand out a single, simp...

You might want to start by expanding a teeny bit on what "getting error" and "bad rows" mean.

Perhaps.... this?

Your understanding is... incorrect. Or best case incomplete.