-----------------------------------------------------------------
-- USLOVNI_PREDMET
-----------------------------------------------------------------
drop table uslovni_predmet;

create table uslovni_predmet (
       id_predmeta      integer      not null,
       id_uslovnog      integer      not null,
       primary          key(id_predmeta,id_uslovnog),
       foreign          key id_predmeta_koji_se_polaze(id_predmeta) references predmet(id_predmeta),              
       foreign          key id_uslovnog_predmeta      (id_uslovnog) references predmet(id_predmeta)

                             );

delete from predmet;

LOAD FROM predmet.load OF DEL MODIFIED BY COLDELX09 
     METHOD P (1, 2, 3, 4) MESSAGES predmet.load.izv 
     INSERT INTO PREDMET (id_predmeta, sifra,naziv,bodovi) NONRECOVERABLE INDEXING MODE AUTOSELECT;


import from uslovniPredmet.ixf of ixf commitcount 1000 replace into  uslovni_predmet;

