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

EXEC SQL INCLUDE sqlca;
EXEC SQL WHENEVER SQLERROR sqlprint;

void posSqlError() { return; }

main()
{
	FILE *fp;
	char file[80];
	sprintf(file, "esqlc.%d", getpid());
	fp = fopen(file, "w");
	ECPGdebug(1, fp);

	EXEC SQL BEGIN DECLARE SECTION;
	char connection[1024];
        char user[80];
        char pass[80];
	char tstchar25[80];
	int  tstint = 99;
	EXEC SQL END DECLARE SECTION;

	sprintf(connection, "tcp:postgresql://localhost:5432/sisis?application_name=SunRise DBCALL V7.1 (pid=%d)", getpid());
	strcpy(user, "sisis");
	strcpy(pass, "sisis123");

	EXEC SQL WHENEVER SQLERROR call posSqlError();

	EXEC SQL CONNECT TO :connection USER :user USING :pass ;

	printf("hostvariable 'tstint' before SELECT tstchar25, tstint INTO :tstchar25, :tstint FROM dbctest: %d\n", tstint);

	EXEC SQL SELECT tstchar25, tstint INTO :tstchar25, :tstint FROM dbctest WHERE tstint = 1;

	printf("hostvariable 'tstint' after  SELECT tstchar25, tstint INTO :tstchar25, :tstint FROM dbctest with -213: %d\n", tstint);


	EXEC SQL DISCONNECT;

	return 0;

}