#include <stdio.h>
#include <stdlib.h>
#include <postgres.h>
#include <libpq-fe.h>
exec sql include sqlca;

int main()
{
  int i;
  exec sql begin declare section;
    varchar cve_name[20];
    varchar sn_or_invoice[20];
    varchar date_of_purchase[20];
    varchar cpu_mhz[20];
    varchar memory_mb[20];
    varchar expiration_date[20];
  exec sql end declare section;
  exec sql declare pick_em cursor for
    select * from dtr_boxes;
  exec sql begin work;
  exec sql connect 'jacobdb';
  exec sql open pick_em; 
  for (i=0; ; i++)
  {
    exec sql fetch pick_em into
     :cve_name, :sn_or_invoice, :date_of_purchase, :cpu_mhz,
     :memory_mb, :expiration_date;
    if( sqlca.sqlcode != 0 )
    {
      printf( "\n%s\n", sqlca.sqlerrm.sqlerrmc);
      break;
    } 
    cve_name.arr[cve_name.len] = '\0';
    sn_or_invoice.arr[sn_or_invoice.len] = '\0';
    date_of_purchase.arr[date_of_purchase.len] = '\0';
    cpu_mhz.arr[cpu_mhz.len] = '\0';
    memory_mb.arr[memory_mb.len] = '\0';
    expiration_date.arr[expiration_date.len] = '\0';
    printf("\n%s %s %s %s %s\n", cve_name.arr, sn_or_invoice.arr,
           date_of_purchase.arr, cpu_mhz.arr, memory_mb.arr,
           expiration_date.arr);
  }
  exec sql close pick_em;
  exec sql commit;
  exec sql disconnect 'jacobdb';
}