View previous topic :: View next topic
|
Author |
Message |
avaneendra_linga
New User
Joined: 13 Dec 2006 Posts: 73 Location: Hyderabad
|
|
|
|
Hi..
I have small doubt here with Low & High values?
what will happen if i move low values to DB2 table column ?
1) what if it is default value defined as NOT NULL?
2) and as NULL ?
and what will happen for the same if we are moving High values and updating the table?
Thanks in advance. |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
avaneendra_linga wrote: |
Hi..
I have small doubt here with Low & High values?
what will happen if i move low values to DB2 table column ?
1) what if it is default value defined as NOT NULL?
2) and as NULL ?
and what will happen for the same if we are moving High values and updating the table?
Thanks in advance. |
Low & high values are just characters as far as DB2 is concerned. If a field is char and nullable you can put either low or high values into it. If a field is nullable and you set the null indicator to -1 then it does not matter what is in the data. |
|
Back to top |
|
|
avaneendra_linga
New User
Joined: 13 Dec 2006 Posts: 73 Location: Hyderabad
|
|
|
|
so what will be the output when i queried that column?
if i move low values to host variable and update DB2 column (whcih can be null) without setting null indicator to -1 |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
avaneendra_linga wrote: |
so what will be the output when i queried that column?
if i move low values to host variable and update DB2 column (whcih can be null) without setting null indicator to -1 |
The output would be the same as what you stored in the column! |
|
Back to top |
|
|
Phrzby Phil
Senior Member
Joined: 31 Oct 2006 Posts: 1042 Location: Richmond, Virginia
|
|
|
|
Why not just try it already and let us know what did in fact happen? You must have a test table somewhere. |
|
Back to top |
|
|
|