Pro C, DELETE

Pro C, DELETE example

#include <stdio.h>
#include "sqlca.h"

void error_msg(char *msg);

int main(void) {

 EXEC SQL BEGIN DECLARE SECTION;
     char *connstr = "scott/ojtit@orcl";
     int empno;
     VARCHAR job[20];
     int deptno;
 EXEC SQL END DECLARE SECTION;
 
 empno = 1000;
 
 EXEC SQL CONNECT :connstr;
 
 if(sqlca.sqlcode == 0) {
  printf("오라클 연결 성공\n");
 }else{
  printf("오류 : 오라클 연결 실패\n");
 }

 EXEC SQL WHENEVER NOT FOUND DO error_msg("검색된 행이  없습니다");

 EXEC SQL
  DELETE FROM
        EMPLOYEES
  WHERE
        empno = :empno;

 EXEC SQL COMMIT WORK;
 
 EXEC SQL
  SELECT
   empno, job, deptno
  INTO
   :empno, :job, :deptno
  FROM
   EMPLOYEES
  WHERE
   empno = :empno;
 
 job.arr[job.len] = '\0';
   
 printf("empno=%d, job=%s, deptno=%d \n", empno, job.arr, deptno);
 
 printf("프로그램 종료\n");
 return 0;
 
}

void error_msg(char * msg) {
 printf("%s \n", msg);
}