test1.pgc

text/plain

Download

EXEC SQL BEGIN DECLARE SECTION;
int	id;
char	t[256];
EXEC SQL END DECLARE SECTION;

EXEC SQL DECLARE mycur CURSOR FOR SELECT * INTO :id,:t FROM t1;

int main(void) {
	EXEC SQL BEGIN DECLARE SECTION;
	int	id;
	int	t;
	EXEC SQL END DECLARE SECTION;

	EXEC SQL CONNECT TO test;

	EXEC SQL OPEN mycur;

	EXEC SQL FETCH mycur;

	EXEC SQL CLOSE mycur;

	EXEC SQL DISCONNECT ALL;

	return 0;
}