CAN CSA-ISO IEC 9075-1-2013 Information technology - Database languages - SQL - Part 1 Framework (SQL Framework) (Incorporating Corrigendum No 1 September 2015).pdf

1、Information technology Database languages SQL Part 1: Framework (SQL/Framework)CAN/CSA-ISO/IEC 9075-1:13(ISO/IEC 9075-1:2011, IDT)National Standard of CanadaNOT FOR RESALE. / PUBLICATION NON DESTINE LA REVENTE.Legal Notice for StandardsCanadian Standards Association (operating as “CSA Group”) develo

2、ps standards through a consensus standards development process approved by the Standards Council of Canada. This process brings together volunteers representing varied viewpoints and interests to achieve consensus and develop a standard. Although CSA Group administers the process and establishes rul

3、es to promote fairness in achieving consensus, it does not independently test, evaluate, or verify the content of standards.Disclaimer and exclusion of liabilityThis document is provided without any representations, warranties, or conditions of any kind, express or implied, including, without limita

4、tion, implied warranties or conditions concerning this documents fitness for a particular purpose or use, its merchantability, or its non-infringement of any third partys intellectual property rights. CSA Group does not warrant the accuracy, completeness, or currency of any of the information publis

5、hed in this document. CSA Group makes no representations or warranties regarding this documents compliance with any applicable statute, rule, or regulation. IN NO EVENT SHALL CSA GROUP, ITS VOLUNTEERS, MEMBERS, SUBSIDIARIES, OR AFFILIATED COMPANIES, OR THEIR EMPLOYEES, DIRECTORS, OR OFFICERS, BE LIA

6、BLE FOR ANY DIRECT, INDIRECT, OR INCIDENTAL DAMAGES, INJURY, LOSS, COSTS, OR EXPENSES, HOWSOEVER CAUSED, INCLUDING BUT NOT LIMITED TO SPECIAL OR CONSEQUENTIAL DAMAGES, LOST REVENUE, BUSINESS INTERRUPTION, LOST OR DAMAGED DATA, OR ANY OTHER COMMERCIAL OR ECONOMIC LOSS, WHETHER BASED IN CONTRACT, TORT

7、 (INCLUDING NEGLIGENCE), OR ANY OTHER THEORY OF LIABILITY, ARISING OUT OF OR RESULTING FROM ACCESS TO OR POSSESSION OR USE OF THIS DOCUMENT, EVEN IF CSA GROUP HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES, INJURY, LOSS, COSTS, OR EXPENSES.In publishing and making this document available, CSA G

8、roup is not undertaking to render professional or other services for or on behalf of any person or entity or to perform any duty owed by any person or entity to another person or entity. The information in this document is directed to those who have the appropriate degree of experience to use and ap

9、ply its contents, and CSA Group accepts no responsibility whatsoever arising in any way from any and all use of or reliance on the information contained in this document. CSA Group is a private not-for-profit company that publishes voluntary standards and related documents. CSA Group has no power, n

10、or does it undertake, to enforce compliance with the contents of the standards or other documents it publishes. Intellectual property rights and ownershipAs between CSA Group and the users of this document (whether it be in printed or electronic form), CSA Group is the owner, or the authorized licen

11、see, of all works contained herein that are protected by copyright, all trade-marks (except as otherwise noted to the contrary), and all inventions and trade secrets that may be contained in this document, whether or not such inventions and trade secrets are protected by patents and applications for

12、 patents. Without limitation, the unauthorized use, modification, copying, or disclosure of this document may violate laws that protect CSA Groups and/or others intellectual property and may give rise to a right in CSA Group and/or others to seek legal redress for such use, modification, copying, or

13、 disclosure. To the extent permitted by licence or by law, CSA Group reserves all intellectual property rights in this document.Patent rightsAttention is drawn to the possibility that some of the elements of this standard may be the subject of patent rights. CSA Group shall not be held responsible f

14、or identifying any or all such patent rights. Users of this standard are expressly advised that determination of the validity of any such patent rights is entirely their own responsibility.Authorized use of this documentThis document is being provided by CSA Group for informational and non-commercia

15、l use only. The user of this document is authorized to do only the following:If this document is in electronic form:sLOADTHISDOCUMENTONTOACOMPUTERFORTHESOLEPURPOSEOFREVIEWINGITsSEARCHANDBROWSETHISDOCUMENTANDsPRINTTHISDOCUMENTIFITISIN0$ this remains the continuing responsibility of the SDO. An NSC re

16、flects a consensus of a number of capable individuals whose collective interests provide, to the greatest practicable extent, a balance of representation of general interests, producers, regulators, users (including consumers), and others with relevant interests, as may be appropriate to the subject

17、 in hand. It normally is a standard which is capable of making a significant and timely contribution to the national interest.Those who have a need to apply standards areencouraged to use NSCs. These standards are subjectto periodic review. Users of NSCs are cautionedto obtain the latest edition fro

