void fix_member(), display_member();
int debug = 0, records = 0;
+char *db = "moira/moira";
main(argc, argv)
int argc;
#endif DEBUG
/* ingres sms */
- EXEC SQL CONNECT moira;
+ EXEC SQL CONNECT :db;
/* begin transaction */
/* range of m is imembers */
/* No equivalent */
* and m.member_type = mtype */
EXEC SQL DELETE FROM imembers WHERE list_id = :list_id AND
member_id = :member_id AND member_type = :mtype;
- EXEC SQL INQUIRE_SQL(:rowcount = rowcount);
- printf(" %d rows deleted\n", rowcount);
+ rowcount = sqlca.sqlerrd[2];
+ if (rowcount > 0)
+ printf("%d entr%s deleted\n", rowcount,
+ rowcount == 1 ? "y" : "ies");
#endif FIXERRORS
}
if (errmis > 0)
insert_list(m)
struct member *m;
{
- register struct member_list *l, *l1;
+ struct member_list *l, *l1;
l = (struct member_list *) hash_lookup(lists, m->list_id);
if (l == NULL) {
insert_member(m)
struct member *m;
{
- register struct member_list *l, *l1;
+ struct member_list *l, *l1;
l = (struct member_list *) hash_lookup(members, m->member_id);
if (l == NULL) {
int listid;
int memberid;
{
- register struct member_list *l;
+ struct member_list *l;
for (l = (struct member_list *) hash_lookup(lists, listid); l; l = l->next)
if (l->member->member_id == memberid)
char *mtype;
EXEC SQL END DECLARE SECTION;
char buf[2];
- register struct member *m;
+ struct member *m;
for (; l; l = l->next) {
m = l->member;
EXEC SQL INSERT INTO imembers (list_id, member_id,
member_type, ref_count, direct)
VALUES (:list_id, :member_id, :mtype, :ref_count, :dflag);
- EXEC SQL INQUIRE_SQL(:rowcount = rowcount);
- printf(" %d rows added\n", rowcount);
+ rowcount = sqlca.sqlerrd[2];
+ if (rowcount > 0)
+ printf("%d entr%s added\n", rowcount,
+ rowcount == 1 ? "y" : "ies");
#endif FIXERRORS
continue;
}
SET ref_count=ref_count+:ref_count, direct = :dflag
WHERE list_id = :list_id AND member_id = :member_id AND
member_tpe = :mtype;
- EXEC SQL INQUIRE_SQL(:rowcount = rowcount);
- printf(" %d rows fixed\n", rowcount);
+ rowcount = sqlca.sqlerrd[2];
+ if (rowcount > 0)
+ printf("%d entr%s updated\n", rowcount,
+ rowcount == 1 ? "y" : "ies");
#endif FIXERRORS
}
}
struct member *allocmember()
{
- register struct member *m;
+ struct member *m;
m = (struct member *) malloc(sizeof(struct member));
if (m == NULL) {
int isinchain(m, l)
struct member *m;
-register struct member_list *l;
+struct member_list *l;
{
for (; l; l = l->next)
if (l->member == m)
int chainlen(l)
-register struct member_list *l;
+struct member_list *l;
{
- register int i;
+ int i;
for (i = 0; l; l = l->next, i++);
return(i);
}