Develop partitioning using the PARTITION BY <expr> clause on the TABLE parameter to a TPF function. As a UDF developer, use the table parameter metadata attribute EXTFNAPIV4_DESCRIBE_PARM_TABLE_PARTITIONBY to programmatically declare that the UDF requires partitioning before invoking it.
The examples illustrate:
- Various SQL writer scenarios where the UDF describes partitioning requirements to the server
- Valid queries and invalid queries (SQL exceptions) for each scenario
- How the server detects mismatches
- The various possible combinations that arise from usage of the PARTITION BY SQL clause and the EXTFNAPIV4_DESCRIBE_PARM_TABLE_PARTITIONBY UDF attribute