Order Input Table Data

Either a SQL Analyst or the UDF developer can order incoming data.

A SQL Analyst controls ordering by including the ORDER BY clause in a SELECT statement.

The UDF developer controls ordering by using the DESCRIBE_PARM_TABLE_ORDERBY attribute.

Both methods result in the server ordering the incoming data, the results of which can be see in the query plan in the Order node.

Related reference
EXTFNAPIV4_DESCRIBE_PARM_TABLE_ORDERBY Attribute (Get)
EXTFNAPIV4_DESCRIBE_PARM_TABLE_ORDERBY Attribute (Set)