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.
NULL value
Moderators: Kalicharan, Moderator Group
NULL value
Regards,
Vinod Reddy.
Vinod Reddy.
- dbzTHEdinosauer
- Moderator
- Posts: 981
- Joined: Mon Oct 02, 2006 8:31 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.
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.
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
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
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page