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
- 12779 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
What is the max length of sqlca?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
What are leaf pages?
How and when does the db2 enforces the unique key?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
How would the varchar column remarks defined?
What is copy pending and check pending in db2?
WHAT IS MEANT BY COMMIT COMMAND?
What is host variable in db2 cobol?
What do you need to do before you do EXPLAIN?
What is an intent lock?
COBOL 
