|Powered by QM on a Linux server|
KnowledgeBase 00080: SELECT SAVING with Multivalued Data
The 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 Keyword
QM 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.