DB2 Version 9.7 for Linux, UNIX, and Windows

DB2Clob Class

Represents the CLOB DB2 data type. Encapsulates the string .NET data type.

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

Syntax

[Visual Basic]
Public Structure DB2Clob
[C#]
public struct DB2Clob
[C++]
public value class DB2Clob

Example

[C#] The following example demonstrates how to retreive a single CLOB column value from a table.

[C#]
  public static string getParam(DB2Connection conn)
  {
    string mySelectQuery = "SELECT * FROM EMP_RESUME";
    DB2Command myCommand = new DB2Command(mySelectQuery, conn);

    DB2DataReader reader = myCommand.ExecuteReader();

    if (reader.Read())
    {
      DB2Clob selectValue = reader.GetDB2Clob(2);
      if (!selectValue.IsNull) { return selectValue.ToString(); }
    }

    return "NULL";
  }

Thread safety

Any public static (Shared in Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Version information

Last update: This topic was last updated for: IBM DB2 Version 9.7
.NET Framework version: Supported in: 2.0, 3.0, 3.5 and 4.0
IBM Data Server Client: Supported in: IBM® DB2® Version 9 through Version 9.7