SQL0114 - Relational database amp;1 not the same as current amp;2 server

SQL0114 - Relational database &1 not the same as current &2 server

Update the iSeries Access ODBC Relational Database Directory Entry.

Probable cause:

It is likely that the system name is not in the Remote Database Directory. Run the Add Relational Database Directory Entry command:

         ADDRDBDIRE RDB(SYSNAME) RMTLOCNAME(*LOCAL)

In this above example, SYSNAME is the name of your system's Default Local Location name (as specified in the DSPNETA command).

Another common cause for this error is a period (.) in a table or library name. Although valid in naming conventions, in order to use it within an SQL statement, enclose the name within double quotes. A short term circumvention may be to build a logical file over the desired physical file, using the SQL naming syntax.

Parent topic:

SQL errors