BAZE ISPIT

sprintf(stmt, “insert into ispitni_rok values (?,?,?,?,?,?)”);
EXEC SQL PREPARE ime FROM :stmt;
EXEC SQL EXECUTE ime USING :p1, :p2, p3, p4, p5, p6;


EXEC SQL EXECUTE IMMEDIATE :stmt;


EXEC SQL DECLARE ime CURSOR WITH HOLD FOR
select ime, prezime from dosije;
EXEC SQL OPEN ime;
	while(1){
		EXEC SQL FETCH ime INTO :ime, :prezime
		if(SQLCODE==100){
			break;
		}
	}
EXEC SQL CLOSE ime;


EXEC SQL BEGIN COMPOUND (NOT) ATOMIC STATIC (STOP AFTER FIRST :br STATEMENTS)
	insert into……… moze vise upita
	(COMMIT;)
END COMPOUND:


EXEC SQL SAVEPOINT s1 ON ROLLBACK RETAIN CURSORS;
EXEC SQL ROLLBACK TO SAVEPOINT s1;


obrada cekanja:
u while se pitam da lii je -913 ili -901
	i ako jeste odem goto labela

pitam se da li je posecen, (posecen proverava da li ga ima u nizu), ako nije posecen radim commit i dodajem ga u niz, continue
u labeli: rollback, opet otvorim kursor


==========================================
vise korisnika u javi
u try stavim update i ako uspe con.commit() i dodam ga u listu
u catch 913, 911, rs.close(), con.rollback(), i opet rs.execute

a while try/catch, sve isto kao gore samo nema rs close

pre close svega, opet commit


rs.TYPE rs.CONCUR rs.HOLD, bitan redosled
rs.updateInt(“bodovi”, bodovi+1); — kada zelim da updatujem select
rs.setInt(prvi, vrednost);
rs.TYPE_SCROLL_INSENSITIVE, rs.CONCUR_READ_ONLY
rs.afterLast()