Welcome to Aspire Knowledge Central (AKC)

CS-AS400

0) 00.02 JTOpen: The Open Source version of IBM tool box for Java for AS400 (1-Nov-03)

http://www-124.ibm.com/developerworks/oss/jt400/

The IBM Toolbox for Java is a library of Java classes supporting the client/server and internet programming models to an iSeries or AS/400 server. The classes can be used by Java applets, servlets, and applications to easily access iSeries and AS/400 data and resources.

Nevertheless it is not clear if DB2Connect functionality is available here.

Also not sure if DB2 Development Center client can be run on this without an explicit DB2Connect

1) 05.01 15 Seconds : A Primer on Using DB2 with .NET - Chris Irek (1-Nov-03)

http://www.internet.com/icom_cgi/print/print.cgi?url=http://15seconds.com/issue/030623.htm

Basics of using DB2
Role of DB2Connect
Using OleDB vs ODBC
Feature comparison
Perf comparison
Irek's email

2) 05.01 Working with AS400 tables from windows using iseriesNavigator (18-Oct-03)

1. Install iseries navigator
2. Make sure you install the full set of components
3. Obtain the systemname/userid/password
4. Create a connection using 3

3) 05.03 Application development guide for DB2 (1-Nov-03)

http://www-3.ibm.com/software/data/db2/udb/ad/v7/adg/db2a0/frm3toc.htm

This book discusses how to design and code application programs that access DB2 databases. It presents detailed information on the use of Structured Query Language (SQL) in supported host language programs. For information on language support for your specific operating system, see the Application Building Guide. This book also provides an overview of some of the DB2 utilities that you can use to help create DB2 applications. These utilities include The IBM DB2 Universal Database Project Add-In for Microsoft Visual C++ and IBM DB2 Stored Procedure Builder.

4) 05.05 Working with iseries for navigating DB2 (1-Nov-03)

http://www.eservercomputing.com/iseries/articles/index.asp?id=300

A decent article outlining what can be done with iseries navigator for DB2. More like a Query Analyzer or SQL Navigator

5) 05.07 Using DB2 Development Center - Kent Milligan (1-Nov-03)

http://www.eservercomputing.com/iseries/articles/index.asp?id=742

DB2* Development Center is a rapid iterative environment for developing stored procedures, user-defined functions and more. This client-based development tool supports the entire DB2 Universal Database* (UDB) family of servers, so it?s useful for developing and deploying procedures on multiple DB2 UDB servers.

6) 15.01 ODBC Settings for AS400 databases (1-Nov-03)

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzaik/rzaik678.htm

The iSeries Access ODBC driver has many connection string keywords that can be used to change the behavior of the ODBC connection. These same keywords and their values are also stored when an ODBC data source is setup. When an ODBC application makes a connection, any keywords specified in the connection string override the values specified in the ODBC data source.

7) 15.03 Some helpful oledb settings (1-Nov-03)

http://www-912.ibm.com/s_dir/slkbase.NSF/00e42b791a3dab7b862565c9004ec1af/c52e46013ce1ded286256a3b006a38c5?OpenDocument

Client Access Express V5R1 introduced new custom properties that can be set prior to connecting to the iSeries 400 server. These properties increase functionality of the IBMDA400 provider. The new properties are listed below.

8) 15.05 Using Library Lists (1-Nov-03)

http://www-912.ibm.com/s_dir/slkbase.NSF/515a7ef1f8deef8c8625680b00020380/9d3e03ceba505db4862567ef0037496b?OpenDocument

DB2 Universal Database for iSeries (DB2/400) supports library list qualified object names only through the use of system naming convention (*SYS). Client Access OLE DB provider only supports SQL naming convention for SQL statements and Stored Procedures. *SYS naming convention and IFS naming convention are not supported.

Most likely this will come with the UDB client.

This tool is almost useless unless you have the underlying connectivity products like DB2Connect. And you have to pay licensing fees for this conenience.

12) 20.05 OleDB client access reference library (1-Nov-03)

http://www-1.ibm.com/servers/eserver/iseries/access/oledb/reflibrary.htm

A link pointing some addtional oledb documents.