select * from jobqueue; select * from factoranalysisparameter where jobid = 1; select * from joblist where id = 1; select * from joblist; delete delete delete delete
from from from from
factoranalysisfactorselection where jobid = 1; factoranalysiscorr where jobid = 1; factoranalysisresult where jobid = 1; jobqueue;
-- select * from jobqueue; --insert into joblist (id, jobname, owner) values (1, 'job', 'user2'); --insert into factoranalysisparameter values(1, 20040622, 20041123, 30, 1, 20, 40, 60, 80, 5, 10, 'absolutenormal', 0); --insert into jobqueue values(1, 4, 'idle', 'factor analysis', '', ''); insert into jobqueue values(1, 1, 'idle', 'factor analysis', '', ''); --select * from fullfactorlist; --insert into fullfactorlist values(4, 0, 0); --insert into fullfactorlist values(4, 1, 1); --insert into fullfactorlist values(4, 2, 2); --insert into fullfactorlist values(4, 3, 3); --insert into fullfactorlist values(4, 4, 4); --insert into fullfactorlist values(4, 5, 5); insert into fullfactorlist values(1, 0, 0); insert into fullfactorlist values(1, 1, 1); insert into fullfactorlist values(1, 2, 2); insert into fullfactorlist values(1, 3, 3); insert into fullfactorlist values(1, 4, 4); insert into fullfactorlist values(1, 5, 5); commit;