#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include "util.h"

EXEC SQL INCLUDE SQLCA;

int main(int argc, char *argv[]) {
   int i;

   EXEC SQL BEGIN DECLARE SECTION;
      char db[6] = "cs348";
      char title[72];
      int pubid;
   EXEC SQL END DECLARE SECTION;

   printf("Sample C program: SAMPLE2\n" );

   EXEC SQL CONNECT TO :db;

   printf("Connected to DB2\n");

   EXEC SQL WHENEVER SQLERROR  GO TO error;

   for (i=1; i<argc; i++) {
     pubid = atoi(argv[i]);
     
     EXEC SQL WHENEVER NOT FOUND GO TO nope;
     EXEC SQL SELECT title INTO :title
              FROM   publication
              WHERE  pubid = :pubid;
     
     printf("%4d: %s\n",pubid,title);
     continue;
   nope:
     printf("%4d: *** not found *** \n",pubid);
   };

   EXEC SQL COMMIT;
   EXEC SQL CONNECT reset;
   exit(0);

error:
   check_error("My error",&sqlca);
   EXEC SQL WHENEVER SQLERROR CONTINUE;

   EXEC SQL ROLLBACK;
   EXEC SQL CONNECT reset;
   exit(1);
}