SIMPLE2RCV

This procedure transforms a "simple" matrix table to a row/column/value representation.

Usage

The SIMPLE2RCV stored procedure has the following syntax:
SIMPLE2RCV(inTable,idColumn,colPropertiesTable,outTable,byValue)
Parameters
inTable
The name of the input table.
Type: NVARCHAR(ANY)
idColumn
The name of the column containing the row index values.
Type: NVARCHAR(ANY)
colPropertiesTable
The input table where column properties for the input table columns are stored. The format of this table is the output format of stored procedure nza..COLUMN_PROPERTIES().
If the parameter is undefined, the input table column properties will be detected automatically.
Type: NVARCHAR(ANY)
outTable
The name of the output table.
Type: NVARCHAR(ANY)
byValue
The name of the column which will be used to distribute data. In the result table it is called as id_task.
Type: NVARCHAR(ANY)
Returns
INTEGER The number of matrix columns found in the input table.

Details

The input table must have a column containing the row indices. The remaining columns, named "v1", "v2", and so on, contain the matrix element values. The number of matrix columns must be less than 1600. To add a consecutive ROW index column to a table containing a non-consecutive unique ID column, a query such as: CREATE TABLE SIMPLE3 AS SELECT *, ROW_NUMBER() OVER (ORDER BY ID) AS ROW FROM SIMPLE2; can be used. The nzm..CREATE_MATRIX_FROM_TABLE procedure can be used to create an nzMatrix from the row/column/value table produced by this procedure.