#include <stdio.h>

EXEC SQL BEGIN DECLARE SECTION;

char serverDatabase[40];
char userPassword[40];

struct Salespeople_rec{
  int Snum;
  char Sname[30];
  char City[30];
  double Comm;
};
EXEC SQL END DECLARE SECTION;

void sql_error(){
  EXEC SQL WHENEVER SQLERROR CONTINUE;
  printf("SQL Code = %li\n" ,SQLCODE);
  printf("SQL Server Message %li: %s\n" ,SQLERRD1 ,SQLERRMC);
  EXEC SQL ROLLBACK TRANSACTION;
  exit(1);
}

int main(int argc ,char* argv[]){
  EXEC SQL BEGIN DECLARE SECTION;
  struct Salespeople_rec sales_rec;
  int Snum;
  char Sname[30];
  char City[30];
  double Comm;
  EXEC SQL END DECLARE SECTION;

  EXEC SQL WHENEVER SQLERROR CALL sql_error();
  strcpy(serverDatabase ,"cafeaulait.lesson");
  strcpy(userPassword ,"sa.");
  
  EXEC SQL CONNECT TO :serverDatabase
    USER :userPassword;

  EXEC SQL DECLARE cursor_salespeople CURSOR FOR
    SELECT Snum ,Sname ,City ,Comm FROM Salespeople;
  
  EXEC SQL OPEN cursor_salespeople;
  while(1){
    EXEC SQL FETCH cursor_salespeople INTO :sales_rec;
    if (SQLCODE != 0)
      break;
    printf("%d  %s  %s  &d" ,sales_rec.Snum ,sales_rec.Sname 
                            ,sales_rec.City ,sales_rec.Comm);
  }   

  EXEC SQL DISCONNECT ALL;
}