Age         Owner                  TLA  Line data    Source code

                                  1                 : #include <stdlib.h>
                                  2                 : #include <string.h>
                                  3                 : #include <stdlib.h>
                                  4                 : #include <stdio.h>
                                  5                 : 
                                  6                 : exec sql include ../regression;
                                  7                 : 
                                  8                 : exec sql whenever sqlerror sqlprint;
                                  9                 : 
                                 10                 : int
 1511 meskes                     11 CBC           1 : main(void)
                                 12                 : {
                                 13                 :     EXEC SQL BEGIN DECLARE SECTION;
                                 14                 :         int id;
                                 15                 :     EXEC SQL END DECLARE SECTION;
                                 16                 : 
                                 17               1 :     ECPGdebug(1, stderr);
                                 18               1 :     EXEC SQL connect to REGRESSDB1;
                                 19               1 : 
                                 20               1 :     EXEC SQL SET AUTOCOMMIT TO ON;
                                 21               1 :     EXEC SQL WHENEVER SQLWARNING SQLPRINT;
                                 22                 :     EXEC SQL WHENEVER SQLERROR SQLPRINT;
                                 23                 : 
                                 24               1 :     EXEC SQL CREATE TABLE cta_test (id int);
                                 25               1 :     EXEC SQL INSERT INTO cta_test values (100);
                                 26               1 : 
                                 27               1 :     EXEC SQL CREATE TABLE IF NOT EXISTS cta_test1 AS SELECT * FROM cta_test;
                                 28               1 :     EXEC SQL SELECT id INTO :id FROM cta_test1;
                                 29               1 :     printf("ID = %d\n", id);
                                 30                 : 
                                 31               1 :     EXEC SQL CREATE TABLE cta_test2 AS SELECT * FROM cta_test WITH NO DATA;
                                 32               1 :     EXEC SQL SELECT count(id) INTO :id FROM cta_test2;
                                 33               1 :     printf("ID = %d\n", id);
                                 34                 : 
                                 35               1 :     EXEC SQL DROP TABLE cta_test;
                                 36               1 :     EXEC SQL DROP TABLE cta_test1;
                                 37               1 :     EXEC SQL DROP TABLE cta_test2;
                                 38               1 :     EXEC SQL DISCONNECT all;
                                 39               1 : 
                                 40               1 :     return 0;
                                 41                 : }