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
- 12775 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
can we view the access paths created by dbrm ? how ? thx
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What db2 400?
Give a brief description of db2 isolation levels?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is db2? Explain.
What is db2 plan table?
List down the data types in the db2 database.
What is buffer pool?
What is bind and rebind in db2?
What are foreign keys in db2?
How connect db2 database to datastage?
What is role in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Name the various locking levels available?
