CEIL_ELEMENTS - elementwise ceiling function

This procedure implements the element wise ceiling function.

Usage

The CEIL_ELEMENTS stored procedure has the following syntax:
CEIL_ELEMENTS('matrixIn','matrixOut',row_start,col_start,row_stop,col_stop)
Parameters
matrixIn
The name of the input matrix.
Type: NVARCHAR(ANY)
matrixOut
The name of the output matrix.
Type: NVARCHAR(ANY)
row_start
The first row of the input matrix to use.
Type: INT4
col_start
The first column of the input matrix to use.
Type: INT4
row_stop
The last row of the input matrix to use.
Type: INT4
col_stop
The last column of the input matrix to use.
Type: INT4
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', 2, 2, 3, 3);
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
(1 row)

                                              PRINT
-----------------------------------------------------------------------------------------------
 --matrix: B--
0, 1.1, 2.2, 3.3
4.4, 6, 7, 7.7
8.8, 10, 11, 11.11
12.12, 13.13, 14.14, 15.15
(1 row)

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

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