Transfer rows from one database to another
Posted in 1999
Topics: Stored Procedures & SPL, Networking & sqlhosts Configuration
Hi all, I have to transfer some rows from one table of database A into another table on database B. The transfer is done by a stored procedure. The two databases are on the same server. For the transfer i use: insert into databasename@servername:tablename. On NT i can write the servername in uppercase or lowercase letters and the stored procedure transfers the rows. The environment parameters (for example: sqlhosts in the registry, informixserver, ...) are in lowercase letters. On UNIX all environment parameters are written in uppercase. If i execute the stored procedure on the unix-server with uppercase or lowercase letters for servname i always get the: "server-name is not listed as a dbserver-name in sqlhosts"-error. I looked in the trace and found out that if servername is written in uppercase or lowercase the servername in the trace is always mentioned in lowercase letters. In sqlhosts the servername is written in uppercase letters. Maybe the problem is: the servername in sqlhosts is in uppercase letters and the stored procedure is always executed with servername in lowercase letters and on UNIX lowercase letters are different from uppercase letters. Hope for some help. Michael