The a_v4_extfn_partitionby_col_num enumerated type represents the column number to allow the UDF to express PARTITION BY support similar to that of SQL support.
typedef enum a_v4_extfn_partitionby_col_num { EXTFNAPIV4_PARTITION_BY_COLUMN_NONE = -1, // NO PARTITION BY EXTFNAPIV4_PARTITION_BY_COLUMN_ANY = 0, // PARTITION BY ANY // + INTEGER representing a specific column ordinal } a_v4_extfn_partitionby_col_num;
Member of a_v4_extfn_partitionby_col_num Enumerated Type | Value | Description |
---|---|---|
EXTFNAPIV4_PARTITION_BY_COLUMN_NONE | -1 | NO PARTITION BY |
EXTFNAPIV4_PARTITION_BY_COLUMN_ANY | 0 | PARTITION BY ANY positive integer representing a specific column ordinal |
Column Ordinal Number | N > 0 | Ordinal for the table column number to partition on |
This structure allows the UDF to programmatically describe the partitioning and the column to partition on.
a_v4_extfn_column_list nopby = { EXTFNAPIV4_PARTITION_BY_COLUMN_NONE, 0 };
The EXTFNAPIV4_PARTITION_BY_COLUMN_ANY member informs the server that the UDF supports any form of partitioning.
a_v4_extfn_column_list nopby = { 2, 3, 4 };