IBM Mainframe Forum

Mainframe Technical Support Forums

Skip to content


Update column names with value which is null val



IBM's flagship relational database management system
Post a reply

Update column names with value which is null val

Postby ragur.satheesh » Mon Dec 13, 2010 12:04 pm

I want to update the column name with valid value which is having null values?
ragur.satheesh
 
Posts: 17
Joined: Thu Jul 22, 2010 12:34 pm
Has thanked: 0 time
Been thanked: 0 time
Top

Re: Update column names with value which is null val

Postby NicC » Mon Dec 13, 2010 2:32 pm

There is no such thing as 'NULL VALUE'. If a column does not have a value a seperate byte is set to indicate there is no data. This is known as the NULL INDICATOR. YOu can put anything you want in a column as long as it conforms to the datatype of the column.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times
Top
Post a reply

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post
Forum Rules|FAQ|Subscriptions|Bookmarks