blob: 72f7077a4368b9bdb5c694566e8b93316408d941 (
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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
#include <stdlib.h>
#include <string.h>
#include <stdlib.h>
#include <stdio.h>
exec sql include ../regression;
exec sql whenever sqlerror sqlprint;
int
main(void)
{
EXEC SQL BEGIN DECLARE SECTION;
int id;
EXEC SQL END DECLARE SECTION;
ECPGdebug(1, stderr);
EXEC SQL connect to REGRESSDB1;
EXEC SQL SET AUTOCOMMIT TO ON;
EXEC SQL WHENEVER SQLWARNING SQLPRINT;
EXEC SQL WHENEVER SQLERROR SQLPRINT;
EXEC SQL CREATE TABLE cta_test (id int);
EXEC SQL INSERT INTO cta_test values (100);
EXEC SQL CREATE TABLE IF NOT EXISTS cta_test1 AS SELECT * FROM cta_test;
EXEC SQL SELECT id INTO :id FROM cta_test1;
printf("ID = %d\n", id);
EXEC SQL CREATE TABLE cta_test2 AS SELECT * FROM cta_test WITH NO DATA;
EXEC SQL SELECT count(id) INTO :id FROM cta_test2;
printf("ID = %d\n", id);
EXEC SQL DROP TABLE cta_test;
EXEC SQL DROP TABLE cta_test1;
EXEC SQL DROP TABLE cta_test2;
EXEC SQL DISCONNECT all;
return 0;
}
|
