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 the above example, SYSNAME represents 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.
Your ODBC Data Source Name (DSN) configuration uses the wrong naming convention. Use the ODBC Administrator to change your DSN to use the proper (*SQL or *SYS) naming convention. Always use *SQL unless your application design specifically expects *SYS.