CEIL_ELEMENTS - elementwise ceiling function (entire matrix operation)

This procedure implements the element wise ceiling function.

Usage

The CEIL_ELEMENTS stored procedure has the following syntax:

CEIL_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.

Details

The ceiling function outputs the smallest integer that is not less than the argument.

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..CEIL_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)

 CEIL_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
(1row)

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

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

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