DSXchange

About the Oracle Sequences - true you can use them, just said I prefer not to. For low volume loads I've done reference lookups much like Ray described and incurred the sql call to Oracle for every record passing through the job. Interesting in that I don't recall having to have a key expresssion in...

When we tried to use ora bulk load option in data stage for stage to target, we were not able to use becuase of restriction we are using triggers for loading surrogate key column. First suggestion would be... don't do that! Build your surrogate into the process of 'landing' your staging data so tha...

If your license limit is 2, then at any point in time only 2 Datastage clients (Manager, Director, Designer) may be open. I'm afraid that's not true. Your limit (in the later versions) is meant to be the number of concurrent users that can connect to the server at any given point in time. There is ...

The 'average' calculation the Aggregator does is based on the average value of a field over the number of rows passed through the stage. Which you discovered. If you need it based on your two fields, I'd suggest passing two data fields through the agg - first the two multiplied together and secondly...

If all you meant was that you were processing a flat file where the first record is the column names and you wanted to automatically skip the first record - you should have said that, because that's simple. If that *is* what you are doing, then as Ray noted simply check the 'First line is column nam...

Find your client cdrom and look for the 'unsupported utility' HFC - the Hashed File Calculator - on it. That will help you answer questions like this.

Use @INROWNUM instead.

Not sure what to make of that. According to Ray's explanation, that shouldn't be happening on a single userid system. And all I was saying is I've always worked on installs where only one was used and have never seen the 'printer segment' message.

For whatever that is worth...

Replace the 'bang' (exclamation point) with whatever you are using it to mean - like the keyword 'Or' I would guess.

Interesting... it didn't sink in that the OP said there isn't the dslictool file. Wonder if they really meant "is".

Why not try searching the forum for 'dslictool'? You'll find several posts discussing what it is and how to use it. Then come back if you have specific questions.

gwen wrote:Is there any patch for windows XP SP2 that will fix this kind of problem?

Yes, there is! You can download it from Ascential's eServices website.

Lots of ways. One way would be to stop putting the pipe in the field to begin with. Other than that, there are several functions that can do that for you. Ereplace is one that is simple to setup and you could use after you pull the value from the hash to replace the pipe with a space or an empty str...

Note the change Ken made to the key expression logic. Any kind of 'math' on the field will (in essence) convert it to a number. So do something that you know won't change the value of the field - like adding zero to it - rather than adding and subtracting 1 from the value. Both work and illustrate ...

PhilHibbs wrote:Do you mean ipcs and ipcrm? (thanks to Google for that suggestion)

Yes, he did.