DSXchange

Only supply to the delete the columns needed to identify the rows to be deleted. Chances are you only need one, and it will bind onto :1.

If you've got parameter marker :5 then you've got to do something with :1 through :4 (and, indeed, any beyond :5 that you may happen to have).

Does anyone happen to know where the BGA settings (in particular server, port, user name and password) are stored on the client machine?

Users can, by default, change their BGA settings, including user name and password. We're operating in an Active Directory environment so this is a Bad Thing. If user forgets to change BGA settings after changing AD password, they might well lock themselves out of everything (and annoy the people wh...

Would you be content with a Routine (which could be invoked from a sequence job)? FUNCTION ResetJobs(IgnoreMe) $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF JobList = DSGetProjectInfo(DSJ.ME, DSJ.JOBLIST) Convert "," To @FM In JobList Ans = 0 ResetCount = 0 Loop Remove JobNam...

I would expect the error message to name the segment file it couldn't find in that case, not the descriptor (.ds) file.

You seem to have a mix of delimiter characters in your data ("|" and ","). You may need to read the start date and end date as a single field and parse them subsequently. Also check that the correct delimiter (as per your metadata) terminates the transaction date field.

Check particularly the user name and password that the job uses.

At the moment, and in general, Information Analyzer is only capable of processing data rules within the same row or across all rows in the data set (for example EXISTS < n times). Rules that compare between adjacent rows can be implemented in DataStage, but not yet in Information Analyzer. PS I'd be...

What value? What unit of measurement?

It's not clear in a general sense. You need to document, them implement, each possible combination.

DB2 Connector?

They do. It's available through Software Services. But you have to agree to your data being "offshored" to their Bangalore labs, where I suspect that the "tool" is actually someone's brain.

See if you can talk to a site that is using a comparably sized configuration, for example Target Corporation (they have offices in Minneapolis and Bangalore). One of their configurations has 10 processing nodes and 24 DB2 nodes (12 for reading, 12 for writing).

The silly one was having an operating standing by, watching the job, ready to yank the power cord of the server.