DSXchange

You should be able to pass that 'missing' information through the stage I would think, which is what - the WS Transformer?

Edit/Delete post is only letting me edit, not delete the extra post caused by hitting back in my browser. So sorry for the extra post (this one). You can delete a post as long as no-one has replied to it yet, which is why I always check for duplicates right away if there's any delay in posting... d...

Or the ROWNUM system variables - @INROWNUM or @OUTROWNUM. Or a database sequence. The answer can depend on if you need to worry about concurrency or not.

Ray is being... funny. You'll get used to his sense of humor. Eventually.

When dealing with Oracle, I still prefer the OCI stage over DRS (even though they both use a native connection) for a couple of reasons. One is it has more 'update action' choices and two, it uses numbered bind parameters rather than the pita positional question marks like ODBC. But that's just me. ...

How should i take care of Oracle SID? I don't have tnsnames.ora file any where on my unix box. You don't need $ORACLE_SID set for this to work. You do, however, need a tnsnames.ora file somewhere on the server. It will look for one in $ORACLE_HOME/network/admin by default or you can set $TNS_ADMIN ...

Interesting, that would definitely be something to check on for Oracle as well.

RaviReena - yes, definitely. Chat with your DBA as they should be the ones making any kind of change like that.

I would say so - what are the permissions on that file? Sounds like you will need to have your DBA open things up a bit.

Make sure you are pointing to the 32bit Oracle libraries in your environment variables. That would typically mean changing '$ORACLE_HOME/lib' to '$ORACLE_HOME/lib32'.

Does this post help at all?

viewtopic.php?t=116311

To the best of my knowledge and from various discussions here (like this one which talks about why the stage came into existence) there really shouldn't be any difference in performance. It still uses the same ODBC or native drivers under the covers that the dedicated stages would use for that conne...

rachit82 wrote:

chulett wrote:I'd be surprised if you could actually pass @SM or @VM characters into the test harness correctly.

I have not passed any @VM or @SM expressions. i have passed the equivalent delimiters

Which is exactly what I meant.

I'd be surprised if you could actually pass @SM or @VM characters into the test harness correctly.

Why not humor us and pre-create the hashed file manually as a -64BIT hashed file and see if it then works?

For the sake of our sanity, can you explain in words what this routine is meant to accomplish / return? I really don't want to infer anything based on a reading of the code.