DSXchange

Index(InLink.TheString, ".", 1) will return 0 if there is no "." and a positive number if there is.
(InLink.TheString Matches "1N0N" : @VM : "1N0N'.'0N") will test for unsigned numeric formats.

It uses your currently logged drive. This is typically the one on which DataStage engine is installed.

That's only if unique AND stable sort are selected.

That's not the same as "MCT" conversion, which would convert "paddy o'brien" to "Paddy O'Brien". The suggested "solutions" would yield "Paddy o'brien".

They are not supported in parallel jobs because the hashing algorithms are buried deep within the DataStage server engine, which is not necessarily accessible from every node on which a parallel job may be executing. System cached won't make any difference if only one job is accessing the hashed fil...

MKS Toolkit expects UNIX pathnames. UNIX pathnames don't have drive letters. Also forward slash must be used as the pathname delimiter.

The Remove Duplicates stage allows you to specify whether to keep the first or last record in each group. A unique sort does not.

I don't know of one. You can, of course, write your own. If you do, why not publish it here so others can follow where you lead?

This option is NEVER enabled for parallel jobs.

The only ways you can limit rows are to design it in to your job, or to compile in trace mode.

Orphaned data files out there on your resource disk. (From memory the data files' names include the name of the control file. This is certainly true for Data Sets.)

The Transformer stage properties page has a Build tab where you can provide replacement compiler options to override those given for the job.

Check that your DataStage license is valid and not expired.

That's why the webinar "Files in DataStage Job Sequences" was produced.

Go to http://www.dsxchange.net/webinar_training.html for more information.

Welcome aboard. Open the job in Monitor (Director client, select job, choose New Monitor from Tools menu) and determine whether the stages have finished. Does the job have an after-job subroutine? Can you access Cleanup Resources from Job menu in Director? If so, can you find the process(es) associa...