5
/* test automatic prepare for all statements */
6
EXEC SQL INCLUDE ../regression;
8
int main(int argc, char* argv[]) {
9
EXEC SQL BEGIN DECLARE SECTION;
10
int item[4], ind[4], i = 1;
11
EXEC SQL END DECLARE SECTION;
14
EXEC SQL CONNECT TO REGRESSDB1;
16
EXEC SQL WHENEVER SQLWARNING SQLPRINT;
17
EXEC SQL WHENEVER SQLERROR SQLPRINT;
19
EXEC SQL CREATE TABLE T ( Item1 int, Item2 int );
21
EXEC SQL INSERT INTO T VALUES ( 1, null );
22
EXEC SQL INSERT INTO T VALUES ( 1, :i );
24
EXEC SQL INSERT INTO T VALUES ( 1, :i );
25
EXEC SQL PREPARE I AS INSERT INTO T VALUES ( 1, 2 );
28
EXEC SQL SELECT Item2 INTO :item:ind FROM T ORDER BY Item2 NULLS LAST;
31
printf("item[%d] = %d\n", i, ind[i] ? -1 : item[i]);
33
EXEC SQL DECLARE C CURSOR FOR SELECT Item1 FROM T;
37
EXEC SQL FETCH 1 IN C INTO :i;
38
printf("i = %d\n", i);
42
EXEC SQL DROP TABLE T;
44
EXEC SQL DISCONNECT ALL;