Joined: 23 Jul 2008 Posts: 13 Location: Little Rock - Arkansas
My requirement is that,
In one of the query where it does select one row everytime is giving -811 and so it means there are multiple records for the entry, since the production cycle running under this query is out of my subsystem i cannot view the table. but i want to fetch the last row this query is using, for first row we give 'FIRST ROW ONLY' . Similarly is thr any option for picking the last row.
Please let me know ur views n suggestions on the same.
Joined: 19 May 2007 Posts: 1027 Location: Virginia, USA
Using the data that may be returned from a select with a failure SQL code is not a good idea, a new version of DB2 may not return the same or any data.
