DSXchange

Unless you are referencing and writing to the same hashed file in ONE Transformer stage, buffering of any sort between the reference and write will cause inconsistencies in the result. Thanks for that information Ken. Luckily the one transformer is writing and referencing the hash file this time. B...

You sound surprised. :lol: I am constantly surprised :) No, they don't need to be the same per se. However, with your previous settings the sending of the Inserts to the database were being deferred until it had 100 to do, while each Update went immediately. If the Update of an Insert went before t...

And disable read and write caching, as well as turn OFF row buffering or inter-process. If necessary, deselect Use Project defaults to force no buffering. Unfortunately there is also a previous partitioning stage that requires the inter-process to be turned on, else all the sequential files contain...

chulett wrote:Ok... then let me know what happens when you change your Insert Array Size to 1.

OMG it works. Actually if I set the update array size to 100 it works also.
So it seems that they array sizes have to be the same for it to work?

First question would be are you updating records you've just inserted or pre-existing records in the database? I'm guessing you're not updating just inserted records or you'd be feeding inserts back into the hashed file. Actually I am doing an update on just inserted records - and I am feeding inse...

Hi all Not sure if anyone can help, but just in case somebody has had a similar experience. My issue is that it appears that the update statement when loading into an Oracle db using OCIORA8 stage does not seem to be working. The perplexing thing is that I have other jobs which do exactly the same t...

There could be other nuances as well that would make it prudent to give a default value in your job rather than let the database default it. 1. Be sure to check for empty strings as well as NULL. I know that our Oracle DB treats an empty string as NULL and even if you have 'not nullable' set in the ...

Just an update to this problem, for everyones info. I don't think it was caused by the propogating of the columns or lack thereof. I was having the same issue in ver6, where I was using the sequence /----> Seq1 / OraOCI8 ---> Trf ---> Partition < \ \----> Seq2 No matter which partition algorithm I u...

Excellent. Thanks for that information Craig. I knew about the XP Pro bit but I wasn't sure if there was anything else.

As for the upgrade itself - by the time my client gets around to actually deciding on an upgrade we could well be up to version 9 Damn beaurocracy.

Hi All The client I am currently on is contemplating an upgrade from version 6 but are thinking about upgrading to version 7.5 (Server Edition). Arising out of this is a couple of questions: 1. Should they even bother? I mean should they just go straight to 8? Will IBM still support an upgrade to 7....

Just as an aside - we populate our oracle tables with a JobID so that we know which records were updated by which jobs. This makes it very easy to determine which job was loading the table. Of course this only works to determine which job loads the table, if there is data in the table already.

pradkumar wrote:They DO match

Just looking for the obvious solution first - so there are no extra spaces in either table, non printing characters etc?

Hi In ODBC1 , I am joining few tables. and based on the key columns obtained from it I am doing a lookup with the key columns present in ODBC2 to pull out one column. When I designed the joba nd ran it, it gets executed but no lookup is performed. What might be the problem? At a guess - your keys d...

Actually I am more interested in the treatment of a NULL in a HashFile where that NULL is part of the key. Will this be interpreted as a @NULL.STR when entered as opposed to null? After trawling the forum - I think I have found part of my answer. I always thought that you couldn't enter NULL into a...

Given that 128 is 10000000 in binary it may be that Oracle, set to use ASCII (which, technically, is a seven-bit encoding) ignores the high-order bit. I'm just guessing here, of course. Actually I am more interested in the treatment of a NULL in a HashFile where that NULL is part of the key. Will t...