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
- 6445 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 |
How to check table size in db2 sap?
What is db2? Explain.
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
What is lock escalation in db2?
What does db2 blu stand for?
What is the logical entity between plan and Package?
What does an outer join do?
What are the functions in DB2?
What does sqlcabc has?
How Plan is created while executing the query using SPUFI?
Q3. How will you fetch duplicate values from a DB2 table?
Explain the use of the WHERE clause.
COBOL 
