Use C to execute the SQL statement in the variable Qstring.
void main () { EXEC SQL BEGIN DECLARE SECTION END-EXEC. char Qstring[100] = "INSERT INTO WORK_TABLE SELECT * FROM EMPPROJACT WHERE ACTNO >= 100"; EXEC SQL END DECLARE SECTION END-EXEC. EXEC SQL INCLUDE SQLCA; . . . EXEC SQL EXECUTE IMMEDIATE :Qstring; return; }
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.