You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by fu...@apache.org on 2006/09/27 07:30:17 UTC
svn commit: r450324 -
/db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita
Author: fuzzylogic
Date: Tue Sep 26 22:30:16 2006
New Revision: 450324
URL: http://svn.apache.org/viewvc?view=rev&rev=450324
Log:
DERBY-1753: Fix the references to SYSCS_INPLACE_COMPRESS_TABLE in the examples
for the procedure in the documentation.
Committed for Laura Stewart <sc...@gmail.com>
Modified:
db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita
Modified: db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita?view=diff&rev=450324&r1=450323&r2=450324
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefproceduresinplacecompress.dita Tue Sep 26 22:30:16 2006
@@ -83,7 +83,7 @@
will likely return much less space:<codeblock><b>call SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('US', 'CUSTOMER', 0, 0, 1);</b></codeblock></p></section>
<section><title>Java example</title><p>To compress a table called CUSTOMER
in a schema called US, using all available compress options:<codeblock>CallableStatement cs = conn.prepareCall
-("CALL SYSCS_UTIL.SYSCS_COMPRESS_TABLE(?, ?, ?, ?, ?)");
+("CALL SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE(?, ?, ?, ?, ?)");
cs.setString(1, "US");
cs.setString(2, "CUSTOMER");
cs.setShort(3, (short) 1);
@@ -92,7 +92,7 @@
cs.execute();</codeblock></p><p>To return the empty free space at the end
of the same table, the following call will run much quicker than running all
options but will likely return much less space:<codeblock>CallableStatement cs = conn.prepareCall
-("CALL SYSCS_UTIL.SYSCS_COMPRESS_TABLE(?, ?, ?, ?, ?)");
+("CALL SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE(?, ?, ?, ?, ?)");
cs.setString(1, "US");
cs.setString(2, "CUSTOMER");
cs.setShort(3, (short) 0);