DSXchange

Why, look at that... yes you did. Guess we should read your pithy replies once in a while.

Ah... there you go - cycle through one value. Thanks James.

Moved.

I don't have any way to check directly but it should be a 'Generate' option and the need to set it to something other than 'Cycle'... I think. Poke around and see if you can set it to generate a constant value... or perhaps cycle a number by 0? :? And there's no "performance" problem with ...

Then, as noted, see if you can correct the key fields you are using to properly identify the single record you are trying to update. Once your update only affects 1 record, the warnings will go away.

Call it what you like, I'm trying to assertain if you are updating 16 rows in the one update you posted on purpose (i.e. it was expected) or by accident and it was an unexpected result. The former you may have to take up with your DBA while the latter could be because (for example) your key choice w...

Answer my question, please... are you intentionally updating multiple records in the target table with each record you process?

The key piece of information is the 16 Rows affected part, which is an extra informational message the database is returning and which causes DataStage to generate the warning. What database is this? Are you purposefully trying to update multiple records at a time?

StringToDate() (and DatetoString) would be PX functions and not applicable in a Server job. The equivalent would be IConv and OConv. However, somewhat as noted, you can put the date into a string format that Oracle is expecting and your target stage should generate the appropriate SQL to do that. Me...

How many nodes are you running on and how are you partitioning the data?

That would be the 'create' part I mentioned.

Find or create a static value to group on.

Since i am working in Server job, i was not able to use NulltoEmpty() function. Of course you can use it... but it will do exactly what you've already done. If it is "not working" then you either don't have nulls, are confusing an empty string with a null or have an Oracle target where yo...

Did you make sure you installed the two clients in completely separate paths?

Curious what you think is going to happen to your poor Windows server when you attempt to start 100 jobs (parallel or otherwise) at anything approximating the same time?