DSXchange

Which unfortunately doesn't answer my question on the Oracle side... check with your DBA if you're not sure of the difference in semantics. I'll wager DB2 is set to 10 characters and Oracle is set to 10 bytes.

And you're certain you have the correct password for ID2?

Which post?

So just your typical characterset issue with multibyte data going into (I assume) Oracle fields defined using byte semantics. How are each field defined, source and target? Specifically wondering if you are writing to a CHAR(n) where it is actually defined as CHAR(n BYTE).

As noted, because of the implied decimal you can't simple do the conversion and expect it to know what you want it to do. You'll need to do the conversion and then divide the result by 1000 to move the decimal over three places. I seem to recall some functions allow you to specify the scale so it ca...

They all "work" just some are monitored more closely than others. And I was specifically told to have people use the one I posted as the others are spam magnets and anything real there gets lost in the flood. Still only been under two days... I would wait until next week before you decide ...

Sure... let's start by getting you into your own post rather than at the end of something (mostly) unrelated. And since you've never posted here before, can you confirm your server platform - UNIX or Windows? I took a guess.

Width in bytes. UTF-16LE is a multi-byte character set where each character is stored in 2 bytes (16 bits) hence the doubling you see. And "LE" is for Little Endian.

Doesn't the Designer already generate a report like this?

Sorry, missed the point that it was only ever two. Then just two targets and constraints to send the rows to one or the other based on your row number. I would leverage the Mod() function and switch the output immediately after the result = zero, meaning you've just written the 10th record to the ta...

Been discussed here quite a bit, here are some random examples. Can depend on how you want to control the naming of each file. The last one is specific to the 9.1 release as they added that functionality to the Sequential File stage in that release. Any other solution would be more of a 'workaround'...

And your target is?

These functions are documented and that would be explained there. It signifies the "occurrence" of the substring, here meaning the first.

Correct. Two links from the Transformer to the target, one for inserts and one for updates.

I deleted the duplicate 'urgent' topic you opened with this exact same question in it. Let's play here. The code you posted is fine in spirit but the syntax is wrong. You cannot use an "or" there, you need to repeat the test for each thing tested for. And with zero being equal to FALSE and...