What value the host varible will contain , if null
indicator value is -2 ? Will it contain the truncated value
or nothing will move ?
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 a db2 collection?
What is db2 connect?
What is query_cache_limit?
What is a collection in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is collection in db2 bind?
How can deadlocks be resolved?
What is the role of the data page in the db2 database?
How do I optimize a query in db2?
What are the full forms of spufi and dclgen and why are they used?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Define check constraint.
What is an instance in db2?
How to compare data between two tables in db2?
How do I add a column to a table in db2?