Debian Codegraph @

src/interfaces/ecpg/test/sql/desc.pgc

raw
1 EXEC SQL INCLUDE ../regression;
2 EXEC SQL WHENEVER SQLERROR SQLPRINT;
3
4 int
5 main(void)
6 {
7 EXEC SQL BEGIN DECLARE SECTION;
8 char *stmt1 = "INSERT INTO test1 VALUES ($1, $2)";
9 char *stmt2 = "SELECT * from test1 where a = $1 and b = $2";
10 char *stmt3 = "SELECT * from test1 where :var = a";
11
12 int val1 = 1;
13 char val2[4] = "one", val2output[] = "AAA";
14 int val1output = 2, val2i = 0;
15 int val2null = -1;
16 int ind1, ind2;
17 char desc1[8] = "outdesc";
18 EXEC SQL END DECLARE SECTION;
19
20 ECPGdebug(1, stderr);
21
22 EXEC SQL ALLOCATE DESCRIPTOR indesc;
23 EXEC SQL ALLOCATE DESCRIPTOR :desc1;
24
25 EXEC SQL SET DESCRIPTOR indesc VALUE 1 DATA = :val1;
26 EXEC SQL SET DESCRIPTOR indesc VALUE 2 INDICATOR = :val2i, DATA = :val2;
27
28 EXEC SQL CONNECT TO REGRESSDB1;
29
30 EXEC SQL CREATE TABLE test1 (a int, b text);
31 EXEC SQL PREPARE foo1 FROM :stmt1;
32 EXEC SQL PREPARE "Foo-1" FROM :stmt1;
33 EXEC SQL PREPARE foo2 FROM :stmt2;
34 EXEC SQL PREPARE foo3 FROM :stmt3;
35
36 EXEC SQL EXECUTE foo1 USING SQL DESCRIPTOR indesc;
37
38 EXEC SQL SET DESCRIPTOR indesc VALUE 1 DATA = 2;
39 EXEC SQL SET DESCRIPTOR indesc VALUE 2 INDICATOR = :val2null, DATA = :val2;
40
41 EXEC SQL EXECUTE foo1 USING SQL DESCRIPTOR indesc;
42
43 EXEC SQL SET DESCRIPTOR indesc VALUE 1 DATA = 3;
44 EXEC SQL SET DESCRIPTOR indesc VALUE 2 INDICATOR = :val1, DATA = 'this is a long test';
45
46 EXEC SQL EXECUTE "Foo-1" USING SQL DESCRIPTOR indesc;
47
48 EXEC SQL DEALLOCATE "Foo-1";
49
50 EXEC SQL SET DESCRIPTOR indesc VALUE 1 DATA = :val1;
51 EXEC SQL SET DESCRIPTOR indesc VALUE 2 INDICATOR = :val2i, DATA = :val2;
52
53 EXEC SQL EXECUTE foo2 USING SQL DESCRIPTOR indesc INTO SQL DESCRIPTOR :desc1;
54
55 EXEC SQL GET DESCRIPTOR :desc1 VALUE 1 :val2output = DATA;
56 printf("output = %s\n", val2output);
57
58 EXEC SQL DECLARE c1 CURSOR FOR foo2;
59 EXEC SQL OPEN c1 USING SQL DESCRIPTOR indesc;
60
61 EXEC SQL FETCH next FROM c1 INTO :val1output:ind1, :val2output:ind2;
62 printf("val1=%d (ind1: %d) val2=%s (ind2: %d)\n",
63 val1output, ind1, val2output, ind2);
64
65 EXEC SQL CLOSE c1;
66
67 EXEC SQL SET DESCRIPTOR indesc COUNT = 1;
68 EXEC SQL SET DESCRIPTOR indesc VALUE 1 DATA = 2;
69
70 EXEC SQL DECLARE c2 CURSOR FOR foo3;
71 EXEC SQL OPEN c2 USING SQL DESCRIPTOR indesc;
72
73 EXEC SQL FETCH next FROM c2 INTO :val1output, :val2output :val2i;
74 printf("val1=%d val2=%s\n", val1output, val2i ? "null" : val2output);
75
76 EXEC SQL CLOSE c2;
77
78 EXEC SQL SELECT * INTO :val1output, :val2output:val2i FROM test1 where a = 3;
79 printf("val1=%d val2=%c%c%c%c warn=%c truncate=%d\n", val1output, val2output[0], val2output[1], val2output[2], val2output[3], sqlca.sqlwarn[0], val2i);
80
81 EXEC SQL DROP TABLE test1;
82 EXEC SQL DEALLOCATE ALL;
83 EXEC SQL DISCONNECT;
84
85 EXEC SQL DEALLOCATE DESCRIPTOR indesc;
86 EXEC SQL DEALLOCATE DESCRIPTOR :desc1;
87
88 return 0;
89 }