Connectivity Tasks for AS/400

The ECDA product that accesses DB2 UDB for AS/400 is ECDA for ODBC, using TCP/IP for connectivity.

To set up the AS/400 to communicate with these ECDA products, you must perform the connectivity tasks after logging in to the target AS/400 server as the system administrator.

Note: Systems Network Architecture (SNA) /Advanced Program-to-Program Communications (APPC) connectivity is not supported.

Enabling DRDA Capability of AS/400
To use an AS/400 service, you must enable the Distributed Relational Database Architecture (DRDA) capability of the AS/400. The service communicates with the AS/400 through a TCP/IP connection to DB2 UDB.
Set Security Levels
Set the security levels for AS/400.
CCSID
The CCSID (coded character set ID) designates the binary code page in which the AS/400 returns data.
SYBASE Collection on AS/400 (for DB2 UDB)
The access service requires certain files on the AS/400. ECDA for ODBC access service looks for these files in a collection called SYBASE. You must create this collection and name it SYBASE before installing the access service.