Answer Posted / yaswanth
we will use cursors when we have situation like the query
returning multiple rows but in this case
select Count(*) from EMP table where EMPNAME='some' will
return only one row, i.e how many rows it found with
EMPNAME='some' eg:3 or 4 or 5 ... so there is no concept of
cursor here
Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What is cursor in dbms?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How connect db2 database to datastage?
Is db2 a mainframe?
What is the physical storage length of date data type?
How to connect to db2 database from windows command line?
How to access db2 tables in mainframe?
What are the contents of dclgen?
How to test SQL -911 error while developing COB-DB2 program
How do I delete a column in db2?
What is the difference between nvl and coalesce?
What is the difference between spufi and qmf?
What is collection in db2 bind?
How can you classify the locks in db2?
What are the uses of db2 optimizer?