New database and column names for Moira2.

[moira.git] / gen / prlogger.dc

diff --git a/gen/prlogger.dc b/gen/prlogger.dc
index 354c72999fcd902175553937d245524b4a553f29..6d8012c6ac0ebb29932a40ce6434537e6f7cd29c 100644 (file)
--- a/gen/prlogger.dc
+++ b/gen/prlogger.dc
@@ -33,10 +33,10 @@ char **argv;
     EXEC SQL END DECLARE SECTION;
 
 #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) {
@@ -62,10 +62,14 @@ char **argv;
        outf = NULL;
     }
 
+    /* The following is declarative, not executed,
+     * and so is dependent on where it is in the file,
+     * not in the order of execution of statements.
+     */
     EXEC SQL WHENEVER SQLERROR GOTO sqlerr;
 
     EXEC SQL DECLARE x CURSOR FOR 
-      SELECT login, mit_year FROM users WHERE status = 1;
+      SELECT login, affiliation FROM users WHERE status = 1;
     EXEC SQL OPEN x;
     while (1) {
        EXEC SQL FETCH x INTO :login, :class;