using select in embedded sql with where clause should fetch

only one row , but cursor can be used when we need more rows

to be retrieved one at a time.

In case more than one row is retrieved in a select clause it

will throw -811 sql error.