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
- 6415 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 |
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
What is concurrency in db2?
Mention the definition of cobol in varchar field.
What is the advantage in De-normalizing tables in DB2?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
Differentiate between cs and rr isolation levels? Where do you specify them?
Can you Average the Characters ?
What is the syntax for creating a table in the db2 database?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
my project is insurance management system,how to explain my work environment in interview?
What is db2 and what is the use of db2 optimizer?
What will happen, while trying to close the closed cursor.
COBOL 
