FLOOR_ELEMENTS - elementwise floor function (entire matrix operation)

This procedure implements elementwise rounding to the next smallest integer.

Usage

The FLOOR_ELEMENTS stored procedure has the following syntax:

FLOOR_ELEMENTS(matrixIn,matrixOut)

Parameters

matrixIn: The name of the input matrix.; Type: NVARCHAR(ANY)
matrixOut: The name of the output matrix.; Type: NVARCHAR(ANY)

Returns

BOOLEAN TRUE, if successful.

Examples

CALL nzm..SHAPE('0,1.1,2.2,3.3,4.4,5.5,6.6,7.7,8.8,9.9,10.10,11.11,
 12.12,13.13,14.14,15.15,16.16',4,4,'A');
CALL nzm..FLOOR_ELEMENTS('A', 'B');
CALL nzm..PRINT('A');
CALL nzm..PRINT('B');
CALL nzm..DELETE_MATRIX('A');
CALL nzm..DELETE_MATRIX('B');

 SHAPE
-------
 t
(1 row)

 FLOOR_ELEMENTS
----------------
 t
(1 row)

PRINT
------------------------------------------------------------------------------------------------------
 -- matrix:A --
 0, 1.1, 2.2, 3.3
 4.4, 5.5, 6.6, 7.7
 8.8, 9.9, 10.1, 11.11
 12.12, 13.13, 14.14, 15.15
(1 row)

PRINT
-------------------------------------------------------------------
 -- matrix: B --
 0, 1, 2, 3
 4, 5, 6, 7
 8, 9, 10, 11
 2, 13, 14, 15
(1 row)

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

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