Adding the local system to the RDB directory

To use IBM i Access ODBC, OLE DB, or the .NET Data Provider, the local system name must appear in the RDB directory.

To add the local system to the RDB directory:

  1. From the command prompt run the CL command, Add Relational Database Directory Entry (ADDRDBDIRE).
  2. When the ADDRDBDIRE screen prompts you for values, enter the name of the system as the Relational Database parameter.
  3. Enter *LOCAL as the Remote Location parameter.

There may be additional steps to get the database (RDB) name set if your application accesses data residing in an independent ASPs. The RDB name corresponds with a namespace that consists of the system ASP and any user ASPs or linked ASP group associated with the system ASP. For more information about independent ASPs, see Disk management.

Note: ODBC allows the use of fully qualified names in the format of [catalog name].[schema name].identifier (for example, where identifier is the name of a table, view, or procedure). In the Db2 for IBM i implementation of SQL this corresponds to [RDB name].[collection name].identifier.