Age Owner TLA Line data Source code
1 : #include <stdio.h>
2 :
3 : exec sql include sqlca;
4 : exec sql include ../regression;
5 :
50 peter@eisentraut.org 6 GNC 1 : int main(void)
7 : {
8 : exec sql begin declare section;
7216 meskes@postgresql.or 9 CBC 1 : int intvar = 5;
10 1 : int nullind = -1;
11 : exec sql end declare section;
12 :
13 1 : ECPGdebug(1,stderr);
14 :
15 1 : exec sql connect to REGRESSDB1;
16 1 : exec sql set autocommit to off;
17 :
6839 18 1 : exec sql create table indicator_test (
19 : "id" int primary key,
20 : "str" text NOT NULL,
21 : val int null);
7216 22 1 : exec sql commit work;
23 :
6839 24 1 : exec sql insert into indicator_test (id, str, val) values ( 1, 'Hello', 0);
25 :
26 : /* use indicator in insert */
27 1 : exec sql insert into indicator_test (id, str, val) values ( 2, 'Hi there', :intvar :nullind);
7216 28 1 : nullind = 0;
6839 29 1 : exec sql insert into indicator_test (id, str, val) values ( 3, 'Good evening', :intvar :nullind);
7216 30 1 : exec sql commit work;
31 :
32 : /* use indicators to get information about selects */
6839 33 1 : exec sql select val into :intvar from indicator_test where id = 1;
34 1 : exec sql select val into :intvar :nullind from indicator_test where id = 2;
7216 35 1 : printf("intvar: %d, nullind: %d\n", intvar, nullind);
6839 36 1 : exec sql select val into :intvar :nullind from indicator_test where id = 3;
7216 37 1 : printf("intvar: %d, nullind: %d\n", intvar, nullind);
38 :
39 : /* use indicators for update */
40 1 : intvar = 5; nullind = -1;
6839 41 1 : exec sql update indicator_test set val = :intvar :nullind where id = 1;
42 1 : exec sql select val into :intvar :nullind from indicator_test where id = 1;
7216 43 1 : printf("intvar: %d, nullind: %d\n", intvar, nullind);
44 :
6839 45 1 : exec sql drop table indicator_test;
7216 46 1 : exec sql commit work;
47 :
48 1 : exec sql disconnect;
49 1 : return 0;
50 : }
|
