CAN CSA-ISO IEC 9075-9-2009 Information technology - Database languages - SQL - Part 9 Management of External Data (SQL MED) (Incorporates Corrigendum 1 March 2012).pdf

1、Information technology Database languages SQL Part 9: Management of External Data (SQL/MED)CAN/CSA-ISO/IEC 9075-9-09National Standard of Canada(ISO/IEC 9075-9:2008, IDT)NOT FOR RESALE.PUBLICATION NON DESTINE LA REVENTE.Legal Notice for StandardsCanadian Standards Association (CSA) standards are deve

2、loped 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 administers the process and establishes rules to promote

3、 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 limitation, implied

4、 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 does not warrant the accuracy, completeness, or currency of any of the information published in this documen

5、t. CSA makes no representations or warranties regarding this documents compliance with any applicable statute, rule, or regulation. IN NO EVENT SHALL CSA, ITS VOLUNTEERS, MEMBERS, SUBSIDIARIES, OR AFFILIATED COMPANIES, OR THEIR EMPLOYEES, DIRECTORS, OR OFFICERS, BE LIABLE FOR ANY DIRECT, INDIRECT, O

6、R 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 (INCLUDING NEGLIGENCE), OR ANY

7、 OTHER THEORY OF LIABILITY, ARISING OUT OF OR RESULTING FROM ACCESS TO OR POSSESSION OR USE OF THIS DOCUMENT, EVEN IF CSA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES, INJURY, LOSS, COSTS, OR EXPENSES.In publishing and making this document available, CSA is not undertaking to render professio

8、nal 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 apply its contents, and CSA accepts no respon

9、sibility whatsoever arising in any way from any and all use of or reliance on the information contained in this document. CSA is a private not-for-profit company that publishes voluntary standards and related documents. CSA has no power, nor does it undertake, to enforce compliance with the contents

10、 of the standards or other documents it publishes. Intellectual property rights and ownershipAs between CSA and the users of this document (whether it be in printed or electronic form), CSA is the owner, or the authorized licensee, of all works contained herein that are protected by copyright, all t

11、rade-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 patents. Without limitation, the unauthorized use, modification, copying

12、, or disclosure of this document may violate laws that protect CSAs and/or others intellectual property and may give rise to a right in CSA and/or others to seek legal redress for such use, modification, copying, or disclosure. To the extent permitted by licence or by law, CSA reserves all intellect

13、ual 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 shall not be held responsible for identifying any or all such patent rights. Users of this standard are expressly advised that d

14、etermination of the validity of any such patent rights is entirely their own responsibility.Authorized use of this documentThis document is being provided by CSA for informational and non-commercial use only. The user of this document is authorized to do only the following:If this document is in ele

15、ctronic form:.load this document onto a computer for the sole purpose of reviewing it;.search and browse this document; and.print this document if it is in PDF format. Limited copies of this document in print or paper form may be distributed only to persons who are authorized by CSA to have such cop

16、ies, and only if this Legal Notice appears on each such copy.In addition, users may not and may not permit others to.alter this document in any way or remove this Legal Notice from the attached standard;.sell this document without authorization from CSA; or.make an electronic copy of this document.I

17、f you do not agree with any of the terms and conditions contained in this Legal Notice, you may not load or use this document or make any copies of the contents hereof, and if you do make such copies, you are required to destroy them immediately. Use of this document constitutes your acceptance of t

18、he terms and conditions of this Legal Notice.Information technology Database languages SQL Part 9: Management of External Data (SQL/MED)TECHNICAL CORRIGENDUM 1Technical Corrigendum 1:2012 (IDT) toNational Standard of CanadaCAN/CSA-ISO/IEC 9075-9:09(ISO/IEC 9075-9:2008, IDT)NOT FOR RESALE.PUBLICATION

19、 NON DESTINE LA REVENTE.CSA Standards Update ServiceTechnical Corrigendum 1:2012 toCAN/CSA-ISO/IEC 9075-9:09March 2012Title:Information technology Da tabase languages SQL Part 9: Management of External Data (SQL/MED)Pagination: 4 pagesTo register for e-mail notification about any updates to this pub

20、lication go on-line to shop.csa.caclick on E-mail Services under MY ACCOUNTclick on CSA Standards Update ServiceThe List ID that you will need to register for updates to this publication is 2419901.If you require assistance, please e-mail techsupportcsa.ca or call 416-747-2233.Visit CSAs policy on p

