DSXchange

Dear all, Actually, we are migrating from IBM Cognos Data Manager. There is a need for interim solution for Cognos Data Manager calling DataStage stages. DataStage 9.1 FP2 on AIX 7.1 Cognos Data Manager 10.2.1 FP4 on Winodws 7 SP1 DataStage Client 9.1 FP2 on Windows 7 SP1 (same machine as Data Manag...

After a number of testing, the final version I would like to share with a quite fair random... Previously, I am using a print function in C++ to observe the result (NOTE: this will not work with the DataStage because it is calling object / library only) Then, I don't need to maintain another custome...

Thanks, Ray. It's one of the possible work-around. However, it is not very ideal for getting a list of winners involving extra maintenance of table / file. At this moment, I am thinking about routine way - but it still returns duplicated results even using a seed by time. I have made a stored proced...

Thanks all. Actually, I have around 300,000 customers. If just taking random function, the customer A (say) has won the prize. Next time, it is likely to A again for the next draw. We are taking a monthly draw for VIP (frequent buyer). So, that's why I am trying to have a unique random number. Sorry...

It is aimed to have a lucky draw against the customer list

Dear all, I would like to ask for a suggestion for making a "unique" random number. For the nature of "rand()" and "random()", they are not aimed to create a unique random number. As the population of the customer list is million scale, it is not ideal to use row number...

Dear all, We just installed DataStage 9.1 on AIX 7 and encounter compile problem with transformer. We found that there is not /usr/vacpp/bin/xlC_r directory after installation of XL C/C++ . There is a similar case in dsxchange but this topic is about DataStage Release 7x http://www.dsxchange.com/vie...