Home
Client APIs and toolsYou can use the HCL Informix® implementation of client APIs to develop applications for Informix® database servers.
.NET provider optionsThe Data Server Provider for .NET DB2® provider option is the preferred Informix® provider for developing new applications.
Informix® .NET Provider GuideThe Informix® .NET Provider Reference Guide contains the information you need in order to use the Informix® .NET Provider to access and manipulate data in HCL Informix® databases.
Mapping data typesThese topics describe how data types are mapped between HCL Informix® databases and the .NET Framework.
Set data types for a parameterYour application should set the type for a parameter as the HCL Informix® type whenever possible (using the IfxType argument of IfxParameter constructor).

Set data types for a parameter

Your application should set the type for a parameter as the HCL Informix® type whenever possible (using the IfxType argument of IfxParameter constructor).

IfxType enumeration shows the IfxType enumeration.

You can specify a parameter type as a .NET DbType instead, and the Informix .NET Provider will infer the Informix type as best it can. The .NET DbType specifies the data type of a Parameter object of a .NET Framework data provider. Some DbType types, such as GUID, do not map to any Informix type, and an error will be returned. Some DbType types, such as AnsiString, can map to several Informix types, such as VARCHAR, TEXT, or BLOB; you must be aware that the Informix .NET Provider may not choose the data type you intend.

If you do not specify either the Informix data type or a .NET DbType, the Informix .NET Provider attempts to infer the Informix data type from the value itself. For example, if the value is 4, the provider maps this to an INTEGER data type. Relying on these inferred mappings can lead to unexpected results.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.