CONCAT - concatenation

Implements concatenation, either vertical or horizontal, of the two matrices passed in the parameters.

Usage

The CONCOT stored procedure has the following syntax:

CONCAT(NVARCHAR(ANY) matrixIn1,NVARCHAR(ANY) matrixIn2,NVARCHAR(ANY) matrixOUT,concat_type)

Parameters

matrixIn1: The name of the first matrix to be concatenated.; Type: NVARCHAR(ANY)
matrixIn2: The name of the second matrix to be concatenated.; Type: NVARCHAR(ANY)
matrixOut: The name to use for the resulting concatenated matrix.; Type: NVARCHAR(ANY)

concat_type: The concatenation type. Valid values are 'v' and 'h'.; Type: NVARCHAR(ANY)

Returns

BOOLEAN TRUE, if successful.

Details

With vertical concatenation, the number of columns remains constant. With horizontal concatenation, the number of rows remains constant.

Examples

CALL nzm..shape('1',3,3,'A');
CALL nzm..shape('2',3,3,'B');
CALL nzm..CONCAT('A', 'B', 'C', 'v');
CALL nzm..print('C');
CALL nzm..delete_matrix('A');
CALL nzm..delete_matrix('B');
CALL nzm..delete_matrix('C');

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

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

 CONCAT
--------
 t
(1 row)

                             PRINT
-----------------------------------------------------------------
 -- matrix: C --
1,1,1
1,1,1
1,1,1
2,2,2
2,2,2
2,2,2
(1 row)

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

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

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