TLA  Line data    Source code

       1                 : #include <stdio.h>
       2                 : #include <stdlib.h>
       3                 : 
       4                 : exec sql include ../regression;
       5                 : 
       6                 : EXEC SQL WHENEVER sqlerror sqlprint;
       7                 : EXEC SQL WHENEVER sqlwarning sqlprint;
       8                 : EXEC SQL WHENEVER not found sqlprint;
       9                 : 
      10                 : EXEC SQL TYPE customer IS
      11                 :     struct
      12                 :     {
      13                 :         varchar name[50];
      14                 :         int     phone;
      15                 :     };
      16                 : 
      17                 : EXEC SQL TYPE cust_ind IS
      18                 :     struct ind
      19                 :     {
      20                 :         short   name_ind;
      21                 :         short   phone_ind;
      22                 :     };
      23                 : 
      24 CBC           1 : int main()
      25                 : {
      26                 :     EXEC SQL begin declare section;
      27               1 :       customer  *custs1 = (customer *) malloc(sizeof(customer) * 10);
      28               1 :       cust_ind  *inds = (cust_ind *) malloc(sizeof(cust_ind) * 10);
      29                 :       typedef struct
      30                 :       {
      31                 :         varchar name[50];
      32                 :         int     phone;
      33                 :       } customer2;
      34               1 :       customer2  *custs2 = (customer2 *) malloc(sizeof(customer2) * 10);
      35                 : 
      36                 :       struct customer3
      37                 :       {
      38                 :         char name[50];
      39                 :         int     phone;
      40               1 :       } *custs3 = (struct customer3 *) malloc(sizeof(struct customer3) * 10);
      41                 : 
      42                 :       struct customer4
      43                 :       {
      44                 :         varchar name[50];
      45                 :         int     phone;
      46               1 :       } *custs4 = (struct customer4 *) malloc(sizeof(struct customer4));
      47                 : 
      48                 :       int r;
      49                 :       varchar onlyname[2][50];
      50                 :     EXEC SQL end declare section;
      51                 : 
      52               1 :     ECPGdebug(1, stderr);
      53                 : 
      54               1 :     EXEC SQL connect to REGRESSDB1;
      55               1 : 
      56               1 :     EXEC SQL create table customers (c varchar(50), p int);
      57               1 :     EXEC SQL insert into customers values ('John Doe', '12345');
      58               1 :     EXEC SQL insert into customers values ('Jane Doe', '67890');
      59               1 : 
      60               1 :     EXEC SQL select * INTO :custs1:inds from customers limit 2;
      61               1 :     printf("custs1:\n");
      62               3 :     for (r = 0; r < 2; r++)
      63                 :     {
      64               2 :         printf( "name  - %s\n", custs1[r].name.arr );
      65               2 :         printf( "phone - %d\n", custs1[r].phone );
      66                 :     }
      67                 : 
      68               1 :     EXEC SQL select * INTO :custs2:inds from customers limit 2;
      69               1 :     printf("\ncusts2:\n");
      70               3 :     for (r = 0; r < 2; r++)
      71                 :     {
      72               2 :         printf( "name  - %s\n", custs2[r].name.arr );
      73               2 :         printf( "phone - %d\n", custs2[r].phone );
      74                 :     }
      75                 : 
      76               1 :     EXEC SQL select * INTO :custs3:inds from customers limit 2;
      77               1 :     printf("\ncusts3:\n");
      78               3 :     for (r = 0; r < 2; r++)
      79                 :     {
      80               2 :         printf( "name  - %s\n", custs3[r].name );
      81               2 :         printf( "phone - %d\n", custs3[r].phone );
      82                 :     }
      83                 : 
      84               1 :     EXEC SQL select * INTO :custs4:inds from customers limit 1;
      85               1 :     printf("\ncusts4:\n");
      86               1 :     printf( "name  - %s\n", custs4->name.arr );
      87               1 :     printf( "phone - %d\n", custs4->phone );
      88                 : 
      89               1 :     EXEC SQL select c INTO :onlyname from customers limit 2;
      90               1 :     printf("\nname:\n");
      91               3 :     for (r = 0; r < 2; r++)
      92                 :     {
      93               2 :         printf( "name  - %s\n", onlyname[r].arr );
      94                 :     }
      95                 : 
      96               1 :     EXEC SQL disconnect all;
      97               1 : 
      98                 :     /* All the memory will anyway be freed at the end */
      99               1 :     return 0;
     100                 : }