I'm  not too sure about accessing different namespaces via SQL but you can use a variety of %ResultSet objects but personally I prefer using an SQL cursor with SQL open, fetch to iterate through the object.

My 'personal' reasons for preferring SQL cursors is that they are extremely fast to develop but more importantly if you add/remove indices in the target class then the class that uses the cursor will use the best available indices without requiring re-compilation unlike at least some of the %ResultSet methods.


Thank you ever so much for all of your replies. They are really helpful.


I have been given so many useful tips that Ive solved the problem now.


Thank you.



Hi, my apologies. I should have mentioned that we are using Cache 2012.1 for Linux.

Steve has no followers yet.
Steve has not followed anybody yet.
Global Masters badges:
Steve has no Global Masters badges yet.