varchar dclgen field

Kevin Dcosta · New User Joined: 01 Jan 2008 Posts: 20 Location: Hyderabad

can the length part of a varchar field be set as zero ?

Craq Giegerich · Posted: Sat Sep 20, 2008 6:10 pm Post subject:

Kevin Dcosta · New User Joined: 01 Jan 2008 Posts: 20 Location: Hyderabad

i have verified thanks for your quick reply.

Craq Giegerich · Posted: Sat Sep 20, 2008 11:42 pm Post subject:

Your welcome, I'm glad I passed the test.

Anuj D. · Posted: Sun Sep 21, 2008 12:54 am Post subject:

Congratulation Craig..

..!

- Ad

Krishna Velamur · New User Joined: 22 Aug 2008 Posts: 22 Location: Hyderabad

Hi Kevin,
I have a question. Did you set the length as zero while inserting or while selecting?

dbzTHEdinosauer · Posted: Mon Sep 22, 2008 12:18 pm Post subject:

With a select, it does not matter what value with which the length field has been populated. Db2 will populate the length upon a successful select.

you can set the value to zero for both inserts and updates.

Krishna Velamur · New User Joined: 22 Aug 2008 Posts: 22 Location: Hyderabad

Hi Dick,
We can set the length value to zero while inserting as well as selecting. But as you said it doesn't matter while we are selecting because the length value will be populated. But while inserting, if we give the value as zero, the value in the text field will not be inserted. So i guess it will be better avoiding setting length to zero.

Corrections are welcome.

dbzTHEdinosauer · Posted: Mon Sep 22, 2008 1:22 pm Post subject: