Reclaim space in VARCHAR field

[OKogan@xxxxxxxxxxxxxxxxxx]

We are developing an application which will use a data compression algorithm
to pack extra data into a DB2/400 binary capable VARCHAR field (CCSID
65535). We are exploring the possibility of storing the raw data into the
field with RPG ILE, then compressing the field contents later with GZIP and
UPDATE via java program.

When a VARCHAR field is updated with a smaller string, DB2 doesn't seem to
reclaim the space allocated when the field was initially set. Even RGZPFM
wouldn't help? How can the storage be reclaimed, other than with
delete/write back?  We are at V4R4 and we are using JDBC driver.
File was created with DDS and field has length of 32000(buffer length 32002)

Any help you can give us would be appreciated.

Thanks.



The information transmitted by the following E-Mail is intended only for the
addressee and may contain confidential and/or privileged material. Any
interception, review, retransmission, dissemination, or other use, or taking
any action upon this information by persons or entities other than the
intended recipient is prohibited by law and may subject them to criminal or
civil liability. If you received this communication in error, please contact
us immediately at 954-730-2900 ext. 3600 and delete the communication from
any computer or network system.



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---