468,257 Members | 1,472 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,257 developers. It's quick & easy.

DB2 equiv. to setDefaultFixedString [oracle]

the problem: the users want to enter a single space in a col/field
from a jsp page, and have it go back and forth as such to UDB/V8.

looking at the rows in various editors, hex(foo) shows 20 for the
length of the column. this is good.

but the users want to be able to hit <spacebar> on an input field,
and get that back later. why a space is important is a legacy
software issue which i can't change (think: cobol).

jdbc, but not the database editors, seems to truncate to a zero
length string. the columns are type char.

from what i read on comp.databases.oracle, this method on
connection will do the trick. it's not defined on jdbc 2.0.

something equivalent in db2?? didn't come up with any obvious
candidates.

thanks,
robert
Nov 12 '05 #1
0 902

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by susmita_ganguly | last post: by
8 posts views Thread by Nige | last post: by
2 posts views Thread by runway27 | last post: by
2 posts views Thread by Ruslan A Dautkhanov | last post: by
reply views Thread by Jack | last post: by
reply views Thread by Winder | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.