GUID function for DB2 backend database

[ccbarbeau]

Good afternoon,

I have a project where I need to have the user enter a number of parts that he wants to see. I need the report to pull said number of RANDOM parts from the several hundred thousand in the list. The only way I've found to achive this is to use the NewID() function and then use a running count as a detail filter. The data however is in a DB2 database and will not accept the NewID() function.

Short of having the function added to my function library, is there any other way to acheive the result I require?

Thanks!