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.

The SYBASE collection contains a package for the DC DB2 UDB driver that is created when the drivers are installed. After you create the packages, you need to grant permissions to PUBLIC for the end users to access the SYBASE collection located on the target AS/400. This can be done with isql (which includes with the ECDA installation), or entered directly on the AS/400 machine.

• Setting Permissions from isql
  Use the isql to grant permission.
• Granting Permissions Directly on the AS/400
  Grant permission on the package for SYBASE collection.
• Creating the SYBASE Collection Using the AS/400 SEU Utility
  Use the SEU utility to create SYBASE collection. The user ID for creating the SYBASE collection must have a valid CCSID for your language installation.
• Creating the SYBASE Collection Through SQL/400
  Create SYBASE collection from the command prompt. The user ID for creating the SYBASE collection must have a valid CCSID for your language installation.
• Authorize Users for the SYBASE Collection
  You must have the minimum authorizations to access the AS/400 through the access service.