Howdy. For a driver on your V5R4 you are using Odbc or? When I ask my db guy and search IBM there doesn't appear to be an option of an ADO.NET 2.0 provider for V5? Just wanting to make sure I'm not missing something obvious. V6 has one though.
On Jul 22, 6:14 am, Nexus <[email protected]> wrote: > Hello, > > As we are using DB2400Dialect on a iseries 5v4 and 6v1 provider, we > found that the BLOB and CLOB support, is not working, or you need to > specify sql-type in mapping. > > To improve this , i've implemented an DB2400V5Dialect that corrects > this behaviour and more improvements on varchar and char sizes also > added a default binary. > > Also DB2 for ISeries supports sequences > > // ReSharper disable InconsistentNaming > public class DB2400V5Dialect : DB2400Dialect > // ReSharper restore InconsistentNaming > { > #region Public Properties (1) > > /// <summary> > /// Gets a value indicating whether [supports sequences]. > /// </summary> > /// <value><c>true</c> if [supports sequences]; otherwise, > <c>false</c>.</value> > public override bool SupportsSequences > { > get > { > return true; > } > } > > #endregion Public Properties > > #region Constructors (1) > > /// <summary> > /// Initializes a new instance of the <see > cref="DB2400Dialect"/> class. > /// </summary> > public DB2400V5Dialect() > { > // Length between 1 and 32765 for nullable CHAR > RegisterColumnType(DbType.AnsiStringFixedLength, 32765, > "CHAR($l)"); > // Length between 1 and 32739 for nullable VARCHAR > RegisterColumnType(DbType.AnsiString, 32739, "VARCHAR > ($l)"); > RegisterColumnType(DbType.AnsiString, 2147483647, "CLOB > ($l)"); > // default binary size 1 mb > RegisterColumnType(DbType.Binary, "BLOB"); > RegisterColumnType(DbType.Binary, 2147483647, "BLOB($l)"); > RegisterColumnType(DbType.String, 32739, "VARCHAR($l)"); > RegisterColumnType(DbType.String, 2147483647, "CLOB($l)"); > } > > #endregion Constructors > } > > Kind regards > > Ps: Maybe not really a request for change, but still it could help > others working on ISeries DB2 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
