+ EXEC SQL REPEATED INSERT INTO users
+ (login, users_id, uid, shell, last, first, middle, status,
+ clearid, type, modtime, modby, modwith, fullname, office_addr,
+ office_phone, department, fmodtime, fmodby, fmodwith,
+ potype, xname, xdept, xtitle, xaddress, xphone1, xphone2, xmodtime)
+ VALUES (:login, :id, :uid, '/bin/athena/tcsh', :last, :first,
+ :middle, :st, :sid, :class, 'now', :who, :prog,
+ :fullname, :oaddr, :ophone, :dept, 'now', :who, :prog,
+ 'NONE', :name, :rdept, :title, :oaddr, :rhphone,
+ :rophone, 'now');
+ if (sqlca.sqlcode != 0) {
+ if (sqlca.sqlcode == SQL_DEADLOCK) {
+ com_err(whoami, MR_DEADLOCK, "adding user");
+ } else {
+ com_err(whoami, 0, "ingres error %d adding user", sqlca.sqlcode);
+ exit(1);
+ }
+ } else
+ com_err(whoami, 0, "adding user %s %s", e->first, e->last);
+}
+