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.
V0191:
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> ... <array type> ::= <data type> ARRAY [ <left bracket or trigraph> <maximum cardinality> <right bracket or trigraph> ] 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 S232, "Array locators", conforming SQL language shall not contain a <parameter type> that contains a <locator indication> and that simply contains a <data type> that identifies an array type. Without Feature S232, "Array 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 an array type. Subclause 13.3, "<externally-invoked procedure>": <host parameter data type> ::= <data type> [ <locator indication> ] ... Conformance Rules Without Feature S232, "Array locators", conforming SQL language shall not contain a <host parameter data type> that simply contains an <array type> and that contains a <locator indication>. Subclause 21.3, "<embedded SQL Ada program>": <Ada array locator variable> ::= SQL TYPE IS <array type> AS LOCATOR ... Conformance Rules Without Feature S232, "Array locators", conforming SQL language shall not contain an <Ada array locator variable>. Subclause 21.4, "<embedded SQL C program>": <C array locator variable> ::= SQL TYPE IS <array type> AS LOCATOR <C host identifier> [ <C initial value> ] [ { <comma> <C host identifier> [ <C initial value> ] } ... ] ... Conformance Rules Without Feature S232, "Array locators", conforming SQL language shall not contain an <C array locator variable>. Subclause 21.5, "<embedded SQL COBOL program>": <COBOL array locator variable> ::= [ USAGE [ IS ] ] SQL TYPE IS <array type> AS LOCATOR ... Conformance Rules Without Feature S232, "Array locators", conforming SQL language shall not contain a <COBOL array locator variable>. Subclause 21.6, "<embedded SQL Fortran program>": <Fortran array locator variable> ::= SQL TYPE IS <array type> AS LOCATOR ... Conformance Rules Without Feature S232, "Array locators", conforming SQL language shall not contain a <Fortran array locator variable>. Subclause 21.7, "<embedded SQL MUMPS program>": <MUMPS array locator variable> ::= SQL TYPE IS <array type> AS LOCATOR ... Conformance Rules Without Feature S232, "Array locators", conforming SQL language shall not contain a <MUMPS array locator variable>. Subclause 21.8, "<embedded SQL Pascal program>": <Pascal array locator variable> ::= SQL TYPE IS <array type> AS LOCATOR ... Conformance Rules Without Feature S232, "Array locators", conforming SQL language shall not contain a <Pascal array locator variable>. Subclause 21.9, "<embedded SQL PL/I program>": <PL/I array locator variable> ::= SQL TYPE IS <array type> AS LOCATOR ... Conformance Rules Without Feature S232, "Array locators", conforming SQL language shall not contain a <PL/I array locator variable>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.