CREATE_RANDOM_POISSON_MATRIX

This procedure creates a new matrix filled with pseudorandom variables following Poisson distribution using the parameters Lambda and mean 1/Lambda.

Usage

The CREATE_RANDOM_POISSON_MATRIX stored procedure has the following syntax:
CREATE_RANDOM_POISSON_MATRIX(matrixOut,numberOfRows,numberOfCols,lambda)
Paramters
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
lambda
The value used for lambda.
Type: DOUBLE
Returns
BOOLEAN TRUE if successful.

Details

This procedure uses the MKL library.

Examples

CALL nzm..CREATE_RANDOM_POISSON_MATRIX('A', 5, 10, 1.2345);
CALL nzm..GET_NUM_COLS('A');
CALL nzm..GET_NUM_ROWS('A');
CALL nzm..ANY_NONZERO('A');
CALL nzm..DELETE_MATRIX ('A' );

 CREATE_RANDOM_POISSON_MATRIX
------------------------------
 t
(1 row)

 GET_NUM_COLS
--------------
 10
(1 row)

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

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

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