18、m the SDO which publishes the standard.The responsibility for approving standards as National Standards of Canada rests with theStandards Council of Canada270 Albert Street, Suite 200Ottawa, Ontario, K1P 6N7CanadaCette Norme nationale du Canada est offerte en anglais et en franais.Although the inten

19、ded primary application of this Standard is stated in its Scope, it is importantto note that it remains the responsibility of the users to judge its suitability for their particular purpose.TMA trade-mark of the Canadian Standards Association, operating as “CSA Group”TMA trade-mark of the Canadian S

20、tandards Association, operating as “CSA Group”National Standard of CanadaPublished in January 2013 by CSA GroupA not-for-profit private sector organization5060 Spectrum Way, Suite 100, Mississauga, Ontario, Canada L4W 5N61-800-463-6727 416-747-4044Visit our Online Store at shop.csa.caApproved byStan

21、dards Council of CanadaCAN/CSA-ISO/IEC 9075-1:13Information technology Database languages SQL Part 1: Framework (SQL/Framework)Prepared by InternationalOrganizationforStandardization/ International Electrotechnical CommissionReviewed byCAN/CSA-ISO/IEC 9075-1:13Information technology Database languag

22、es SQL Part 1: Framework (SQL/Framework)CSA/4 2013 CSA Group January 2013CAN/CSA-ISO/IEC 9075-1:13Information technology Database languages SQL Part 1: Framework (SQL/Framework)CSA PrefaceStandards development within the Information Technology sector is harmonized with international standards develo

23、pment. Through the CSA Technical Committee on Information Technology (TCIT), Canadians serve as the Canadian Advisory Committee (CAC) on ISO/IEC Joint Technical Committee 1 on Information Technology (ISO/IEC JTC1) for the Standards Council of Canada (SCC), the ISO member body for Canada and sponsor

24、of the Canadian National Committee of the IEC. Also, as a member of the International Telecommunication Union (ITU), Canada participates in the International Telegraph and Telephone Consultative Committee (ITU-T).This Standard supersedes CAN/CSA-ISO/IEC 9075-1-09 (adoption of ISO/IEC 9075-1:2008).At

25、 the time of publication, ISO/IEC 9075-1:2011 is available from ISO and IEC in English only. CSA Group will publish the French version when it becomes available from ISO and IEC.This International Standard was reviewed by the TCIT under the jurisdiction of the Strategic Steering Committee on Informa

26、tion Technology and deemed acceptable for use in Canada. From time to time, ISO/IEC may publish addenda, corrigenda, etc. The TCIT will review these documents for approval and publication. For a listing, refer to the Current Standards Activities page at standardsactivities.csa.ca. This Standard has

27、been formally approved, without modification, by the Technical Committee and has been approved as a National Standard of Canada by the Standards Council of Canada. 2013 CSA GroupAll rights reserved. No part of this publication may be reproduced in any form whatsoever without the prior permission of

28、thepublisher. ISO/IEC material is reprinted with permission. Where the words “this International Standard” appear in the text, they should be interpreted as “this National Standard of Canada”.Inquiries regarding this National Standard of Canada should be addressed toCSA Group5060 Spectrum Way, Suite

29、 100, Mississauga, Ontario, Canada L4W 5N61-800-463-6727 416-747-4000http:/csa.caTo purchase standards and related publications, visit our Online Store at shop.csa.ca or call toll-free 1-800-463-6727 or 416-747-4044.This Standard is subject to periodic review, and suggestions for its improvement wil

30、l be referred to the appropriate committee. To submit a proposal for change, please send the following information to inquiriescsagroup.org and include “Proposal for change” in the subject line:(a) Standard designation (number);(b) relevant clause, table, and/or figure number;(c) wording of the prop

31、osed change; and(d) rationale for the change.Reference numberISO/IEC 9075(parts 1 to 4, 9 to 11, 13, 14):2011(E)ISO/IEC 2011INTERNATIONAL STANDARD ISO/IEC9075Parts 1, 2, 3, 14Fourth editionPart 4Fifth editionParts 9, 10, 11, 13Third edition2011-12-15Information technology Database languages SQL Tech

32、nologies de linformation Langages de base de donnes SQL Part 1: Framework (SQL/Framework) Partie 1: Charpente (SQL/Framework) Part 2: Foundation (SQL/Foundation) Partie 2: Fondations (SQL/Foundation) Part 3: Call-Level Interface (SQL/CLI) Partie 3: Interface de niveau dappel (SQL/CLI) Part 4: Persis

33、tent Stored Modules (SQL/PSM) Partie 4: Modules stocks persistants (SQL/PSM) Part 9: Management of External Data (SQL/MED) Partie 9: Gestion des donnes externes (SQL/MED) Part 10: Object Language Bindings (SQL/OLB) Partie 10: Liaisons de langage objet (SQL/OLB) Part 11: Information and Definition Sc

