After synchronizing with opssrc as it was on 8/4/92.

[moira.git] / server / cache.dc

diff --git a/server/cache.dc b/server/cache.dc
index 6e621b80d59fb0e7fbe47f6444c473311f833b75..e1b66a2c28dba284ff82fc969c93b802262d12e7 100644 (file)
--- a/server/cache.dc
+++ b/server/cache.dc
@@ -15,6 +15,7 @@ static char *rcsid_cache_dc = "$Header$";
 #include "mr_server.h"
 EXEC SQL INCLUDE sqlca;
 
+EXEC SQL WHENEVER SQLERROR CALL ingerr;
 
 extern char *whoami, *strsave();
 extern int ingres_errno, mr_errcode;
@@ -145,7 +146,7 @@ int *id;
        break;
     case 'M':
     case 'm':
-       EXEC SQL SELECT mach_id INTO :j FROM machine WHERE name=uppercase(:iname);
+       EXEC SQL SELECT mach_id INTO :j FROM machine WHERE name=UPPERCASE(:iname);
        break;
     case 'C':
     case 'c':
@@ -207,7 +208,7 @@ int id;
 char *type;
 char **name;
 {
-    register struct item *i;
+    register struct item *i, *t;
     EXEC SQL BEGIN DECLARE SECTION;
     char iname[NAMESZ];
     int j, rowcount;