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

EXEC SQL include sqlca;

int main(void) {
  EXEC SQL begin declare section;
    int number;
    char name[10 + 1];
    char phone[10 + 1];
  EXEC SQL end declare section;

  printf("Personer:\n");

  EXEC SQL connect persondatabasen;

  EXEC SQL declare person_cursor cursor for
    select Nummer, Namn, Telefon
    from Person;

  EXEC SQL open person_cursor;

  EXEC SQL whenever not found goto close_person_cursor;

  while (1) {
    EXEC SQL fetch person_cursor into :number, :name, :phone;
    printf("Nummer %d, med namnet %s och telefonnummer %s.\n",
	   number, name, phone);
  } /* while */

close_person_cursor:

  EXEC SQL close person_cursor;
  EXEC SQL disconnect;

  return EXIT_SUCCESS;
} /* main */