第一个问题,查看
sqlca.sqlerrd[2]
第二个问题,使用动态SQL语句,比如prepare语句
查看例子代码
sprintf(dynstmt.arr,
"select %s into :c from table1 where b=1",aa);
dynstmt.len = (unsigned short)strlen((char *)dynstmt.arr);
EXEC SQL PREPARE S FROM :dynstmt;
EXEC SQL DECLARE C CURSOR FOR S;
EXEC SQL OPEN C ;