- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What we can conclude if the final value in the NULL indicator is -2?
A NULL indicator is a 2 bytes field which serves the multiple purpose. This indicator takes the value as -1 when any DB2 column has NULL value and it takes the value as 0 when DB2 column has a non NULL value.
Although the main purpose of the NULL indicator is to check whether a column has a NULL value or not, this indicator can take a value of -2 as well. A -2 value in this indicator states that a NULL value was assigned to the host variable as a result of evaluating an expression with an arithmetic error, or by an overflow while attempting to convert the numeric result value to the host variable.
- Related Articles
- What will happen if a NULL value is detected for a SQL statement in COBOL-DB2 program and the NULL indicator is not used?
- What would be the output if we use a NULL value in an arithmetic expression?
- Can we declare the main () method as final in Java?
- How can we overcome the property of CONCAT() function that it returns NULL if any one of the argument is NULL, especially when we want to concatenate the values from the column and any of the columns have NULL as its value?
- What is the value we get if we add -18 and + 10?
- Can we override final methods in Java?
- Can we declare the method of an Interface final in java?
- How can we store any other value than N in CSV file if we export the data to CSV file from a table which contains a NULL value(s)?
- Insert default into not null column if value is null in MySQL?
- Can we initialize blank final variable in Java
- Can we inherit a final method in Java?
- Can we declare constructor as final in java?
- What happens if we try to extend a final class in java?
- What MySQL MAKE_SET() function returns if the value of the bit is 1 and the first string is NULL?
- How to validate aninput field if the value is not NULL in Laravel?
Advertisements