IBM Mainframe Forum

I would like to share some info. I am not sure if it has already posted. Am very sorry if it is already
published.

We can get the randomly generated numbers in db2 using a function called "RAND" it can be used as RAND()

This is very usefull when you want the randomization logic in your code. For example if you want the
db2 to return different set of rows(while using cursors) every time you query on table.

Let me know if you dont understand anything.

Hello,

If i run the same query multiple times, why might i want inconsistent results (i.e. a different set of rows returned)?

How does using a cursor relate?

Why might i want "randomization logic" in my code?

Dick i am sorry . its not different set of results , its same result in the different order.

Randomization , I will give you an example.

You own a company(Insurance provider) , many agents are working in your company and you have a online application where in end user or the customer or a common person wants to check the agent detail in there locality using(zip code,first name,last name...etc)

When you execute a query on the table you will get set of agents which are in that particular zip code.If the agent list is big , you can show first 10 - 15 agents details on 1st page and remaining details in next pages. Since there is a high probability that the end user will choose the agents which are in 1st page and they will not browse further. Other agents will loose the oppurtunity to get the customer.

In this case we can go for the randomiztion logic , each time u execute a query u get a same results in different order.

Hope this helps!!!!