ISO/IEC INTERNATIONAL STANDARD 13249-1 Fourth edition 2016-06-01 Information technology Database languages - SQL multimedia and application packages Part 1: Framework Technologies de I'information - Langages de bases de données - Multimédia SQL et paquetages d'application Partie 1: Cadre général Reference number ISO/IEC13249-1:2016(E) IEC S International Organization for Standardization G INST OF STANDARDIZATION C1 5956617 @ IS0/IEC 2016 ted without license from IHS IS0/IEC 13249-1:2016(E) COPYRIGHT PROTECTED DOCUMENT IS0/IEC 2016, Published in Switzerland All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized otherwise in any form written permission. Permission can be requested from either Iso at the address below or Iso's member body in the country of the requester. ISO copyright office Ch. de Blandonnet 8 . CP 401 CH-1214 Vernier, Geneva, Switzerland Tel. +41 22 749 01 11 Fax +41 22 749 09 47 [email protected] www.iso.org Internatinir DrganizationforStandardization Licensee-ZHEJIANG INST.OF STANDRJSQ/6NEC6- All rights reserved No reproduction or networking permited without license from IHS IS0/IEC 13249-1:2016(E) Contents Page Foreword ..iv Introduction.. ..V 1 Scope. ..1 2 Normative references 3 Terms and definitions. ..1 3.1 Terms defined in IS0/IEC 9075-1 .1 3.2 Terms defined in IS0/IEC 9075-2 3.3 Terms defined in this part of IS0/IEC 13249 .2 4 Concepts. .3 4.1 Concepts taken from parts of ISo/IEc 9075 ..3 4.2 Generic kinds of data and common table structures 4 4.3 Use of parts of IS0/IEC 9075 ..4 4.3.1 User-defined types and routines. .4 4.3.2 Views and routines ..5 4.3.3 Information schema and definition schema .5 4.4 Implementation of IS0/IEC 13249 .6 4.5 Use of IS0/IEC 13249. .6 4.5.1 Use of user defined types ..6 4.5.2 Use of views 5 Parts of IS0/IEC 13249 ..7 6 Notations and conventions used in other parts .7 6.1 Notation. .7 6.1.1 Notation of user-defined types and routines 6.1.2 Notation for defining a format of a value. .8 6.1.3 Use of syntax elements defined in parts of IS0/IEC 9075 6.2 Conventions 9 6.2.1 Clause structure. ..9 6.2.2 Organization of specifications. ..9 6.2.3 Data type, attribute, SQL-invoked routine, and view identifiers. ..10 6.2.4 Parameter identifiers. ..10 6.2.5 Meta-variables .10 6.2.6 Symbols. .10 6.2.7 Exceptions. .10 6.2.8 Status codes. 7 Implementation requirements ..11 7.1 General .11 7.1.1 Schemas 7.1.2 USAGE privileges on user-defined types .11 7.1.3 UNDER privileges on user-defined types 11 7.1.4 EXECUTE privileges on routines. ..11 7.1.5 SELECT privilege on views ..12 7.1.6 DELETE, INSERT, and UPDATE privilege on viewS. ..12 8 Conformance .12 8.1 Implementations ..12 8.2 Relationship to other International Standards .13 8.3 Claim of conformance. .13 8.4 Extensions and options ..13 Annex A (informative) ISo/IEC JTC1 formal procedures ..14 ii Licensee=ZHEJIANG INST OF STANDARDIZATION C1 5956617 No reproduction or networking permi ted without license from IHS