CREATE_RANDOM_MATRIX

This procedure creates a new matrix filled with uniformly distributed random values greater than or equal to zero and less than 1.

Usage

The CREATE_RANDOM_MATRIX stored procedure has the following syntax:
CREATE_RANDOM_MATRIX(matrixOut,numberOfRows,numberOfColumns)
Parameters
matrixOut
The name of the matrix to be generated.
Type: NVARCHAR(ANY)
numberOfRows
The number of matrix rows.
Type: INT4
numberOfColumns
The number of matrix columns.
Type: INT4
Returns
BOOLEAN TRUE, if successful.

Details

This procedure uses drand48_r.

Examples

CALL nzm..CREATE_RANDOM_MATRIX('A', 5, 15); 
CALL nzm..GET_NUM_COLS('A'); 
CALL nzm..GET_NUM_ROWS('A'); 
CALL nzm..ANY_NONZERO('A'); 
CALL nzm..DELETE_MATRIX ('A' );

 CREATE_RANDOM_MATRIX
----------------------
 t
(1 row)

 GET_NUM_COLS
--------------
 15
(1 row)

 GET_NUM_ROWS
--------------
 5
(1 row)

 ANY_NONZERO
-------------
 1
(1 row)

 DELETE_MATRIX
---------------
 t
(1 row)