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
      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                 : }