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
- 6320 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 |
What is EXPLAIN?
what is sql abend code -801,-802?
what is parm utility
how to resolve -811 sqlcode .give clear explaination
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
How can you count the number of rows from a table tab?
How to get the ddl of a table in db2?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
What is the SQL Communications Area and what are some of its key fields?
What is the self-referencing constraint?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What are the various data types available in db2?
COBOL 
