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