DSXchange

How old are you? 8? Don't make me stop this car!

There is a pdf document in your Docs directory that explains the process. It's call 'multiserv.pdf' or something close to that.

How exactly was this 'resolved'? Can you please post that so the rest of the world knows? Thanks.

Sheesh, what's with all the PX answers to a Server question posted in the Server forum?

What does "not work properly" about it? How about some specifics - the exact routine you are using, your syntax and the problem you are having. That will help get us started.

Umm... you need to run it from 'DOS' rather than 'TCL'.

I, for one, have never seen an 'Allow Multiple instance error', so not really sure exactly what that means. It would probably help to post your actual error message(s) if you still need help.

Why not take a peek at the Encode Stage and Decode Stage chapters in the Parallel Job Developer's Guide pdf?

Right, it would be just a string. Seems like you'd need to pull out everything between the 'FROM' and 'WHERE' keywords, then parse that into individual table names.

Something like that, anywho.

Cool! :D

I'll have to work something like that into my troublesome little loop, and an annotation to explain why in the heck I'm doing it.

I don't even know if there is such a thing, hence the suggestion to talk to your DBA - they'd be the only ones that could change it I'd wager.

Must be some kind of 'per connection' limit setting on the database. Check with your DBA.

rafik2k wrote:Is that same site for downloading blat.exe?

Yup, that's the one. Very nice email client. One of my clients used to use the UNIX version, lots of nice little features in it.

Welcome! :D

You'd be better off posting in the TX forum, that's where all the Mercator folks seem to hang out.

I've seen the same behaviour. I once tried to add a simple 'Otherwise' trigger to a job activity inside a Loop in addition to the 'OK (Conditional)' trigger already present. The moment I did that, it would always take the Otherwise path. Never did figure out why and had to move on to other things...