/*
 * Test DECLARE ... SELECT ... INTO ...
 * with "string"
 */

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

EXEC SQL DEFINE MYDB1 zozo;
EXEC SQL DEFINE MYUSER1 zozo;

EXEC SQL BEGIN DECLARE SECTION;
EXEC SQL include test28.h;
EXEC SQL END DECLARE SECTION;

int main(int argc, char **argv) {
	EXEC SQL BEGIN DECLARE SECTION;
	MYTYPE 		myvar;
	EXEC SQL END DECLARE SECTION;

	EXEC SQL WHENEVER SQLWARNING SQLPRINT;
	EXEC SQL WHENEVER SQLERROR SQLPRINT;

	EXEC SQL connect to MYDB1 USER MYUSER1;
	if (sqlca.sqlcode)
	{
		printf ("connect error = %ld\n", sqlca.sqlcode);
		exit (sqlca.sqlcode);
	}

	EXEC SQL DECLARE mycur CURSOR FOR SELECT * INTO :myvar FROM a1 WHERE id = 1;
	EXEC SQL OPEN mycur;

	EXEC SQL WHENEVER NOT FOUND GOTO out;

	EXEC SQL FETCH FROM mycur;

	printf("c = '%s'\n", myvar.c);

out:
	EXEC SQL CLOSE mycur;

	EXEC SQL DISCONNECT;

	return 0;
}