tdr.SetLocalOrderByDef Function | R Table Operators | Teradata Vantage - 17.10 - tdr.SetLocalOrderByDef - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)

Sets the ordering specification for a specified input stream.

Syntax

tdr.SetLocalOrderByDef(  streamno,  lorderbydef  )

Syntax Elements

streamno
Parameter type: integer

The input stream number.

lorderbydef
Parameter type: list
A list of vectors with the following:
  • Column names
  • Ordering of the columns
  • NULLS FIRST/NULLS LAST indicators

Usage Notes

This function is valid only if called from the contract function.

The function must run on a PE-only node.

An error is raised in the following situations:
  • The function is called from the table operator.
  • The LOCAL ORDER BY metadata was already set.

Example: Set the LOCAL ORDER BY Specification for an Input Stream

The following statement sets the LOCAL ORDER BY specification for input stream 0 to be col1 ASC NULLS FIRST, col3 DESC NULLS LAST.

lorderbydef <- list(c("col1","A","NF"),c("col2","D","NL"))
tdr.SetLocalOrderByDef(0, lorderbydef );