DB2Parameter.Unassigned Field

DB2®Parameter.Unassigned Field gets a DB2Parameter object with the IsUnassigned property set to true.

Namespace:: IBM.Data.DB2
Assembly:: IBM.Data.DB2 (in IBM.Data.DB2.dll)

Syntax


[Visual Basic]
Public Shared ReadOnly Unassigned As DB2Parameter
[C#]
public static readonly DB2Parameter Unassigned
[C++]
public:
static initonly DB2Parameter^ Unassigned
[JScript]
public static final var Unassigned () : DB2Parameter

Remarks

This static field can be used to create a parameter set up to use the data server defined default value.

Example

[C#] The following example demonstrates the creation of a DB2Parameter using the static unassigned field.

[C#]
// Assume a DB2Connection myConn
DB2Command myCmd = myConn.CreateCommand();
myCmd.EnableExtendedIndicators = true;
myCmd.CommandText = "INSERT INTO myTable VALUES(@p1)";
myCmd.Parameters.Add(DB2Parameter.Unassigned);