#include <stdio.h>
#include <ctype.h>
#include <mit-copyright.h>
+EXEC SQL INCLUDE sqlca;
#include "dump_db.h"
{
char buf[BUFSIZ];
char *prefix;
-
+ EXEC SQL BEGIN DECLARE SECTION;
+ char *db;
+ EXEC SQL END DECLARE SECTION;
+
+ if (argc != 2) {
+ fprintf(stderr, "Usage: %s database\n", argv[0]);
+ exit(1);
+ }
+ db = argv[1];
+
if (!yes_or_no("Do you *REALLY* want to wipe the SMS database?")) {
printf("I didn't think so\n");
exit(1);
}
- if (!yes_or_no("Have you initialized an empty database named smstemp?")) {
+ sprintf(buf, "Have you initialized an empty database named %s?", db);
+ if (!yes_or_no(buf)) {
printf("You should have\n");
exit(1);
}
printf("Opening database: ");
(void) fflush(stdout);
-## ingres smstemp
+ EXEC SQL CONNECT :db;
+ if (sqlca.sqlcode != 0) {
+ com_err(argv[0], 0, "Ingres database open failed");
+ exit(1);
+ }
+ EXEC SQL SET AUTOCOMMIT ON;
printf(" done\n");
}
do_restores(prefix);
printf("Restore complete\n");
-## exit
+ EXEC SQL COMMIT;
+ EXEC SQL DISCONNECT;
exit(0);
/*NOTREACHED*/
}
int fd;
FILE *f;
+ EXEC SQL COMMIT WORK;
+
(void) strcpy(name, prefix);
(void) strcat(name, suffix);