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 dbrm? When it will be created?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is db2 catalog database?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is the purpose of using commit?
Explain about mirror activator disk mirroring?
What is netezza database?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is innodb buffer pool?
What are db2 tables?
What is cursor stability in db2?
How many databases can be created inside an instance in db2 ?
What is explain plan in db2?
How do I delete a table in db2?