DSXchange

Lookup stage supports conditional lookup. That is, some condition that has to be met before the lookup is even attempted. Therefore there are separate rules available for handling the "condition not met" situation, where the lookup was not even attempted, and the "lookup failed" situation, where the...

Get data, stack and memory increased, ideally to unlimited.

Chances are that your company has blocked access to these "mail" email addresses. Check with the mail administrator.

In case you still want to use a User Variables activity, be aware that it has the wierdest grid control - it's completely blank when opened (no grid). You have to right-click and choose Add New Row. That's how you declare a variable in a User Variables activity. Fill in the variable name and its der...

Can you "see" the directory (folder) on the file server as a shared folder? If so, you won't need FTP. DOS does not have an equivalent of find , but DataStage does. It's called uvwalk and can traverse a tree structure if required. However, DOS also lacks a wc command, and uvwalk does not report the ...

The behaviour you see suggests that your "accept this row" condition, i.e. (terminationdate > actualopendate AND terminationdate < actualclosedate) is not being met for any input row, or that your lookup is not succeeding (in which case the two date columns on DSLink2 will be NULL and can never sati...

It might be better to copy the first argument into a local variable, so that the original string (first input argument) is unaffected (as is the case with the BASIC Ereplace() function).

Such dates are not guaranteed to sort correctly. Convert them to internal format (or to YYYY-MM-DD format) and use these forms in your constraint expression.

True. The Link Collector stage creates a process of its own; therefore to communicate with other active stages some form of inter-process communication mechanism is required - inter-process row buffering must be enabled (which is made very clear in the manual). If you want visibility of the bufferin...

What are the UNIX ulimit settings for the user ID under which DataStage jobs are executed (on each machine in the cluster)?

Only single-character delimiters are supported. You will need to change your file, or process it as a single field and decompose it using Field() functions in a Transformer stage. There will be empty fields between adjacent pipe characters that you can ignore.

You may need two cascaded Pivot stages to achieve what you describe.

Quite possibly because /apps/source/dsCBAF_QX_100071.ds does not exist. Please describe your job design, in particular where Data Set stages have been used. And verify whether /apps/source/dsCBAF_QX_100071.ds actually exists on the server. If it does, try to open it using the Data Set Management uti...

The reference Data Stage for a Lookup stage MUST be able to fit in physical memory. If you can not reduce the size of the reference Data Set so that it can fit in physical memory, then you can not use a Lookup stage. Are there any columns you are not using in the job? Don't put them in the reference...

I'm far from convinced that DSJ.STAGEINROWNUM can refer to a passive stage type - that is, a stage that connects to external storage.

Use only the list of stage names returned by DSGetJobInfo() with DSJ.STAGELIST as its second argument and see how you go.