DSXchange

Get rid of the Field() function, at least temporarily, or provide a large-valued fourth argument to it.

Yes to all, but you will need to purchase some additional components, called the "Java PACK" and, possibly, "SOA Edition". May I ask why you went with SSA rather than with QualityStage? it is far easier to integrate QualityStage into DataStage real-time processing than to do so with the SSA software.

HOW does "the back-end database populates the 4th column using the system date"? Is this a trigger or a default value?

Did you specify authentication details (hostname, user ID and password) in the dsjob command? If not, try doing so and let us know if that works.

In Director, choose Job > Clear Log.

In the dialog that follows, select the Immediate purge option, but change the conditions in the selection frame so that, instead of purging all events, purge only those more than one day old.

Check the permissions on the project directory and on the DSParams file.

If the DSParams file is missing, find out who deleted/renamed it and castigate them severely.

The "why"" is that that's not a valid DataStage BASIC statement.

You can only call SQL through BCI functions or external scripts.

If my DS Server job aborts how do I capture the status? I want ideally want to capture the status into a column in transformer stage. Thanks1 If the job aborts, it's aborted. You can't capture anything in the job - it's already aborted. You must test the status in the job sequence that runs the job...

The "DSU." prefix tells us that this routine (DSU.CreateHashFile) was created at your site; it is not one "out of the box" in DataStage. So if there's no source code, then we can only assume that some consultant created it and removed the source code. You can determine the number of arguments using ...

Before we go on, have you read the manual for the CFF stage (cff.pdf)? There are examples and discussions there that may quench some of your thirst for knowledge, and save me transcribing slabs of that document!

DSExecute is a BASIC function, and therefore not available in a Wrapped stage. The UNIX command you use in a Wrapped stage is just the command itself (the second argument of your DSExecute call). Read about the Wrapped stage (there's even an example) in the Parallel Job Advanced Developer's Guide (a...

If you do want the database to perform the truncation, specify it as CHAR(10) and extract it using the SUBSTRING function in SQL. Otherwise extract as Char(40) and use an appropriate function (such as Left()) or a substring operator to obtain the leftmost 10 characters. In all of this, although you ...

The quick fix is to add 86400 to the seconds whenever this occurs.

But it IS sloppy coding!

This post while unrelated to the current problem (wraparound of seconds through midnight) is nonetheless scary.

Probably the easiest would be to start the dsrpcd with logging, and inspect the logs periodically. I can not think of any mechanism that allows you to filter out connections from clients based on the particular client software that is being used - the dsrpcd mechanism is totally general purpose. You...

There is a one-day certification exam preparation class ( code DX224). For those contemplating taking the exam at IOD 2007, they are running the class on Sunday, October 14.