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
- 12840 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 db2 optimizer?
How to take backup of table in db2?
What is null in db2?
How to check table size in db2 sap?
What are concurrency issues?
What are iseries servers?
what is diffrence b/w file-aid tool and file-aid utility???
What is the clustering index in the db2 database?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is precompiler in db2?
What is db2?
Define declaration generator (dclgen).
What is a db2 table?
What is scrollable cursor in db2?
What is db2 bind?