34、hemas (SQL/Schemata) Partie 11: Schmas des informations et des dfinitions (SQL/Schemata) Part 13: SQL Routines and Types Using the Java Programming Language (SQL/JRT) Partie 13: Routines et types de SQL utilisant le langage de programmation Java (SQL/JRT) Part 14: XML-Related Specifications (SQL/XML

35、) Partie 14: Spcifications relatives au XML (SQL/XML) ISO/IEC 9075 (parts 1 to 4, 9 to 11, 13, 14):2011(E) COPYRIGHT PROTECTED DOCUMENT ISO/IEC 2011 All rights reserved. Unless required for installation or otherwise specified, no part of this CD-ROM may be reproduced, stored in a retrieval system or

36、 transmitted in any form or by any means without prior permission from ISO. Requests for permission to reproduce this product should be addressed to ISO copyright office Case postale 56 CH-1211 Geneva 20 Switzerland Internet copyrightiso.org Reproduction may be subject to royalty payments or a licen

37、sing agreement. Violators may be prosecuted. ii ISO/IEC 2011 All rights reservedPDF disclaimer PDF files may contain embedded typefaces. In accordance with Adobes licensing policy, such files may be printed or viewed but shall not be edited unless the typefaces which are embedded are licensed to and

38、 installed on the computer performing the editing. In downloading a PDF file, parties accept therein the responsibility of not infringing Adobes licensing policy. The ISO Central Secretariat accepts no liability in this area. Adobe is a trademark of Adobe Systems Incorporated. Details of the softwar

39、e products used to create the PDF file(s) constituting this document can be found in the General Info relative to the file(s); the PDF-creation parameters were optimized for printing. Every care has been taken to ensure that the files are suitable for use by ISO member bodies. In the unlikely event

40、that a problem relating to them is found, please inform the Central Secretariat at the address given below. This CD-ROM contains the publication ISO/IEC 9075 (parts 1 to 4, 9 to 11, 13, 14):2011(E) in portable document format (PDF), which can be viewed using Adobe Acrobat Reader. It is a compilation

41、 containing nine parts of ISO/IEC 9075, Information technology Database languages SQL: Part 1: Framework (SQL/Framework) ISO/IEC 9075-1:2011 Part 2: Foundation (SQL/Foundation) ISO/IEC 9075-2:2011 Part 3: Call-Level Interface (SQL/CLI) ISO/IEC 9075-3:2008 Part 4: Persistent Stored Modules (SQL/PSM)

42、ISO/IEC 9075-4:2011 Part 9: Management of External Data (SQL/MED) ISO/IEC 9075-9:2008 Part 10: Object Language Bindings (SQL/OLB) ISO/IEC 9075-10:2008 Part 11: Information and Definition Schemas (SQL/Schemata) ISO/IEC 9075-11:2011 Part 13: SQL Routines and Types Using the Java Programming Language (

43、SQL/JRT) ISO/IEC 9075-13:2008 Part 14: XML-Related Specifications (SQL/XML) ISO/IEC 9075-14:2011 Each part cancels and replaces the previous edition of that part (including any amendment), of which it constitutes a technical revision. Details are given in the Foreword of each document. Adobe and Acr

44、obat are trademarks of Adobe Systems Incorporated. CAN/CSA-ISO/IEC 9075-1:13ISO/IEC 9075 (parts 1 to 4, 9 to 11, 13, 14):2011(E) ISO/IEC 2011 All rights reserved iiiInstallation If this publication has been packaged as a zipped file, do NOT open the file from the CD-ROM, but copy it to the desired l

45、ocation in your local environment. Once the file has been copied to your local environment, open the file to unzip its contents. For compound documents (e.g. HTML documents comprising several files or folders, documents that have been subdivided owing to the total file size, etc.), in order for the

46、links between documents to function properly, the file and folder names must be maintained and all the files stored in the same folder. Where the zip file contains a Readme file, it is essential to consult this file to understand the way in which the document has been structured. CAN/CSA-ISO/IEC 907

47、5-1:13CSA Technical Committee on Information Technology J. MacFie Microsoft Canada,Ottawa, OntarioChairS. Michell Maurya Software Inc.,Ottawa, OntarioVice-ChairS. Aghigh R. Moroz Ltd.,Markham, OntarioAssociateO. Avellaneda Industry Canada,Ottawa, OntarioAssociateW. Badawy Intelliview Technologies In

48、c.,Calgary, AlbertaAssociateA. Barbir Bank of America,Ottawa, OntarioAssociateL. Bertsch Horizon Technologies Inc.,Victoria, British ColumbiaAssociateJ. Brub IDEgenic Inc.,Gatineau, QubecS. Boeyen Entrust,Ottawa, OntarioAssociateD. Bogachev Ontario Teachers Pension Plan,Toronto, OntarioAssociateT. Bray Vancouver, British Columbia AssociateW.J. Bryans Electro-Federation Canada,Toronto, OntarioAssociateT. Capel Comgate Engineering Limited,Ottawa, OntarioAssociateJ.A. Carter University of Saskatchewan,Saskatoon, SaskatchewanAssociateV. Chiew Calgary, Alberta AssociateF.