Re: Transfer rows from one database to another

Michael Koslowski wrote: > > 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. Just change the servername in the sqlhosts file to lower case. Art S. Kagel