#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <sqlenv.h>
#include <sqlutil.h>
#include "dbmcon1.h"

EXEC SQL INCLUDE SQLCA;

#define CHECKERR(str) if(is_error(str, &sqlca) != 0) return 1;

int FirstDbCreateTable(void)
{
	printf("CREATE TABLE irok_stat(godina SMALLINT NOT NULL, oznaka VARCHAR(20), prolaznost float)\n");

	EXEC SQL CREATE TABLE irok_stat(godina SMALLINT NOT NULL, oznaka VARCHAR(20), prolaznost float);
	CHECKERR("Create table");

	return 0;
} /* FirstDbCreateTable */

int FirstDbDropTable(void)
{
	printf("DROP TABLE irok_stat\n");

	EXEC SQL DROP TABLE irok_stat;
	CHECKERR("Drop table");

	return 0;
} /* FirstDbDropTable */