DSXchange

About the only thing* that might not work using a version 7 instance would be any manually-changed VOC entries. All VOC entries generated from DataStage itself would be picked up during import of the DSX file. * apart, of course, for any components that don't exist in version 7 - but they couldn't h...

Think about what this combination of partitioning and sorting is doing. By including col3 as a partitioning key, you are placing combinations of (col1,col2) on different partitions, which is causing the duplicates. Try partitioning by col1 alone or, if it has fewer distinct values than your configur...

Jobs inherit changed NLS settings if the job properties specify "use project default" (which is the default setting). No re-compilation is necessary.

Welcome aboard.

Use Sort and Aggregator stages if you want to do this in DataStage.

Use Transformer stage to detect discontinuities and direct the flow of data appropriately to your needs.

There is no limit on the number of stage variables.

What, exactly, does "different result" mean?

I'll be there and, again, the best way to contact me is via email or through the Conference notification tool. I don't have a smart phone (a dumb phone is good enough for me) and I probably won't buy a SIM for the USA. Staying in the pyramid. It keeps me sharp! Presenting a paper with Ernie Ostic on...

Blank (" ") or empty string ("") ?

There is a difference.

I believe there is an environment variable that controls this behaviour into Oracle, but can't bring it to mind at the moment.

Perhaps you could research it?

Use a server Sequential File stage, either in a server job or in a server Shared Container in your parallel job. Server Sequential File stage can be configured to handle values that contain line terminators. Scroll right in the Columns grid to find this property. Parallel Sequential File stage canno...

Version 11.3.1 has been released. Almost the same as 11.3.0, but supports Oracle and Microsoft SQL Server for the metadata repository database.

(No information yet on which particular version(s) of Oracle and Microsoft SQL Server. Stay tuned.)

What character set is Teradata using? When you import the Teradata table definition, what is the reported size of this column?

1) No. Though you can create environment variables using Administrator client that you can subsequently use in DataStage jobs. (I believe this was available in 7.x). 2) The Transformer stage cannot perform sorting. You can use the Sort stage. Ultimately, though, both sorting within DataStage and the...

Your default timestamp format (which you can view/change in the Administrator client) does not include fractional seconds. Therefore you must do one of the following things: change your StringToTimestamp() functions to include a format string that includes six fractional seconds change your hard cod...

Sort-merge collector does not re-sort the data (blindly or otherwise). It depends on the fact that the data are sorted already, partition by partition, on the indicated key, and monitors the next value queued to come in from each partition, transferring the one that is next in sorted order. Auto doe...

There's also "Getting Started" and "Planning, Installation and Configuration Guide" and "Director Client" PDFs (and many others).

If you prefer a web site try IBM Knowledge Center - change the version number as required (e.g. 8.7 to 9.1 or 11.3).