COPY_SUBMATRIX - copy a rectangular block of a matrix

This procedure creates a matrix from the specified rectangular block of the input matrix. This is an wrapper for the BLOCK stored procedure.

Usage

The COPY_SUBMATRIX stored procedure has the following syntax:
COPY_SUBMATRIX(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.

Examples

CALL nzm..SHAPE('0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16',4,4 ,'A');
CALL nzm..copy_submatrix('A', 'B', 2, 3, 1, 4);
CALL nzm..print('A');
CALL nzm..print('B');
CALL nzm..DELETE_MATRIX('A' );
CALL nzm..DELETE_MATRIX('B' );

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

 COPY_SUBMATRIX
----------------
 t
(1 row)

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

                 PRINT
-----------------------------------------
 -- matrix: B --
4, 5, 6, 7
8, 9, 10, 11
(1 row)

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

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