IT의 신

main(int argc, char *argv[]){ $char work1[100]; $char lname[100]; memset(work1,0x00,sizeof(work1)); memset(lname,0x00,sizeof(lname)); EXEC SQL conncet to "dbname"; EXEC SQL PREPARE _id FROM "select b from test where a=?"; strcpy(lname,"a"); EXEC SQL DECLARE test_cur SCROLL CURSOR FOR p_id; EXEC SQL OPEN test_cur using :lname; while(1){ EXEC SQL FETCH NEXT test_cur INTO :work1; if(sqlca.sqlcode==..

앞서 select 결과 1건 가져오는것과 비슷하지만 select 결과가 여러건 이면 cursor와 fetch next를 이용해서 처리한다. 소스를 보는게 빠르다^^ main(int argc, char *argv[]){ $char work1[100]; memset(work1,0x00,sizeof(work1)); EXEC SQL connect to "dbname"; EXEC SQL DECLARE test_cur SCROLL CURSOR FOR SELECT a FROM test; EXEC SQL OPEN test_cur; while(1){ EXEC SQL FETCH NEXT test_cur INTO :work1; if(sqlca.sqlcode==100){ break; }else if(sqlca.sqlcode!..