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

EXEC SQL include ../regression;

int
main (void)
{
  ECPGdebug (1, stderr);

  EXEC SQL BEGIN DECLARE SECTION;

  float f = 4.56;	
  const char *stmt2 = "INSERT INTO floattest VALUES (?);";
	
  EXEC SQL END DECLARE SECTION;
	
  EXEC SQL connect to REGRESSDB1;
  if (sqlca.sqlcode)
    {
      printf ("connect error = %ld\n", sqlca.sqlcode);
      exit (sqlca.sqlcode);
    }

  EXEC SQL create table floattest (f float);
  if (sqlca.sqlcode)
    {
      printf ("create error = %ld\n", sqlca.sqlcode);
      exit (sqlca.sqlcode);
    }

  EXEC SQL PREPARE mystmt FROM :stmt2;
  if (sqlca.sqlcode)
    {
      printf ("prepare error = %ld\n", sqlca.sqlcode);
      exit (sqlca.sqlcode);
    }

  EXEC SQL EXECUTE mystmt USING 1.23;
  if (sqlca.sqlcode)
    {
      printf ("insert error = %ld\n", sqlca.sqlcode);
      exit (sqlca.sqlcode);
    }

  EXEC SQL COMMIT;

  EXEC SQL disconnect;

  exit (0);
}