Direction Property

Gets and sets the parameter direction. It indicates whether the parameter is passed to the Advanced SQL Engine as input, returned from the SQL Engine as output, or sent to and returned from the SQL Engine as input and output.

Syntax

Visual Basic
C#
C++/CLI

'Declaration
 
Public Overrides NotOverridable Property Direction As ParameterDirection

'Usage
 
Dim instance As TdParameter
Dim value As ParameterDirection
 
instance.Direction = value
 
value = instance.Direction

public override ParameterDirection Direction {get; set;}

public:
property ParameterDirection Direction {
   ParameterDirection get() override;
   void set (    ParameterDirection value) override;
}

Property Value

One of the System.Data.ParameterDirection enumeration values. The default is Input"/>

Exceptions

Exception	Description
System.ArgumentOutOfRangeException	Argument is not a valid `ParameterDirection`

Remarks

ParameterDirection.InputOutput and ParameterDirection.Output apply only to Teradata stored procedures. Output parameters reflect the stored procedure results after the specific result set(s) is processed. For example, the output parameters to a stored procedure represented as the third statement in a multi-statement request are not available while application is processing the first and the second result set. In this case the output parameters are available after the second call to TdDataReader.NextResult. If TdCommand.ExecuteNonQuery executes the command, then the data provider processes all result sets and populates the output parameters.

Requirements

Target Platforms: Windows 8.1, Windows 10, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019

Reference

TdParameter Class
TdParameter Members