DSXchange

That was going to be my first question - why do you believe they need to be merged?

I don't recall anything available in the RTI/SOA world that would allow 'HTTPS transfers'. Perhaps you are thinking of the Click Pack?

Seeing as how hashed files are specifically designed for use as reference lookups, the answer is pretty much always hashed files. There can be specific instances where a database stage can be 'better' but under extremely limited circumstances. What exactly is the definition of an 'unconnected lookup...

Why overly complicate it when it is simple to effect from a Sequencer job as explained in other posts? Your approach requires something other than the branded ODBC drivers that ship with DS and the hand code would be difficult for the Average Joe to uderstand and maintain.

Better to take the 'dsjob' approach as it is more 'future proof'. IMHO.

You could also 'Validate only' a similar job from a Sequencer.

Why do you think you need to compile jobs from the command line? It usually means that someone doesn't know how to properly reset a job and are using it to handle aborted jobs, which is not the right way to go. In any case, search the forum for dscc and you should turn up plenty of posts on the sub...

Archives the log after the execution of job to a separate directory.... That doesn't explain anything, just repeats what you are doing. A detailed explaination of your technique was requested in order to properly assist you. I don't see how simply writing two different files (these archives are two...

Why would they ever be 'needed' back in the actual job log? Access them where you've decided to archive them...

Yah, I got the 'lots of hits' as well and saw the 'subroutine failed to complete successfully' discussions but they weren't all that helpful as you (and I) have noted. Grep'ing for 30107 in all the *.h engine files got me the same thing. The thing is, the Sequencer job this script kicked off is stil...

Another 'first' today. We have a 'standard' script that basically runs a DataStage job and then reports the status back to the caller, typically Ctrl-M. Amongst other things it does is it calls 'dsjob' with these as part of the command line: -run -mode NORMAL -jobstatus Today was the first day after...

Don't believe that's the case. The volume using it is so low the fact that only one 'invocation' of it is running at any given time really shouldn't be the issue. My BEA folks feel it has something to do with the Connection Pooling and the lack of the ability to 'test' connections automatically with...

Simple - you can't 'remove the keycolumn'.

Having a new problem with some 'RTI Enabled' jobs and not sure which 'side' is having the issue. They are using HTTP over SOAP bindings, Oracle as the repository and WebLogic on the RTI Server side. This is an example of what is returned when one of the jobs is called: Tue Apr 04 15:28:14 MDT 2006 -...

I am trying to write single row from the multiple rows. Ok. A couple of different ways... one is concatenating several records into a single record using stage variables. It can be problematical because you need to 'write behind' as you go when the 'key' changes. Or a simple Server solution is to u...