![]() |
Powered by QM on a Rpi server |
|
KnowledgeBase 00080: SELECT SAVING with Multivalued DataThis article was originally published as a Tip of the Week. IntroductionThe SAVING keyword used in a query processor SELECT operation creates a select list based on the content of a named field in the data file being processed. SELECT SALES SAVING PART.NOFor compatibility with other multivalue products, when the field being saved is multivalued, only the first value is saved. With the above example, this would be the first part number from each order record in the SALES file. This behaviour is likely to result in incomplete data in the select list. The MULTIVALUED KeywordQM supports a MULTIVALUED qualifier to the SAVING clause SELECT SALES SAVING MULTIVALUED PART.NOWith this qualifier, all of the values in the multivalued PART.No field are added to the select list. Related ArticlesNone. |