Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Low values & High values in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
avaneendra_linga

New User


Joined: 13 Dec 2006
Posts: 73
Location: Hyderabad

PostPosted: Fri Jan 11, 2008 10:51 pm    Post subject: Low values & High values in DB2
Reply with quote

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
View user's profile Send private message

Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Fri Jan 11, 2008 10:57 pm    Post subject: Re: Low values & High values in DB2
Reply with quote

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
View user's profile Send private message
avaneendra_linga

New User


Joined: 13 Dec 2006
Posts: 73
Location: Hyderabad

PostPosted: Sat Jan 12, 2008 12:44 am    Post subject:
Reply with quote

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
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Sat Jan 12, 2008 12:47 am    Post subject:
Reply with quote

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
View user's profile Send private message
Phrzby Phil

Active Member


Joined: 31 Oct 2006
Posts: 965
Location: Richmond, Virginia

PostPosted: Sat Jan 12, 2008 7:21 am    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Working with hex values in Filemanage... Emile Straker IBM Tools 0 Tue Sep 12, 2017 1:42 am
No new posts DB2 NULL Values display V S Amarendra Reddy DB2 3 Thu Sep 07, 2017 6:59 pm
No new posts Moving values to a variable of copybo... Vignesh Sid COBOL Programming 6 Wed Sep 06, 2017 1:04 pm
No new posts BI,TO=ZD Changing Values Tyler Dunbar DFSORT/ICETOOL 4 Tue Jul 25, 2017 12:12 am
No new posts Sorting of hex values Saurabh_mi DFSORT/ICETOOL 11 Thu May 25, 2017 3:49 pm

Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us