Re: Stored Procedures

["Charly Jones" <charly301@xxxxxxxxxxx>]

I believe RAND was introduced as an SQL scalar function in V4R5
if you want to generate a random floating point number.  As someone
else suggested, you would have to check for a duplicate because a
"random" number does not guarantee a "unique" number.

Charly Jones

>From: "Mark Phippard" <MarkP@softlanding.com>
>
>Is it possible to create the table in QTEMP?  Then you might not need to
>worry about the name so much, since each job has its own QTEMP.
>
>                     "Rodriguez, Jose
>                     Amable"
>
>I've got a simple question.  I'd like to be able to code a stored
>procudrure in SQL that creates a temporary table.  The idea is that I need 
>a unique number to add to the end of the table name (e.g. TEMP12345).  This 
>way if two instances of the stored
>procedure are running, they don't bump into one another.
>
>Does anyone know of a random function or of a way to access a unique number 
>within the stored procedure for this purpose?
>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---