Hello,

I've the following problem:

I will let run a procedure with a loop for every entry of table n_arbumfang taken in a 
cursor. 
In the loop will be started two procedures:

The first (proc_verguet_buch) contains 3 Queries for the table t_dbv which supply the 
variable verguet_buch.

The second (proc_buch_n) starts an update statement like 

       update dba.n_Stellen 
       set vze_anspruch=vze_anspruch+:vze 
       where deckring_sl in 
        (select deckring_sl from DBA.n_deckring 
        where verguet_sl=:c_verguet and not ueberlauf)
       and akt_datum>=:c_beg and akt_datum<=:c_end
       AND SCHULAMT_NR= SANR; 

This is the only statement to change the database, but it concerns ca. 5000 to 10000 
of 40000 entries of table n_stellen. 

When I start the procedure database manager shows 13% of data dev space are used.
After booking(= updating of n_stellen) of 1000 from the 9000 entries of table 
n_arbumfang 60% of data dev space are used 
and after booking of 1700 from the 9000 entries of table n_arbumfang the 100% of data 
are used, but there is no insert statement - only the above listed update statements 
of n_stellen.
It shows 'database is full', but it can't be!

Can anybody help me?

Thank you

Ines




Ines Liefeldt

Ministerium f�r Bildung, Jugend und Sport

Tel.: 0331/866-3743
e-Mail: [EMAIL PROTECTED] 

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to