summaryrefslogtreecommitdiff
path: root/src/interfaces/ecpg/test/stp.pgc
blob: ac80b883bf6b4ff0b705d44a8176f946fec0f346 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
EXEC SQL INCLUDE sqlca;

int my_fun (void)
	{
	EXEC SQL BEGIN DECLARE SECTION;
	int			sql_index = 0;
	EXEC SQL END DECLARE SECTION;	
	FILE *dbgs;

	if ((dbgs = fopen("log", "w")) != NULL)
                ECPGdebug(1, dbgs);

	EXEC SQL WHENEVER SQLERROR GOTO Error;

	EXEC SQL CONNECT TO 'mm';
	EXEC SQL SELECT MIN(index) INTO :sql_index FROM tab;
	EXEC SQL DISCONNECT;

	if (dbgs != NULL)
                fclose(dbgs);  

	return (sql_index);

Error:
	return (sqlca.sqlcode);	
	}