Recommendations for Compiling References to Result Sets

Recommendations for Compiling References to Result Sets

Welcome to our Knowledge Base

Documentation | Blog | Demos | Support

< All Topics
Print

Recommendations for Compiling References to Result Sets

Most problems with references to named sets can be alleviated by adhering to the following guidelines:

  • Qualify set operations by explicitly giving the set name where possible (e.g., next set1, top set1) rather than letting the software implicitly assume the current set.

  • Declare set objects in the database, forcing the software to check the structure of result sets that employ a particular name.

  • Always give a set an explicit name.

  • Never use the same name for sets whose component structures are different (see Example 4 and Example 5). With SET CHECKSETS ON, the software enforces this recommendation.

  • Use the SET CURRENTSET command to specify the result set that is to be the current set in a particular situation.

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.

Leave a Reply

Your email address will not be published. Required fields are marked *

en_CAEnglish