#include <stdlib.h>
#include <stdio.h>

exec sql begin declare section;
  varchar user_passwd[20];
  int     exmatrnr;
exec sql end declare section;

exec sql include sqlca.h;

main()
{
  
  printf("Name/Password:");
  scanf("%s", user_passwd);

  exec sql whenever sqlerror goto error;
  exec sql connect :user_passwd; 

  while (1) {
    printf("Matrikelnummer (0 zum beenden): ");
    scanf("%d", &exmatrnr);
    if (!exmatrnr) break;

    exec sql delete from Studenten
             where  MatrNr = :exmatrnr;
  }
  exec sql commit work release;
 
error:
  exec sql whenever sqlerror continue;
  exec sql rollback work release;
  printf("Fehler aufgetreten!\n");
  exit(-1);
}