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

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.