DSXchange

The instructions worked just fine for me but then I'm on 7.5.2. Did you highlight the Column for Calculation then scroll the Available Properties to Add over to the right? ... Yes I did..all I could see are many options but not Preserve Type. The availabe properties are: Corrected Sum of Squares Ou...

please explain me in detail where actually in aggregator stage do we have the option Stage --> properties --> Agrregations ---> aggregation type calculation --> click on column for calculation --> see in available properties to add . I am working on 7.5.1 OS: Unix, but i do not see this option in A...

please explain me in detail where actually in aggregator stage do we have the option Stage --> properties --> Agrregations ---> aggregation type calculation --> click on column for calculation --> see in available properties to add . I am working on 7.5.1 OS: Unix, but i do not see this option in A...

chulett wrote:Floating point. ...

Any idea on how to resolve this?

The answers to the other questions are important as well. Also, how are you detecting that the output is different? Are there just 2 output rows and values are different? If so, what is the output col ... I have given all the required information for the questions... if i run for the first time i a...

(a) the names of your grouping columns - Amount Type (b) the names of your hash key columns - Amount Type (c) the names of your sort key columns - Amount Type (d) the Aggregator operation method (hash or sort) - Sort ... And Amount Type has only 2 values in my data sample. The data is static, I am r...

Hi, The requirement is to aggregate the Amount column based on Amount Type. I am dealing with the data of around 45 million and currently it has only 2 amount types. I am getting different results each time i run the job. I used to Sort method with a preceding Sort stage and Sort on Amount type with...

chulett wrote:I'm assuming this 'production' is a separate server, yes? Is this your first attempt at running any jobs there? ...

yes it is a separate server and this is the first attempt.

Hi All, we have moved our jobs to production and to our surprise the first job in the flow abended with the following error: Unrecognized Argument: & in all the DB2 Enterprise stages from where we are reading the UDB tables. we did not face this issue in dev.all the jobs ran smoothly. any help o...

today when i tried to run the same job...voila it ran......but my happiness was short lived as another job failed with same set of errors


still not able to figure out, what exactly the problem is

And followed up with an extremely slow response... don't really have an answer, is the issue happening on the read or the write? You have to be proud of yourself though, you've achieved the impossible Impossible code statement reached I did the Impossible...but even DS did..till yesterday this job ...

Thanks Kryton for the quick reply!! Would imply the server rejected your connection... What is the extra information within: main_program: Unexpected exit status 1 (...) main_program: Unexpected exit status 1 (...) it is actually the same error msg repeated thrice. Would imply the server rejected yo...

Hi all, a job which used to run normally before is abending now with , following error messages main_program: Unexpected exit status 1 (...) 5615 FATAL Wed Mar 11 18:59:10 2009 FUNL_Combine,3: Failure during execution of operator logic. 5618 FATAL Wed Mar 11 18:59:10 2009 FUNL_Combine,3: Fatal Error...

peddidsx wrote:This might with the columns with the same name in both master link and reference link which are not used as a key.Try by removing un-used column with the same name in the reference link.Hope this should work

I do not have any column with same name from both the ref link and the primary link...

keshav0307 wrote:Is it sparse lookup or normal lookup?
what is the read method?

It is a normal look up...and read method is user defined query