DSXchange

So what you're looking for is an awk expert?

Can you filter it (in the External Filter stage) with grep, which may be more efficient, and in which it's easier to filter the logical inverse (that means using the -v option in the grep command).

No. You have the date, so you can get the day number. If the day is Sunday and the day number is less than or equal to 7, then it's the first Sunday in the month. Otherwise it's not. You can do this in a Nested Condition activity with some User Variables, or you can use a Routine activity.

Then ask the peiple on the other end of the Citrix connection to make the PDF files available, perhaps on an intranet, perhaps via email.

You can do a lookup against any stage type, including Sequential File. At least that's how you design it. What actually happens is that the output of that stage is loaded into a virtual Data Set, then the Lookup stage performs its lookups against that virtual Data Set with the aid of a lookup table ...

Do you want to estimate virtual memory requirements or scratch disk requirements? They are not the same things. For example, scratch disk can be used when allocated memory is exceeded, even though there is plenty of free virtual memory - for example in the Sort stage you can limit the amount of virt...

If it's to be called by another application (including DataStage) it must not have a main() declaration. You create the code using any text editor and compile it outside of DataStage. You must also create a "Parallel Routine", which is a record in the Repository of the existence, location and argume...

There's usually a default value property under the data type specific properties (for example in the String Type properties if the data type is string). The default behaviour can not be disabled. The only way you could raise a warning would be to generate an in-band null and detect this downstream. ...

Mostly unique

Close but not quite. It's actually the amount you'll spend on consulting services after upgrading. IBM consultants underwent their intensive version 8 training three weeks ago in this part of the world.

When you attempt to make a not null column contain null, its Null Field Value (if any) is substituted; failing that its Default Value (if any) is substituted. For a VarChar, the default Default Value is "".

How to do every second comma using tr command?

APT_DUMP_SCORE will always help - it's the only way you can determine what is/was executed. Which is not always what you designed - it gets optimized, for example, and some of the design errors and omissions are silently corrected.

Odd. The parallel Transformer works fine for thousands of others.

For whatever reason, your filter command has failed. There is only one corrective action: fix it. Perhaps you do not check for non-existence of its source file?

Use sorted (by ID) input and stage variables to detect change and increment/reset sequence number.