tdr.GetLocalOrderByDef Function | R Table Operators | Teradata Vantage - 17.10 - tdr.GetLocalOrderByDef - 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)
Returns a list of triplets, one for each column in the LOCAL ORDER BY clause of the specified input stream. Each triplet is a vector that consists of the following:
  • A column name
  • The ordering of the column ("A" = ascending or "D" = descending)
  • An indication of whether NULLS FIRST ("F") or NULLS LAST ("L") was specified for the column

Syntax

tdr.GetLocalOrderByDef(  streamno  )

Syntax Elements

streamno
Parameter type: integer

The input stream number.

Example: Get the Columns in the LOCAL ORDER BY Clause

Consider the following LOCAL ORDER BY clause for input stream 0:

LOCAL ORDER BY col1 ASC NULLS FIRST, col3 DESC NULLS LAST

The following statement retrieves information about the columns in the LOCAL ORDER BY clause and prints it.

print( tdr.GetLocalOrderByDef( 0));

The output of the print statement is as follows:

[[1]]
[1] "col1" "A"    "F"

[[2]]
[1] "col2" "D"    "L"