DSXchange

You can't use a Transform in a routine, but you can use its logic.

Welcome aboard.

You could do worse than to Search DSXchange, because this question has been asked and answered previously.

If you have access to the XMETA database you can see all of the table definitions. They're not all for DataStage, and there's no guidance about which of the 2000+ tables are for DataStage, so you're on your own there.

I still want to learn about this alleged six character limit!

First, it's buildOP not buildup.

Second, there's nothing in your code that looks after transferring the result to the output. You seem to be thinking like a server routine's logic.

Put user-defined SQL into an appropriate stage type.

Look at the expression of the MONTH.LAST Transform. This provides the logic that you seek.

This is not correct. QualityStage uses the same engine that DataStage does. But you do have to license QualityStage in addition to DataStage - this is unchanged from earlier versions.

Version 8.7 allows for encrypted passwords to be used on the command line.

You can concatenate them if you type them in manually.

You have obtained a copy of Ken Bland Associates job control routines. Therefore, you should also have obtained a copy of the documentation that comes with it. Track that down on your site, or you can find Ken's website by searching DSXchange. The "key part" is the invocation of KBAJobCont...

Is "nil" support defined the same way in both environments?

That's interesting. I've just verified your statement about DS_METADATA - created a record in there, re-built the index and refreshed the repository in Designer and... nothing. My best advice would be to continue to fight for access to the table definitions - after all, it's not as if you're accessi...

You tell us. It's your job!

Based on your description I would guess that it's using job control code. What does the annotation tell you?

This information is not publicly documented, a deliberate decision by the vendor.