Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
V0192:
The specification states the following:
-
Subclause 6.1, "<data type>": <data type> ::= <predefined type> | <row type> | <path-resolved user-defined type name> | <reference type> | <collection type> ... <multiset type> ::= <data type> MULTISET Subclause 11.60, "<SQL-invoked routine>": <parameter type> ::= <data type> [ <locator indication> ] <locator indication> ::= AS LOCATOR ... <returns data type> ::= <data type> [ <locator indication> ] ... Conformance Rules Without Feature S233, "Multiset locators", conforming SQL language shall not contain a <parameter type> that contains a <locator indication> and that simply contains a <data type> that identifies a multiset type. Without Feature S233, "Multiset locators", conforming SQL language shall not contain a <returns data type> that contains a <locator indication> and that simply contains a <data type> that identifies a multiset type. Subclause 13.3, "<externally-invoked procedure>": <host parameter data type> ::= <data type> [ <locator indication> ] ... Conformance Rules Without Feature S233, "Multiset locators", conforming SQL language shall not contain a <host parameter data type> that simply contains a <multiset type> and that contains a <locator indication>. Subclause 21.3, "<embedded SQL Ada program>": <Ada multiset locator variable> ::= SQL TYPE IS <multiset type> AS LOCATOR ... Conformance Rules Without Feature S233, "Multiset locators", conforming SQL language shall not contain an <Ada multiset locator variable>. Subclause 21.4, "<embedded SQL C program>": <C multiset locator variable> ::= SQL TYPE IS <multiset type> AS LOCATOR <C host identifier> [ <C initial value> ] [ { <comma> <C host identifier> [ <C initial value> ] } ... ] ... Conformance Rules Without Feature S233, "Multiset locators", conforming SQL language shall not contain a <C multiset locator variable>. Subclause 21.5, "<embedded SQL COBOL program>": <COBOL multiset locator variable> ::= [ USAGE [ IS ] ] SQL TYPE IS <multiset type> AS LOCATOR ... Conformance Rules Without Feature S233, "Multiset locators", conforming SQL language shall not contain a <COBOL multiset locator variable>. Subclause 21.6, "<embedded SQL Fortran program>": <Fortran multiset locator variable> ::= SQL TYPE IS <multiset type> AS LOCATOR ... Conformance Rules Without Feature S233, "Multiset locators", conforming SQL language shall not contain a <Fortran multiset locator variable>. Subclause 21.7, "<embedded SQL MUMPS program>": <MUMPS multiset locator variable> ::= SQL TYPE IS <multiset type> AS LOCATOR ... Conformance Rules Without Feature S233, "Multiset locators", conforming SQL language shall not contain a <MUMPS multiset locator variable>. Subclause 21.8, "<embedded SQL Pascal program>": <Pascal multiset locator variable> ::= SQL TYPE IS <multiset type> AS LOCATOR ... Conformance Rules Without Feature S233, "Multiset locators", conforming SQL language shall not contain a <Pascal multiset locator variable>. Subclause 21.9, "<embedded SQL PL/I program>": <PL/I multiset locator variable> ::= SQL TYPE IS <multiset type> AS LOCATOR ... Conformance Rules Without Feature S233, "Multiset locators", conforming SQL language shall not contain a <PL/I multiset locator variable>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.