Select more than one row from a table using select query

murali_soorya · New User Joined: 08 Mar 2005 Posts: 1 Location: Chennai

Dear Friends,
I have one doubt please rectify it,
In Oracle(Rdbms) it is possible to Select more than one row from a table using select query where as in DB2(Rdbms) it throws an error of -811 why?

vasanthanc · Active User Joined: 01 Apr 2005 Posts: 59

You can select more than one row in db2 also. But from where u tried to execute the query? In cobol program, u need to user cursor to traverse through the rows. Explain your problem in detail

jkbytes

Hi murali,

You can select more than one row in DB2 using SPUFI,
but from the -811 its sure you are trying to retreive more than one row using DB2 - cobol program.
You can acheive it by means of defining a cursor, opening it then fetching it and finally closng it.