DSXchange

isulpova wrote:The paths are actually absolute

Sorry, for some reason when I was looking at this originally, I thought I saw a space before the ".."

OK, so off we go to the Server forum. Since a transformer can't have two stream inputs, how are you bringing them in? HF1 is the stream input and HF2 is a reference input? Can we assume that 'policy number' is the key field in both hashed files and your reference lookup is based on that key? Please ...

First question - is this actually a Server job as you've marked it?

Secondly, what is your job design? How are you bringing two files in and comparing them "in transformer"?

If, on the other hand, you ask whether it is possible to include a parameter within a job parameter, the answer is also no.

No, it's not a space and would not be useful in removing them. For a space, you can simply use " " or CHAR(20) if you prefer.

So nothing really helpful, unfortunately. Please post details of your job design and I'd also be curious what exactly you are doing in the OCI stage... is the stage generating the SQL or are you using something "user generated"? The more details you can provide the better and it might help...

Post the entire, unedited error message. Also include anything "From previous run..." if that log entry shows up when you Reset the aborted job.

Are you certain you are looking in the right place for the log file? It's a relative path so it would be relative to the job's Project directory.

One man's obvious is another man's wtf. Sure, it "should be" (hence the smiley in my post) but honestly, why would I want to report on how many "zeroes, ones and twos" each project had? Was just suggesting that the OP take a moment to lookup what each value means so there's no am...

For Server routines, I've always found the best 'study guide' to be the included SDK routines themselves. Double-click on each to see their properties where the usage guide typically is and to see their source code. Work your way through them to get a feel for what functions are typically used. Then...

1. If you want to be able to process A and B at the same time, yes.

2. Yes, that's how it works. The Designer only shows stats for "non multi-instance" job runs.

I'd go back to your admin team as that sounds very DB2 specific.

http://dbaspot.com/db2-udb/169323-error ... abase.html

ray.wurlod wrote:Or don't even worry about the values, just report them.

Unless you're not sure which is which.

Replace "ishome" with where your software is installed... and I fixed the link you posted so it actually works.

I'd suggest starting by doing an exact search here for something like "the library was compiled on a system that is incompatible with this system".