1、Information technology Database languages SQL Part 10: Object Language Bindings (SQL/OLB)CAN/CSA-ISO/IEC 9075-10-09National Standard of Canada(ISO/IEC 9075-10: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 10: Object Lanuage Bindings (SQL/OLB)TECHNICAL CORRIGENDUM 1Technical Corrigendum 1:2012 (IDT) toNational Standard of CanadaCAN/CSA-ISO/IEC 9075-10:09(ISO/IEC 9075-10:2008, IDT)NOT FOR RESALE.PUBLICATION
19、NON DESTINE LA REVENTE.CSA Standards Update ServiceTechnical Corrigendum 1:2012 toCAN/CSA-ISO/IEC 9075-10:09March 2012Title:Information technology Da tabase languages SQL Part 10: Object Lanuage Bindings (SQL/OLB)Pagination: 3 pagesTo register for e-mail notification about any updates to this public
20、ation 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 2419902.If you require assistance, please e-mail techsupportcsa.ca or call 416-747-2233.Visit CSAs policy on priv
21、acy at csagroup.org/legal to find out how we protect your personal information.ICS 35.060 Ref. No. ISO/IEC 9075-10:2008/Cor.1:2010(E) ISO/IEC 2010 All rights reserved INTERNATIONAL STANDARD ISO/IEC 9075-10:2008 TECHNICAL CORRIGENDUM 1 Published 2010-06-01 INTERNATIONAL ORGANIZATION FOR STANDARDIZATI
22、ON ORGANISATION INTERNATIONALE DE NORMALISATIONINTERNATIONAL ELECTROTECHNICAL COMMISSION COMMISSION LECTROTECHNIQUE INTERNATIONALEInformation technology Database languages SQL Part 10: Object Language Bindings (SQL/OLB) TECHNICAL CORRIGENDUM 1 Technologies de linformation Langages de base de donnes
23、SQL Partie 10: Liaisons de langage objet (SQL/OLB) RECTIFICATIF TECHNIQUE 1 Technical Corrigendum 1 to ISO/IEC 9075-10: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 state
24、ment indicating the rationale for each change to ISO/IEC 9075-10:2008 is included. This is to inform the users of ISO/IEC 9075-10: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 erro
25、r 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 ex
27、ample, 4.3.1 are numbered 4.3.0, 4.3.0a, etc. Technical Corrigendum 1:2012 to CAN/CSA-ISO/IEC 9075-10:09Contents Page11 and contents. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111.15 . . . . . . . . . . . . . . . . . . . . . . . . .
28、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1ii ISO/IEC 2010 All rights reservedISO/IEC 9075-10:2008/Cor.1:2010(E) Technical Corrigendum 1:2012 to CAN/CSA-ISO/IEC 9075-10:09Information technology Database languages SQL Part 10:Object Language Bindin
29、gs (SQL/OLB)TECHNICAL CORRIGENDUM 111 and contents11.15 1. Rationale: Correct the invocation of Subclause 9.2, “Store assignment”.Replace Syntax Rule 3) with:3) Insert after SR 9)b)iii) For each TS3i, 1 (one) 7 i, 7 NTS, that is an ,Case:a) If is contained in an , then CSi shall beSQLJ output assign
30、able to TS3i.b) Otherwise, the Syntax Rules of Subclause 9.2, “Store assignment”, in ISO9075-2 apply toTS3i as TARGET and CSi as VALUE.ISO/IEC 2010 All rights reserved 1ISO/IEC 9075-10:2008/Cor.1:2010(E) Technical Corrigendum 1:2012 to CAN/CSA-ISO/IEC 9075-10:09ICS 35.060 ISO/IEC 2010 All rights res
31、erved Copyright NoticeThis Amendment to the International Standard contains information copyright protected by the International Organization for Standardization (ISO) and the International Electrotechnical Commission (IEC). Except as permitted under the laws of Canada, no extract of this Amendment
32、to the International Standard may be reproduced, stored in any retrieval system, or transmitted in any form or by any means, electronic, photocopying, recording, or otherwise, without prior permission from the Standards Council of Canada (SCC). Requests for permission to reproduce this Amendment to
33、the International Standard or parts thereof should be addressed to Manager, Technical Document Centre Standards Council of Canada 270 Albert Street, Suite 200 Ottawa, Ontario K1P 6N7 The Canadian adoption of this Amendment to the International Standard contains information copyright protected by the
34、 Canadian Standards Association. All rights reserved. No part of this adopted Amendment may be reproduced in any form whatsoever without the prior permission of the publisher. ISO/IEC material is reprinted with permission. Requests for permission to reproduce this adopted Amendment or parts thereof
35、should be addressed to Manager, Sales Canadian Standards Association 5060 Spectrum Way, Suite 100 Mississauga, Ontario L4W 5N6Copyright violators will be prosecuted to the full extent of the law.PRINTED IN CANADAIMPRIMEAU CANADA100%The Canadian Standards Association (CSA) prints its publications on
36、Rolland Enviro100, which contains 100%recycled post-consumer fibre, is EcoLogo and Processed Chlorine Free certified, and was manufactured using biogas energy.CSA Standards Update ServiceCAN/CSA-ISO/IEC 9075-10-09October 2009Title: Information technology Database languages SQL Part 10: Object Langua
37、ge Bindings (SQL/OLB)Pagination: 417 pages (CSA/1CSA/4, ixxi, and 392 text)To register for e-mail notification about any updates to this publicationgo to www.ShopCSA.caclick on E-mail Services under MY ACCOUNTclick on CSA Standards Update ServiceThe List ID that you will need to register for updates
38、 to this publication is 2419902.If you require assistance, please e-mail techsupportcsa.ca or call 416-747-2233.Visit CSAs policy on privacy at www.csagroup.org/legal to find out how we protect your personal information.The Canadian Standards Association (CSA),under whose auspices this National Stan
39、dard hasbeen produced, was chartered in 1919 andaccredited by the Standards Council of Canadato the National Standards system in 1973. It is anot-for-profit, nonstatutory, voluntary membershipassociation engaged in standards development andcertification activities.CSA standards reflect a national co
40、nsensus ofproducers and users including manufacturers,consumers, retailers, unions and professionalorganizations, and governmental agencies. Thestandards are used widely by industry and commerceand often adopted by municipal, provincial, andfederal governments in their regulations, particularlyin th
41、e fields of health, safety, building andconstruction, and the environment.Individuals, companies, and associations acrossCanada indicate their support for CSAs standardsdevelopment by volunteering their time and skillsto CSA Committee work and supporting theAssociations objectives through sustaining
42、memberships. The more than 7000 committeevolunteers and the 2000 sustaining membershipstogether form CSAs total membership from whichits Directors are chosen. Sustaining membershipsrepresent a major source of income for CSAsstandards development activities.The Association offers certification and te
43、stingservices in support of and as an extension to itsstandards development activities. To ensure theintegrity of its certification process, the Associationregularly and continually audits and inspects productsthat bear the CSA Mark.In addition to its head office and laboratorycomplex in Toronto, CS
44、A has regional branch officesin major centres across Canada and inspection andtesting agencies in eight countries. Since 1919, theAssociation has developed the necessary expertise tomeet its corporate mission: CSA is an independentservice organization whose mission is to provide anopen and effective
45、 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, Suite 100Mississauga, Ontario
46、, L4W 5N6CanadaThe Standards Council of Canada (SCC) is thecoordinating body of the National StandardsSystem, a coalition of independent, autonomousorganizations working towards the furtherdevelopment and improvement of voluntarystandardization in the national interest.The principal objects of the S
47、CC are to fosterand promote voluntary standardization as a meansof advancing the national economy, benefiting thehealth, safety, and welfare of the public, assistingand protecting the consumer, facilitating domesticand international trade, and furthering internationalcooperation in the field of stan
48、dards.A National Standard of Canada (NSC) is a standardprepared or reviewed by an accredited StandardsDevelopment Organization (SDO) and approvedby the SCC according to the requirements of CAN-P-2.Approval does not refer to the technical content of thestandard; this remains the continuing responsibi
49、lity ofthe SDO. An NSC reflects a consensus of a number ofcapable individuals whose collective interests provide,to the greatest practicable extent, a balance ofrepresentation of general interests, producers,regulators, users (including consumers), and otherswith relevant interests, as may be appropriate to thesubject in hand. It normally is a standard which iscapable of making a significant and timely contribut
