TRANSPOSE

This procedure computes the transposed matrix C from matrix A.

Usage

The TRANSPOSE stored procedure has the following syntax:

TRANSPOSE(matrixA,matrixC)

Parameters

matrixA: The name of input matrix A.; Type: NVARCHAR(ANY)
matrixC: The name of output matrix C.; Type: NVARCHAR(ANY)

Returns

BOOLEAN TRUE always.

Examples

call nzm..shape('1,2,3,4,5,6,7,8,9,0',2,4,'A'); 
call nzm..transpose('A', 'B'); 
call nzm..print('A');
call nzm..print('B');
call nzm..delete_matrix('A');
call nzm..delete_matrix('B');

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

 TRANSPOSE
-----------
 t
(1 row)

               PRINT
---------------------------------------
 -- matrix: A --
 1, 2, 3, 4
 5, 6, 7, 8
(1 row)

               PRINT
-------------------------------------
 -- matrix: B --
 1, 5
 2, 6
 3, 7
 4, 8
(1 row)

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

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