DSXchange

Why not use double quotes as the quote character? Then you don't need to change the single quotes.

All but the last of these can be answered from the UniVerse manuals - I am not sure to which "admin tool" the final question refers.

DataStage originally - through to version 6.0 - was built using UniVerse as its engine as well as its repository database.

The ones documented in the manual and on-line help.

Welcome aboard.

I, too, find this description confusing. Are you saying that all dates are loaded with the value 01/01/0011? What are you doing to these dates within the job? Are you using Data Elements in the design? What stage types are you using?

These ARE the commands. That "it doesn't work" is insufficient diagnostic information with which we can work. What does "it doesn't work" mean in this context and what is your proof of your assertion? We don't do "urgent" at DSXchange, which is an all-volunteer forum wh...

Not I. But welcome aboard anyway - maybe someone else will have such a list.

Don't forget to check stage variable initialization and derivation expressions.

Easiest is to use the regular DB2 backup tools.

They won't, they don't, there isn't one.

You appear to have "#<" in an expression. This "not less than" operator is a synonym for "greater than or equal to" or "GE". Your derivation expression is syntactically invalid. Right click on the expression and choose "Validate Derivation" to get ad...

Of course you can pass any string into the job. But how are you planning to use it? The ODBC stages require the DSN to be separate.

Do these columns have default values defined at any point in the processing?

WHAT about "auto commit"? Auto-commit simply means one row per transaction. Array size should also be 1.

Generated or user-defined SQL? Inspect the query to see which names in it have double-quotes around column names.

You can store the join result wherever you like. But why not use a Data Set rather than a Sequential File stage? That way your data will retain its partitioning and - if any - sorting.