General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL Cursor and table shows as the same when display status
If you do a SQL * from a table into a cursor (which would result in the resultant being identical to the FROM table), doing display status shows the (FROM table) being open (which is correct) and the identity of the cursor is identical to the open table except that it shows a different alias and is readonly. If the exected SQL resultant is filtered and the resultant is not identical, the identity of the cursor is different. I was under the impression that a cursor always had an identity of its own!
Can somebody explain why this is happening?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only