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
pgp9G8efLnVnI.pgp
Description: PGP signature
