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
- 12673 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
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the difference between spufi and qmf?
What is the difference between plan and package in db2?
What is the role of the data page in the db2 database?
What is the physical storage length of the data types date, time, and timestamp?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is meant by explain?
Explain the benefits you can get from mainframe connect?
How do I copy a table in db2?
What is db2 plan table?
What is sqlca’s maximum length?
List down the data types in the db2 database.
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is the connection string to connect to the DB2 Database ?
What is a trigger in the db2 database?
