DSXchange

D'oh! How did that get by me?

No such thing, all that is controlled by environment variables in Windows. Meaning, UNIX only.

Here's a freebie and all I'm going to say on the specific subject of db connection from a routine - search here for "BCI" and then clear your calendar.

Can you define that part of the data as a separate field? If so then just check that field directly. If you can't, you check the last character of the field and then multiply the rest. Assuming the latter: If Link.AmountField[1] = "-" Then Link.AmountField[1,Len(Link.AmountField)-1) * -1 E...

Treat the sign as a separate field and when it is "-" multiply the amount by -1.

Already did.

Who knows? You haven't told us what the error is that you get, what "not able to login" means, for instance. For all we know, you may not be remembering the system password correctly.

A "transform routine" is written in BASIC and called in a PX job's BASIC Transformer derivation. From there, just let the job write it to the database.

It helps to actually ask a question, that's how everything starts here.

Have your DBA monitor the table. Not a table lock but row-level lock collisions are your problem, I'd wager. Does it work with 1 node? How are you partitioning the data across nodes when there are multiple nodes?

Can you not just "Search" for it in Windows Explorer? Should be wherever you installed things, in a directory called "DSEngine".

"Routine" = what here? Before/After/Transform BASIC routine? External C++ routine? :? Short answer is don't do it. Use 'normal' mechanisms to do that, i.e. a job that takes that result as a parameter and does the db insert. A Sequence job would make the linkage trivial. Long answer is sear...

My bad on the address versus line thing. :( Explosions like this with OCI involved are generally caused by bugs in the Oracle client, from what I've seen. I know, I know, hard to imagine saying "Oracle" and "bugs" in the same sentence, but it has been known to happen. On occassio...

I have sent the code to your email,as it was not possible to attached in forum. Just to run this into the ground, there's no mention of the word "attach" or "attachment" here. Simply copy / paste from the source to your post, making sure you enclose what you paste in with code t...

:roll: OK, I didn't ask you to email it to me but rather post it here so everyone can be involved in either the solution or the learning. And I told you what "code" was needed, the contents of the specific "TRANS3" file noted in your error message. What you sent was an export of ...

Or just contact your support. You'll either find out the real maximum or get a patch if this is a bug. Or both.