2
exec sql include sqlca;
7
exec sql begin declare section;
10
exec sql end declare section;
13
if (getenv("SQLOPT")) ECPGdebug(1,stderr);
15
exec sql whenever sqlerror do sqlprint();
16
exec sql connect to template1;
18
exec sql allocate descriptor mydesc;
19
exec sql select tablename into descriptor mydesc from pg_tables;
20
exec sql get descriptor mydesc value 1 :cpp=DATA, :ipointer=INDICATOR;
23
for (i=0;i<sqlca.sqlerrd[2];++i)
24
{ if (ipointer[i]) printf("NULL, ");
25
else printf("'%s', ",cpp[i]);
30
exec sql deallocate descriptor mydesc;