Change location of spool file to /moira/load, to agree with staff.sql.

diff --git a/regtape/student.sql b/regtape/student.sql
index ccb970d8b26423285314ad02e7722597f6d21edc..eadc71ea053423f0dad8010a308e8b83fe382d6b 100644 (file)
--- a/regtape/student.sql
+++ b/regtape/student.sql
@@ -2,7 +2,7 @@ set head off
 set feedback off
 set pagesize 0
 set linesize 256
-spool /var/tmp/student.input.unsorted
+spool /moira/load/student.input.unsorted
 select rpad(nvl(mit_id, ' '), 9, ' ') || rpad(nvl(last_name, ' '), 30, ' ') || rpad(nvl(first_name, ' '), 30, ' ') || rpad(nvl(middle_name, ' '), 30, ' ') || rpad(nvl(student_year, ' '), 1, ' ') || rpad(nvl(department, ' '), 4, ' ') || rpad(nvl(term_street1, ' '), 30, ' ') || rpad(nvl(term_city, ' '), 40, ' ') || rpad(nvl(term_state, ' '), 2, ' ') || rpad(nvl(term_zip, ' '), 9, ' ') || rpad(nvl(term_phone1, ' '), 20, ' ') || rpad(nvl(office_location, ' '), 30, ' ') || rpad(nvl(office_phone, ' '), 20, ' ') from wareuser.moira_student3;
 spool off
 quit