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
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.
Vinod Reddy.

User avatar
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
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


Post Reply


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.
Mainframe Interview questions

Other References
Mainframe Tools and others