%RandomNatural meta-SQL element

Syntax

%RandomNatural(Number)

Description

The %RandomNatural meta-SQL returns a random natural number (integer) between 1 and the number specified in the parameter.

Parameters

Parameter	Description
Number	Specify a natural number (integer).

Example

Here is an example:

/*Populate Staging Table and assign partition number*/
SQLExec("INSERT INTO PS_DP_STG_JOB (qe_job_opening_id,PROCESS_INSTANCE,ptsf_dp_nbr) select qe_job_opening_id , 0,%RandomNatural(:1)  from PS_QE_ALL_JOBS_VW ", &nPartCnt);
SQLExec("COMMIT");