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"