DB2®Blob Class

Represents the BLOB Db2® data type. Encapsulates the byte[] .NET data type.

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

Syntax


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

Example

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

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

      DB2DataReader reader = myCommand.ExecuteReader();

      if (reader.Read())
      {
          DB2Blob selectValue = reader.GetDB2Blob(2);

          if (!selectValue.IsNull) { return selectValue; }
      }

      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.