Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose the outcome of executing a query results in a row
having null. Based on the answer how you use it? Its
declaration and inclusion?
- 2 Answers
- 6442 Views
- Verizon, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mani
While declaring the cursor include the null indicator for
the variables which you are retrieiving from the table.
Example.
Select empno,deptname from emp into
:ws-empno:ws-empno-ind,:ws-deptname:ws-deptname-ind
where empname='....'
Based on the values in ws-empno-ind,ws-deptname-ind we can
know whether the vaules being retrived are null are not.
If null indicator variable has a value -1 then the retrieved
value is null.
If you do no specify null indicator variable and the value
retreived is null then you would get -305 as the sqlcode.
The null indicator is declared as
05 ws-empno-ind s9(4) comp
| Is This Answer Correct ? | 22 Yes | 0 No |
wht steps we need will coding cobol and db2 pgm ?
What is database manager in db2?
What is meant by concurrency?
How do you Load a table ?? and what is Load replace ?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is correlated subquery?
Explain in brief how does db2 determine what lock-size to use?
What is the picture clause of the null indicator variable?
What is ibm db2 client?
Normalization in DB2 – first normal form, second normal form
why we go for SPUFI for creating tables or for sql queries?
How to update more then one record using update?
COBOL 
