#include <stdio.h>

exec sql begin declare section;
	int	id;
exec sql end declare section;

exec sql whenever not found goto close_mycur;

exec sql declare mycur cursor for select id from t1;

int main(int argc, char **argv)
{
	exec sql connect to 'test';

	exec sql open mycur;
	while (1)
	{
		exec sql fetch mycur into :id;
		printf("id=%d\n");
	}
close_mycur:
	exec sql close mycur;

	exec sql disconnect current;
}