exec sql include sqlca;

FILE *dbgs;

main()
{
EXEC SQL BEGIN DECLARE SECTION;
 char thisone[50];
EXEC SQL END DECLARE SECTION;

 if ((dbgs = fopen("log", "w")) != NULL)
        ECPGdebug(1, dbgs);

 exec sql connect to mm;
 exec sql create table t (thisone char(50));
 exec sql insert into t(thisone) values ('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwx');

 exec sql commit;

  printf("Now the pointer is %p\n",thisone);
  EXEC SQL SELECT thisone INTO :thisone FROM t;
  printf("Now the pointer is %p %s\n",thisone,thisone);

 exec sql drop table t;
 exec sql commit;
 exec sql disconnect;

 if (dbgs != NULL)
       fclose(dbgs);
}