HCL.Data.Informix 4.7.0.2026

HCL Informix .NET Provider

This README provides a brief overview of the Informix .NET Provider and instructions on how to integrate it into your project and run it.

Description

Informix database provider for .NET Framework. This package contains all the necessary native libraries and resource files needed for connecting to an Informix database server.

Installation

To integrate the Informix .NET Provider into your project, follow these steps:

1. Install .NET SDK: Ensure that you have the .NET SDK installed on your system. You can download it from the official .NET website.

2. Add Provider Package: Add the Informix .NET Provider package to your project using your preferred package manager. For example, if you're using NuGet, you can add it by running the following command in the terminal:

   dotnet add package HCL.Data.Informix
   

3. Reference Provider in Code: After adding the package, reference the provider in your code where you intend to use it. Import necessary namespaces and classes to access its functionalities.

Usage

Once you've integrated the Informix .NET Provider into your project, you can utilize its features according to your requirements. Here's a basic example of how you can use it:

using System;
using HCL.Data.Informix; // Import HCL.Data.Informix Provider

class Program
{
    static void Main(string[] args)
    {
        // Connection string for Informix database
        string connectionString = "Database=sysmaster;Host=host1;Protocol=onsoctcp;Server=ol_informix1410_1;Service=13808;User ID=informix;Password=mypassword";

        // SQL query to select a row from a table
        string query = "SELECT * FROM systables WHERE tabid = ?";

        // ID of the row you want to select
        int tabId = 101; // Change the row ID as per your requirement

        // Create a connection to the Informix database
        using (IfxConnection connection = new IfxConnection(connectionString))
        {
            try
            {
                // Open the database connection
                connection.Open();

                // Create a command to execute the SQL query
                using (IfxCommand command = connection.CreateCommand())
                {
                    // Set the SQL query and parameter values
                    command.CommandText = query;
                    IfxParameter param1 = new IfxParameter(null, IfxType.Integer);
                    param1.Value = tabId;
                    command.Parameters.Add(param1);

                    // Execute the query and retrieve the data
                    using (IfxDataReader reader = command.ExecuteReader())
                    {
                        // Check if there is any data returned
                        if (reader.Read())
                        {
                            // Retrieve data from the reader (change column names as per your database)
                            int id = reader.GetInt32(reader.GetOrdinal("tabid"));
                            string name = reader.GetString(reader.GetOrdinal("tabname"));
                            // Add additional columns as needed

                            // Print the retrieved data
                            Console.WriteLine($"TABID: {id}, TABNAME: {name}");
                        }
                        else
                        {
                            Console.WriteLine("No rows found.");
                        }
                    }
                }
            }
            catch (IfxException ex)
            {
                // Handle any exceptions
                Console.WriteLine($"Informix Exception: {ex.Message}");
            }
            finally
            {
                // Ensure the connection is closed
                connection.Close();
            }
        }
    }
}

Running the Application

To run your application after integrating the Informix .NET Provider, execute the following command in the terminal within your project directory:

dotnet run

The Informix .NET provider relies on accessing certain native libraries and resource files. Therefore, to execute it, you must define specific environment variables depending on the platform.

on Linux use:

informix@host1:/work$ INFORMIXDIR=bin/Release/net47/native/ 
LD_LIBRARY_PATH=$INFORMIXDIR/lib 
dotnet run
TABID: 101, TABNAME: systabnames
informix@host1:/work$ 

on Windows use:

d:\work\cs>set PATH=%cd%\bin\Release\net47\native\bin;%PATH%

d:\work\work\cs>dotnet run
TABID: 101, TABNAME: systabnames
d:\work\cs>

Note: For Linux systems, ensure that the INFORMIXDIR and LD_LIBRARY_PATH environment variables are set. On Windows, update the PATH variable to include the native directory before running the dotnet run command, and remove any INFORMIXDIR entries from the environment variables.

Support

If you encounter any issues or have questions regarding the Informix .NET Provider, contact HCL Customer Support

For detailed guidance on effectively utilizing this component, refer to the resources and documentation available at Informix .NET Provider.