Hallo Starocotes,
nur eine simple Fehlerlösung zu dem SQL Fehler:
Probable cause:

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

ADDRDBDIRE RDB(SYSNAME) RMTLOCNAME(*LOCAL)
Copy

In the 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 the period is valid in IBM i file naming conventions the name must be enclosed in double quotes to be used in a SQL statement. A short term circumvention may be to build a logical file over the desired physical file, using the SQL naming syntax. Another possible solution is to create an SQL Alias over the desired file and then access the file indirectly through the alias.