DSXchange

The most likely DataStage NLS map for parallel jobs is GBK given your stated requirement.

You might also like to investigate GB2312 or GB18030 or their variants (for example GB2312-80).

So input of 95.67 yields 0.009567 (five decimal places)?

sajidkp wrote:try setting the execution mode to sequential in the stages

That is useful for diagnosing problems with partitioning but is never a solution for anything. Why did you bother purchasing a parallel execution engine?!!

If you set Allow Null Output (I couldn't recall the property name) then it might eliminate the warning. No idea why, but it might be worth a try.

There's always message handlers!

Have you set any of the null-handling properties of the Aggregator stage itself?

How did that work in scenario 2? Did you always get four decimal places in both scenarios?

What have you tried? It is not possible to change the value of a job parameter within the job while the job is running, and separate jobs run in separate processes so can not access each other's environments. So even if a job could change the value of an environment variable, once it exits back to i...

So it's not really an average. Its the cumulative total of the months this year up to and including the month previous to the current one, to which is added the current month's figure divided by one less than the number of months in the calculation. The stage variables described earlier can still be...

Clearly, something in Oracle.

But we need more information about precisely what you're asking the Oracle stage to do, and what indexes and constraints might exist on the target table.

So "rolling average for a month" is really simply "average for that month". Is that correct? That is, is the granularity still "month"? You also seem to be confused over what you want. You specify rolling average, but talk about totals in your expected results. Some cla...

All sequence jobs. That way any warning propagates all the way up to the top level, and you can handle them all there.

devnhi wrote:Is there any way , I can match exactly with the same string

Not without far more detailed knowledge of the structure of inpin and outpin record structures in DS_JOBOBJECTS table. This information is not pubished by the vendor.

Moderator: please move to server forum

Check the "Log warnings for activities that finish with a status other than OK." check box in the sequence compilation options.

No, the owner/creator of the table always has full privileges without the need to be a DBA. That all developers are DBAs has the same consequences as making them DBAs in any other database: DBA is just another way to spell "God" in this context. DBA privilige can be revoked from one user b...

That would not be a twelve-month moving average. Any N-period moving sum/average needs to have N-periods worth of data.

This new one is a totally different requirement. Can you specify the expected result?