21、rivacy at csagroup.org/legal to find out how we protect your personal information.ICS 35.060 Ref. No. ISO/IEC 9075-9:2008/Cor.1:2010(E) ISO/IEC 2010 All rights reserved INTERNATIONAL STANDARD ISO/IEC 9075-9:2008 TECHNICAL CORRIGENDUM 1 Published 2010-06-01 INTERNATIONAL ORGANIZATION FOR STANDARDIZAT

22、ION ORGANISATION INTERNATIONALE DE NORMALISATIONINTERNATIONAL ELECTROTECHNICAL COMMISSION COMMISSION LECTROTECHNIQUE INTERNATIONALEInformation technology Database languages SQL Part 9: Management of External Data (SQL/MED) TECHNICAL CORRIGENDUM 1 Technologies de linformation Langages de base de donn

23、es SQL Partie 9: Gestion des donnes externes (SQL/MED) RECTIFICATIF TECHNIQUE 1 Technical Corrigendum 1 to ISO/IEC 9075-9:2008 was prepared by Joint Technical Committee ISO/IEC JTC 1, Information technology, Subcommittee SC 32, Data management and interchange. Statement of purpose for rationale A st

24、atement indicating the rationale for each change to ISO/IEC 9075-9:2008 is included. This is to inform the users of ISO/IEC 9075-9:2008 why it was judged necessary to change the original wording. In many cases, the reason is editorial or to clarify the wording; in some cases, it is to correct an err

25、or or an omission in the original wording. Notes on numbering Where this Technical Corrigendum introduces new Syntax, Access, General, and Conformance Rules, the new rules have been numbered as follows: Rules inserted between, for example, Rules 7) and 8) are numbered 7.1), 7.2), etc. or 7)a.1), 7)a

26、.2), etc. Those inserted before Rule 1) are numbered 0.1), 0.2), etc. Where this Technical Corrigendum introduces new subclauses, the new subclauses have been numbered as follows: Subclauses inserted between, for example, 4.3.2 and 4.3.3 are numbered 4.3.2a, 4.3.2b, etc. Those inserted before, for e

27、xample, 4.3.1 are numbered 4.3.0, 4.3.0a, etc. Technical Corrigendum 1:2012 to CAN/CSA-ISO/IEC 9075-9:09Contents Page11 Schema definition and manipulation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111.5a . . . . . . . . . . . . . .

28、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111.5a . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121 SQL/MED common specifications. . . . . . . . . . . . . . . . . . . . . .

29、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221.2 Implicit foreign-data wrapper cursor. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2ii ISO/IEC 2010 All rights reservedISO/IEC 9075-9:2008/Cor.1: 2010(E)T

30、echnical Corrigendum 1:2012 to CAN/CSA-ISO/IEC 9075-9:09Information technology Database languages SQL Part 9:Management of External Data (SQL/MED)TECHNICAL CORRIGENDUM 111 Schema definition and manipulation11.5a 1. Rationale: Supply missing subclause.Insert the following Subclause:11.5a This Subclau

31、se modifies Subclause 11.17, “”, in ISO/IEC 9075-2.FunctionChange the declared type of a column.FormatNo additional Format items.Syntax Rules1) Insert this SR D shall not specify DATALINK.Access RulesNo additional Access Rules.General RulesNo additional General Rules.Conformance RulesNo additional C

32、onformance Rules.ISO/IEC 2010 All rights reserved 1ISO/IEC 9075-9:2008/Cor.1: 2010(E)Technical Corrigendum 1:2012 to CAN/CSA-ISO/IEC 9075-9:0921 SQL/MED common specifications21.2 Implicit foreign-data wrapper cursor1. Rationale: Nullary functions other than should be sensitive to s.Replace GR 4) a)

33、ii) with:4) .a) .ii) Each generally contained in SS without an intervening that is CURRENT_USER, CURRENT_ROLE, SESSION_USER,SYSTEM_USER, CURRENT_CATALOG, CURRENT_SCHEMA, CUR-RENT_PATH, CURRENT_DEFAULT_TRANSFORM_GROUP, or CUR-RENT_TRANSFORM_GROUP_FOR_TYPE is effectively replaced by the value resultin

