DSXchange

All valid dates are valid in DataStage. (baglasumit21's understanding is not correct.)

There is no year 0 - the day before 1 Jan 0001AD was 31 Dec 0001BC.

Check your century rules in the interface with Teradata. The restriction might be being imposed there.

Server side tracing can be enabled/disabled from the DS.TOOLS menu on the server, or via the DS.TRACE menu or TRACE command, in a dssh shell.

There are many differences between Windows and UNIX, some subtle, some decidedly unsubtle. You appear to have encountered one of the subtle ones. Without access to DataStage source code, it is impossible to answer whether this difference is in DataStage itself or in the system calls made on the diff...

You seem to have a leading quote character and no trailing quote character. Or two leading quote characters but only one trailing quote character. In short, your data contain an extraneous quote character. The only way you can handle this in DataStage is to read the data without quote characters (sp...

Assuming you are in an after-job subroutine, you use DSGetJobInfo(DSJ.ME, DSJ.INTERIMSTATUS) to return the job status. You use DSGetLogSummary() to return the log summary, and Index() to search its result for the "No rows affected" message. In a script the job will have finished, so the job status w...

Why is this on a DataStage forum?
Ought it not to be on a UNIX or shell scripting forum?

This warning is issued solely because you have server side tracing enabled in Administrator. It alerts other client users that there will be performance degradation. Server side tracing can inflict about a 10% performance degradation. The solution is to disable server side tracing (on the Tracing ta...

2775, surely? Actually, just 775 will do. Prefer 2770 or 770 if there are nosey people on the server.

And what happens to all the other sequences in SDKSequences if you arbitrarily re-create the hashed file?!!!

You have specified Same as the partitioning algorithm (either directly or as the default chosen by Auto). The number of partitions upstream, however, is irreconcilable to the current number of partitions (set to 1, perhaps through use of a single node node pool, perhaps through enforcing sequential ...

The file being referred to is DSParams. UFD is an abbreviation for "user file directory" - that is, directory - and refers to the project directory on the server. So, translated, the message is telling you that there is no parameter file record in the DSParams file in the project directory on the se...

Then it's too large. It may be too large for more (you could experiment). Otherwise you need to unzip to disk and run awk over that. Use redirection operators - you could add an rm command to the end of the pipeline of commands.

You owe Craig some dollars or doughnuts - it wasn't really clear which!

In my case no; the very fact that they choose spam as their advertising channel would be a big negative for me (not to mention illegal here).