DBAS400Connector 1.0.0

DBAS400Connector

TheDBAS400Connector NuGet package enables .NET applications to connect to IBMiSeries or IBM Power systems running the OS400 operating system via ODBC. Thispackage simplifies interaction with DB2 databases, allowing developers toexecute non-query statements and retrieve data through various methods.

Keyfeatures of the DBAS400Connector include:

• Non-Query Execution: Execute SQL commands that do not return results, such as INSERT, UPDATE, and DELETE statements.

• Data Retrieval: Obtain data from the database in multiple formats, including:

With thesecapabilities, the DBAS400Connector makes it easier for .NET developers to workwith DB2 databases on IBM iSeries systems, enhancing productivity andsimplifying database interactions.

Obtainingthe IBM i Access Client Solutions ODBC Driver

The IBM iAccess ODBC drivers can be downloaded from the following IBM site as long asyou have an account to log in to the IBM download site.

https://www.ibm.com/support/pages/ibm-i-access-client-solutions

There is anODBC driver available that runs on Windows, Linux, MacOS and there is also anative IBM i ODBC driver available.

SampleIBM i ODBC Connection String

In order touse this connection string you must already have the IBM i Access ODBC Driverinstalled on your Windows, Linux or Mac computer.

How to usethe connection

using DBAS400Connector;

usingSystem.Data;

usingSystem.Data.Common;

DB2Connector connector= new DB2Connector();

// Connectto system using only ODBC Driver Name, system IP or system name, user andpassword instead of connection string

Boolean iSeriesConnected= connector.OpenConnection("iSeries Access ODBC Driver","192.168.0.1","usr01", "Pa$$word");

// ExecuteSQL query to results DataTable

DataTable _mytable= DataTable();

If(iSeriesConnected)

{               _mytable  = _ connector.ExecuteQueryToDataTable("SELECT * FROM QIWS.QCUSTCDT");

// Iterate and output desired columns toconsole

foreach(DataRow _row in _mytable.Rows)

{

Console.WriteLine($"Cusnum:{_row["CUSNUM"]}Lastname:{_row["LSTNAM"]} Init:{_row["INIT"]}");}

}

SampleIBM i Connection Strings

https://www.connectionstrings.com/ibm-i-access-odbc-driver/