New database and column names for Moira2.

[moira.git] / gen / ca.dc

diff --git a/gen/ca.dc b/gen/ca.dc
index d452559ae5339e6ec48e0a5675a64b9e661338cf..9a93eb476992a524e23a0bc4bc6dcd58b12f2617 100644 (file)
--- a/gen/ca.dc
+++ b/gen/ca.dc
@@ -46,10 +46,10 @@ char **argv;
     initialize_sms_error_table ();
 
 #ifsql INGRES
-    EXEC SQL CONNECT sms;
+    EXEC SQL CONNECT moira;
 #endsql
 #ifsql INFORMIX
-    EXEC SQL DATABASE sms;
+    EXEC SQL DATABASE moira;
 #endsql
 
     if (argc == 2) {
@@ -75,6 +75,9 @@ char **argv;
        outf = NULL;
     }
 
+    /* The following WHENEVER is declarative, not executed,
+     * and applies for the remainder of this file only.
+     */
     EXEC SQL WHENEVER SQLERROR GOTO sqlerr;
     sq = sq_create();
 
@@ -126,7 +129,7 @@ char **argv;
     EXEC SQL DECLARE z CURSOR FOR 
       SELECT DISTINCT u.login, u.fullname, f.name
       FROM users u, filesys f
-       WHERE f.label = u.login and u.status = 1 and f.type = "AFS"
+       WHERE f.label = u.login and u.status = 1 and f.type = 'AFS'
        ORDER BY name;
     EXEC SQL OPEN z;
     while (1) {