34、g from evaluation of CUR-RENT_USER, CURRENT_ROLE, SESSION_USER, SYSTEM_USER, CUR-RENT_CATALOG, CURRENT_SCHEMA, CURRENT_PATH, CUR-RENT_DEFAULT_TRANSFORM_GROUP, or CURRENT_TRANS-FORM_GROUP_FOR_TYPE , respectively,with all such evaluations effectively done at the same instant in time.2 ISO/IEC 2010 All

35、 rights reservedISO/IEC 9075-9:2008/Cor.1: 2010(E)Technical Corrigendum 1:2012 to CAN/CSA-ISO/IEC 9075-9:09ICS 35.060 ISO/IEC 2010 All rights reserved Copyright NoticeThis Amendment to the International Standard contains information copyright protected by the International Organization for Standardi

36、zation (ISO) and the International Electrotechnical Commission (IEC). Except as permitted under the laws of Canada, no extract of this Amendment to the International Standard may be reproduced, stored in any retrieval system, or transmitted in any form or by any means, electronic, photocopying, reco

37、rding, or otherwise, without prior permission from the Standards Council of Canada (SCC). Requests for permission to reproduce this Amendment to the International Standard or parts thereof should be addressed to Manager, Technical Document Centre Standards Council of Canada 270 Albert Street, Suite

38、200 Ottawa, Ontario K1P 6N7 The Canadian adoption of this Amendment to the International Standard contains information copyright protected by the Canadian Standards Association. All rights reserved. No part of this adopted Amendment may be reproduced in any form whatsoever without the prior permissi

39、on of the publisher. ISO/IEC material is reprinted with permission. Requests for permission to reproduce this adopted Amendment or parts thereof should be addressed to Manager, Sales Canadian Standards Association 5060 Spectrum Way, Suite 100 Mississauga, Ontario L4W 5N6Copyright violators will be p

40、rosecuted to the full extent of the law.PRINTED IN CANADAIMPRIMEAU CANADA100%The Canadian Standards Association (CSA) prints its publications on Rolland Enviro100, which contains 100%recycled post-consumer fibre, is EcoLogo and Processed Chlorine Free certified, and was manufactured using biogas ene

41、rgy.CSA Standards Update ServiceCAN/CSA-ISO/IEC 9075-9-09October 2009Title: Information technology Database languages SQL Part 9: Management of External Data (SQL/MED)Pagination: 489 pages (CSA/1CSA/5, ixv, and 469 text)To register for e-mail notification about any updates to this publicationgo to w

42、ww.ShopCSA.caclick on E-mail Services under MY ACCOUNTclick on CSA Standards Update ServiceThe List ID that you will need to register for updates to this publication is 2419901.If you require assistance, please e-mail techsupportcsa.ca or call 416-747-2233.Visit CSAs policy on privacy at www.csagrou

43、p.org/legal to find out how we protect your personal information.The Canadian Standards Association (CSA),under whose auspices this National Standard hasbeen produced, was chartered in 1919 andaccredited by the Standards Council of Canadato the National Standards system in 1973. It is anot-for-profi

44、t, nonstatutory, voluntary membershipassociation engaged in standards development andcertification activities.CSA standards reflect a national consensus ofproducers and users including manufacturers,consumers, retailers, unions and professionalorganizations, and governmental agencies. Thestandards a

45、re used widely by industry and commerceand often adopted by municipal, provincial, andfederal governments in their regulations, particularlyin the fields of health, safety, building andconstruction, and the environment.Individuals, companies, and associations acrossCanada indicate their support for

46、CSAs standardsdevelopment by volunteering their time and skillsto CSA Committee work and supporting theAssociations objectives through sustainingmemberships. The more than 7000 committeevolunteers and the 2000 sustaining membershipstogether form CSAs total membership from whichits Directors are chos

47、en. Sustaining membershipsrepresent a major source of income for CSAsstandards development activities.The Association offers certification and testingservices in support of and as an extension to itsstandards development activities. To ensure theintegrity of its certification process, the Associatio

48、nregularly and continually audits and inspects productsthat bear the CSA Mark.In addition to its head office and laboratorycomplex in Toronto, CSA has regional branch officesin major centres across Canada and inspection andtesting agencies in eight countries. Since 1919, theAssociation has developed

49、 the necessary expertise tomeet its corporate mission: CSA is an independentservice organization whose mission is to provide anopen and effective forum for activities facilitating theexchange of goods and services through the use ofstandards, certification and related services to meetnational and international needs.For further information on CSA services, write toCanadian Standards Association5060 Spectrum Way,