DSXchange

It depends. You can tune memory consumption in the Sort stage explicitly for that stage. And "performance" needs to be defined.

The command string limit is about 2000 characters, but seems to be version-dependent. Your use of the DATA stack is entirely valid.

Is this a parallel job question (you posted in the parallel forum) or a server job question (you identified the job type as "server")?

It's not a question of preference - they all do different things.

You don't handle the situation that there are more than 25 jobs in the file. And where does MAX_SIM_RUNS get set?

Do you make sure that the Routine returns 0 (if you are using an OK or Failure trigger anything but zero is regarded as failure)? If you do need to return specific values, make sure that you handle these with triggers, rather than relying on the default (which seeks a zero versus non-zero return val...

Welcome aboard. The Lookup stage is one of many stages you can use in a parallel job. Its task is to retrieve zero or more rows from a data set that match supplied key value(s). For more information read the chapter on the Lookup stage in the Parallel Job Developer's Guide Attending an entry-level c...

The number of columns in a hashed file need not be fixed. Therefore probably the best estimate you can get is SELECT MAX(EVAL "COUNT(@RECORD,@FM)+2") AS Columns FMT '7R' FROM [i]hashedfile[/i]; Of course, this is not possible from a shell script without invoking a DataStage...

But you never did get an answer about daylight saving time. Nor is there a ready answer. You could interrogate the system's time zone setting, and trust that it has been set correctly. You could rely on the legislation about the changeover dates, but these may change in future (they are changing thi...

What I meant was that Central time in Australia is currently 9h30 ahead of GMT.

This has nothing whatsoever to do with the Central time zone in the USA.

Just map the month number onto the quarter number.
1,2,3 -> 1
4,5,6 -> 2
7,8,9 -> 3
10,11,12 -> 4
The easiest way to do this is with arithmetic - take the month number, add 2, then take the remainder after integer division by 3.

You're not done yet. What is it that is causing the activity to fail? If it's the Execute Command activity, this is an exit status other than zero; you may need to make a small adjustment in your shell script ( exit 0 ). You still have not properly gathered the command output either - or, if you hav...

Will you STOP using the Field() function until we can sort out exactly which field you want?

Where are you calling the SDK routine UtilityWarningToLog from?

True. But you hardly ever need them in a Transformer stage.

Allocate more space (or more file systems) to scratch disk in your configuration file.