Library of V5R2M0 iseries access for windows

[quiconait]

Hi,

I'm using the V5R2M0 iseries access for windows version. I'm coding in c#.NET. But I can't find the library file for using the connection(), command(), etc methods.

Can anyone help me with this??

Thank's in advance,
Francisco Neto

[sakumar9]

Integration of DB2 and .Net framework ::::

Developing IBM Data Server Provider for .NET Applications
The IBM Data Server Provider for .NET provides functionality for connecting to a database, executing commands, and retrieving results. Those results can be processed directly, or placed in an ADO.NET DataSet for further processing while in a disconnected state. While in the DataSet, data can be exposed to the user, combined with other data from multiple sources, or passed remotely between tiers. Any processing performed on the data while in the DataSet can then be reconciled to the database.

To use the IBM Data Server Provider for .NET, you must add an imports or using statement for the IBM.Data.DB2 namespace to your application .DLL. For example:

[Visual Basic]
Imports IBM.Data.DB2
[C#]
using IBM.Data.DB2;Yo u also must include a reference to IBM.Data.DB2.dl l in your appication's project. In Visual Studio you can do this either from the References section for your project in the Solution Explorer, or from the Project > Add Reference menu option. If you are compiling a program from the command line for Framework 2.0 or 3.0, your csc or vbc commands should include the following option:

/r:"%DB2PATH%"\b in\netf20\IBM.D ata.DB2.dllIf you are compiling a program from the command line for Framework 1.1, your csc or vbc commands should include the following option:

/r:"%DB2PATH%"\b in\netf11\IBM.D ata.DB2.dll


Please ensure that your PATH is set to one of the dll(as per requirement) in DIR: C:\Program Files\IBM\SQLLI B\BIN\netf20
Before executing any command for interaction between IBM database and .Net

You could also install the Add-ons for VS.net shipped with DB2(Not sure if with all versions of DB2).

Commands for interaction between DB2 and .Net do have specific names- Please refer
https://publib.boulder. ibm.com/infocenter/db2luw/v9r5/index.jsp
---search for IBM.Data.DB2.Na mespace
--> Which has all commands/syntax supported by DB2 for .net applications

Could find the same with MSDN library.


Regards
-- Sanjay

[sakumar9]

If you need any help on coding c# applications, then I would suggest you to check the samples present in SQLLIB/samples/.Net/cs.

Regards
-- Sanjay

[quiconait]

Thank you for the very complete answer.

Thought, the main question resides on where could I find that file.
The problem in fact, is:

I have DB2 v6 installed. And I may connect through ODBC iseries access for windows V5R2M0. This is running and working.

Now, I would like to start developing some applications in c# .NET.

In this particular case, what would be the best solution?

Thank you for any kind of help you can give me,
Best Regards