DSXchange

ahmedwaseem2000 wrote:...the job works fine but the row is not being updated...

On what basis does "the job work fine?"

The 32-bit Oracle client CAN "talk" to 64-bit Oracle.

Five IPC stages. But these also take physical memory (for the buffers). Why can't your design take physical memory?

"IBM - Solutions for Business" was big blue's major campaign in 1999. This one never made it to air.

At this site someone has taken the trouble to explain Benford's Law.

It may have some application in surrogate key distribution under partitioning, but I doubt it.

It's correct. 20 is the space character. Bytes are reported in hexadecimal.

Tip: disable smilies to prevent the symbols. Edit your previous posts and disable smilies in them.

Does strstream.h existand, if so, where? Is is apparently being mentioned in /opt/Ascential/DataStage/PXEngine/include/apt_util/strstream_s.h

Are you seeking my opinion as a technician or as an IBM shareholder?

Are you loading a partitioned DB2 table?

Oh no, not yet. Are you fully cognizant of the implications of the various partitioning algorithms? What if you need to join, aggregate, remove duplicates or other key-based activities downstream? You can't use Round Robin then.

OK, you can, but not if you want correct results.

How about including or generating a line number when reading the file, then partitioning two way - or splitting into two streams within the job, based on Mod(RowNumber,2)? Then use different Transformer processes to parse the different line structures, and re-join them (Join stage) based upon the li...

Welcome aboard. :D Does this occur if you use auto-generated DBoptions, supplying user ID and password through explicit properties? (Yes, I know the array size will default in this case, but let's get the password issue solved first.) If this works, what is in the DBoptions property? In particular, ...

Look at the SQL. What format string is being used? Do your data for the timestamp match this format string?

I suggest that you also open a case with support. The more people it's biting, the more priority it's likely to get in IBM.

DEFFUN is definitely the requirement.

So too is less haste!