DSXchange

ray.wurlod wrote:You can build your Lookup File Set on the five digit key, and allow duplicates.

Exactly what was already suggested. Without the 'allow duplicates' part as that didn't seem necessary. I guess if it comes from Ray it's a 'good point'.

Yes. And I'm sure it's been explained here a number of times. For grins I did a search and found something I started 5 years ago when all there was was the Oliver mailing list. It will look a little strange because of the email nature of the exchange, lots of things repeated, but it goes deep into t...

All of the actual parameter names are missing from your string. And you've got an odd mixture of quotes there. Open up the DSSendMail routine by double-clicking on it in the Administrator and check the Long Description for details on exactly how to call this routine.

yes I have few records in the table. My requirement is to develop the job using parallel extender not server. [sigh] Shouldn't you be using the appropriate tool for the job? Don't you have more than one tool in your toolbox? You need to read a teeny number of records and send emails and you are "re...

I don't see an answer to the 'what is your update action' question. Are these strictly 'Insert without clearing' records? If so, why not bulk load them?

Oh, and please delete the duplicate post in this forum before someone replies to it.

How is this any different than your other post in the Server forum? Hint: nothing. Granted, you should have started here, but let's not start all over again here. Folks, if you feel the need to contribute to this thread, please do so in the linked post, not here. Or at least check it first.

The lookup and join stages appear to expect "keys" but I havnt been able to figure out how to do a lookup based on a LIKE statement. Any suggestions? What our friend should have just come out and said directly is - you can't. Lookups are equi-joins. He's trying to offer you a solution where the loo...

By using Append option in one file will take care of this. Err... two links writing to the same file at the same time, one with the append option? No can do, my friend. If you could manage that in a serial fashion where the overwrite link completes before the append link starts, only then is that a...

Nope, recompiling isn't the answer. The long way? Export and re-import all of your jobs, they'll pick it up then. Or if you are interested in a more elegant solution, get access to Ken Bland's website (he posts as 'kcbland' here) and download his Job Control Utilities package. One of the many things...

Is this a Server or Parallel job question? They have slightly different answers. Typically: Server: Folder -> XML Input -> Transformer -> ODBC Parallel: Sequential -> XML Input -> [optional something something] -> ODBC Use the first stage to supply just the filename(s) to process. Set the XML Input ...

It would help if you explained under what circumstances you got this error. What was the complete error you received? What other information was logged at the time, either immediately before or after it?

In other words, use just the Web Service Transformer in your job and dump the 'ws client' stage.

Use the Client stage when all you want to do is source from a web service.

Most brain dead way:


You'll get one extra record for the category itself, can't remember the magical syntax to exlude that from the list. I'm sure it will be along shortly.

Nope, same one.

Use of this driver requires the Oracle client to be installed. The question will be, do you continue to use the 9i Client to connect to the 10g instance or switch to a 10g Client? Do you use OCI stages or just ODBC? Do you support a mixture of 9i and 10g targets?