DSXchange

The security column is part of 3 columns that make up a key. If you were to describe to me a situation where a row is found/notfound when one of those 3 columns has other rows like itself, my guess would be 99% right that you have a metadata issue. What you write to a hash file has to be read from t...

Yes, but make sure both tables are also in the table entry box and you construct a where clause.

When I say one security I mean a set of rows with the same value under the column security. Then those rows mean nothing to each other, because they are different natural key combinations. Therefore, your problem is most likely NOT related to this column, unless it just happens to be pointing to an...

Well, Kim and I verified your example data should work. Now how about actual data? From your stated example, "security" is only 1 column of 3 on which you have to match a lookup. When you say "one security in the input file", are you saying one row, or one set of rows with the same "security" value,...

Input data: SECURITY START DATE TYPE RATE 101 1/1/2001 00:00:00 MATURITY 100 Now here is my lookup hash file - SECURITY START DATE TYPE SURROGATEKEY 101 1/1/2001 00:00:00 MATURITY 111 In this case, the input row should match the hash lookup based on what you are saying. If the lookup row is already...

If you split your data into 8 parts, and run 8 instances to process the data, you need to make sure that rows that need to be handled together go to the same instance and you DON'T use any caching. Think of this as a single job, whereby the first row has to be seen by the second row. You can only do...

Just to be absolutely sure, the jobs are running fine, it's the GUI clients that are on your PC that are having problems. Not just Director, but Manager and Designer as well. Are you running a lot of jobs when the clients lose their connections? A heavily loaded server with a lot of activity can cau...

What is breaking? Is your Director client session breaking, or are all client sessions (Designer, Manager, Director) breaking at the same time?

Is this a new installation, or an existing installation?

Actually, being connected will not prevent an export; it's only when they have objects open for editing that that object is skipped by the export process. It is sufficient, therefore, to check for locked design objects (though safer not to have any user connected). You can determine both using the ...

There's no exact way. "ps -ef |grep dsapi" will tell you of any clients connected on that server, there's no way to tell the project that they are in.

Aggregator is easiest, stage variables can be lengthy and you have that pesky problem of the last row to do with. Setup a transformer that has an output link to an aggregator. Your output link has four columns. For each row, map the source column to the appropriate target column. If that row is not ...

Oi! Barkeep! A double pangalactic gargleblaster if you please.

This reflects my attitude these days...overworked and under-intoxicated.

Ahh yes, the best drink in existence is the PanGalactic Gargleblaster, the effects of which are rather like having your brains smashed out with a slice of lemon wrapped round a large gold brick.

There's no way in the test box to enter a NULL value. Put a line of code into the routine to switch the passed argument for null, such as:

Sure, just use the dsjob command line program. I'm sure you know how to execute unix commands, so dsjob is no different.