What value the host varible will contain , if null
indicator value is -2 ? Will it contain the truncated value
or nothing will move ?
Answers were Sorted based on User's Feedback
Answer / santy
That Host Variable contain the Truncated value when Null
Indicator conatin value -2.
Is This Answer Correct ? | 18 Yes | 2 No |
Answer / mk
If the null indicator value is -ve, then the field will
have null value. if -2 means then there is a data
conversion error resulted the null indicator set to -2, so
the field will have nothing.
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / 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 |
Before you give the explain statement, what are the prerogatives?
List out the data types available.
What is REORG? When is it used?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
what happend with out using Commit,when closing cursor and program?
What is lock contention?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
How do you insert a record with a nullable column?
How can you quickly find out the number of rows updated after an update statement?
What is the self-referencing constraint?
How to get Top 10 Salaries from a Table
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?