Interested to Buy Any Domain ? << Click Here >> for more details...
What value the host varible will contain , if null
indicator value is -2 ? Will it contain the truncated value
or nothing will move ?
- 3 Answers
- 12646 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / prachi
The null-indicator variable is examined for a negative
value. If the value is not negative, the application can
use the returned value of the host variable. If the value
is negative, the fetched value is null and the host
variable should not be used. The database manager does not
change the value of the host variable in this case.
Note:
If the database configuration parameter dft_sqlmathwarn is
set to 'YES', the null-indicator variable value may be -2.
This value indicates a null that was either caused by
evaluating an expression with an arithmetic error, or by an
overflow while attempting to convert the numeric result
value to the host variable.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is cobol db2?
What is the use of dclgen in db2?
What is package in cobol db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Name the lockable units in DB2?
What is the role of schema in the db2 database?
Which component is responsible for db2 startup and shutdown?
What is buffer pool?
What is copy pending status in db2?
Is ibm db2 free?
What is consistency token in db2?
How can you count the number of rows from a table tab?
What is difference between alias and synonym in db2?
Define declaration generator (dclgen).
How to fetch the last row from the table in SQL (db2)?
