NULL value

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
156138
Member
Posts: 15
Joined: Tue Aug 29, 2006 7:27 pm
Location: Chennai

NULL value

Post by 156138 » Mon Dec 04, 2006 6:55 pm

What is hex equivalent for a NULL value.
I think there won't be any hex equivalent for NULL,correct me if iam wrong.

Suppose if a want directly edit a DB2 table in which
value of a NULLABLE field should be made as NULL.Is there is anyway to
do it.
Regards,
Vinod Reddy.

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Mon Dec 04, 2006 7:32 pm

There is a lot of documentation on this subject; suprised you did not bother to read.

In DB2, the concept of NULL has to do with 'if there is a value assigned'. NULL is not a value, it is a condition. A Nullable column has an associated NULL Indicater which is set to -1 if the column is NULL and is not set to -1 if the nullable column indeed contains data. There is no hex value to represent NULL.
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

User avatar
Leo
Member
Posts: 13
Joined: Tue Nov 14, 2006 12:02 pm
Location: HYBD

Post by Leo » Tue Dec 05, 2006 5:05 pm

Hi Vinod

You can use "space" to make a field null , press the space bar . This method may not work for all the data types , in this case you will have to run a spufi query

SET column name = NULL
WHERE condition

Thanks
Leo

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others