db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kurt Huwig <k.hu...@iku-ag.de>
Subject Re: How delete rows in table with free disk space?
Date Mon, 02 Jul 2007 19:06:42 GMT
Am Montag, 2. Juli 2007 schrieb Ekrame Ayari:
> Hi
>
> I wish to remove table rows to allow user decrease space disk.
>
> I try to delete table rows for free disk space with this code :
>
> "Connect connect =
> DriverManager.getConnection("jdbc:derby:GenoCensusMin2"); Statement stat =
> connect.createStatement();
> stat.executeUpdate("DELETE FROM Project WHERE id="+idProjet);"
>
> But disk space size of my system directory is the same before and after
> the deletion.
>
> Can you help me?

Try this:

CALL SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('APP','PROJECT',1,1,1)
-- 
Mit freundlichen Grüßen

Kurt Huwig

GnuPG 1024D/99DD9468 64B1 0C5B 82BC E16E 8940  EB6D 4C32 F908 99DD 9468

Mime
View raw message