DSXchange

Create an after-job subroutine call to ExecSH to execute a mv command to change #sct_eswm_mig.$PROJECT_PATH#/#sct_eswm_mig.$STAGE_DIR#/#OUTPUT_FILE#_#BATCH_NUM#.dat to #sct_eswm_mig.$PROJECT_PATH#/#sct_eswm_mig.$STAGE_DIR#/#OUTPUT_FILE#_#BATCH_NUM#_`date +%Y%m%d`.dat Note the use of back-quotes to c...

Is this "UNIX time" present in data (a time_t), or simply being picked up from the operating system?

How is the database type property of the Dynamic RDBMS stage set?

Sorry I'm late to this.

Index() WILL work, at least for single-character values in Link.Field1.

Further, it will be more efficient than any of the other methods postulated.

"Not working" is unhelpful to us, because you have not described precisely what you tried. It's one thing to say you used EXEC, but how can we know that you used EXEC correctly?

Which particular bug did you have in mind? Your question currently is akin to "can anybody post a list of everything that can go wrong with a car?" Or a body - doctors spend six years earning a medical degree, of which a large proportion is developing diagnostic skills. For veterinary surg...

Upstream of the Pivot stage create a column containing a comma-separated list of column names (as a literal string). In the Pivot stage include this column as a pivot key.

The "T" of ETL can rarely be done as efficiently or as flexibly in the database.

dohertys wrote:If I use a sort stage, with the setting 'Don't sort - already sorted' will it generate an error if the data is not sorted correctly?

Yes

Be very careful when making absolute assertions such as these. As always, "it depends".

Connectors are new technology. I'd report this as a bug in the connector. After all, YYYY-DD-MM does not conform to any industry standard (particularly not ODBC), and IBM prides itself on standards compliance.

The question (of which is "better") is irrelevant. Create your product so that it, too, is portable. The main precaution relates to pathnames (parameterize them) and to calls to operating system functions/commands (rely on MKS Toolkit on Windows, or avoid operating system commands complete...

They don't want to process the column name - they want to use the column name in metadata!

Learn patience.

If someone knows an answer then that someone will post it as and when they can.

Any DB2 client executable whose directory needs to be in PATH or LD_LIBRARY_PATH and isn't.

Verify that all required DB2-related information - especially environment variables - are being correctly set in the dsenv script.