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
- 12803 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 null value in db2?
How do I add a column to a table in db2?
What os does db2 run on?
What is ibm db2 client?
What is a bind in db2?
What do you mean by between and in? Is between inclusive of specified range values?
what is a corelated subquerry?
Discuss about db2 bind?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Explain the contention situations caused by locks?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is rebind in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What types of tables are there in the db2 database?
What is syscat in db2?
