Suppose the outcome of executing a query results in a row having null. Based o

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?

Question Posted / khbnaidu

2 Answers
5294 Views
Verizon, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Suppose the outcome of executing a query results in a row having null. Based on the answer how you..

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

Suppose the outcome of executing a query results in a row having null. Based on the answer how you..

Answer / keshireddy

Perfect

Is This Answer Correct ?

3 Yes

1 No

Post New Answer