Select Code to Download

char emp_name[50][20];
int emp_number[50];
...
/* populate the host arrays */
EXEC SQL INSERT INTO EMP (ENAME, EMPNO, SAL)
     VALUES (:emp_name, :emp_number, :salary);

int emp_number[50];
float salary[50];
/* populate the host arrays */
EXEC SQL UPDATE emp SET sal = :salary
     WHERE EMPNO = :emp_number;

int emp_number[50];
/* populate the host array */
EXEC SQL DELETE FROM emp
     WHERE empno = :emp_number;