unable to use dynamic sql and Pro*C
I can compile and execute but the results are not what is expected.
void mytest()
{
EXEC SQL BEGIN DECLARE SECTION;varchar myid[ID_SIZE];
short myid_x=0;
long mycount=0L;EXEC SQL END DECLARE SECTION;
// always returns zero
EXEC SQL PREPARE s FROM "select count(*) into :mycount from tbl1";EXEC SQL DECLARE c CURSOR FOR s;
EXEC SQL OPEN c;
EXEC SQL FETCH c INTO :mycount;
// always returns null
EXEC SQL PREPARE s FROM "select xid into :myid from tb1";EXEC SQL DECLARE c CURSOR FOR s;
EXEC SQL OPEN c;