CAN CSA-ISO IEC 9075-3-2009 Information technology - Database languages - SQL - Part 3 Call-Level Interface (SQL CLI).pdf

1、Information technology Database languages SQL Part 3: Call-Level Interface (SQL/CLI)CAN/CSA-ISO/IEC 9075-3-09National Standard of Canada(ISO/IEC 9075-3:2008, IDT)Legal Notice for StandardsCanadian Standards Association (CSA) standards are developed through a consensus standards development process a

2、pproved 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 fairness in achieving consensus, it does not independent

3、ly 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 warranties or conditions concerning this documents fitne

4、ss 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 document. CSA makes no representations or warranties regarding t

5、his 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, OR INCIDENTAL DAMAGES, INJURY, LOSS, COSTS, OR EXPENSES, H

6、OWSOEVER 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 OTHER THEORY OF LIABILITY, ARISING OUT OF OR RESULTING F

7、ROM 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 professional or other services for or on behalf of any person or e

8、ntity 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 responsibility whatsoever arising in any way from any and all u

9、se 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 of the standards or other documents it publishes. Intell

10、ectual 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 trade-marks (except as otherwise noted to the contrary), a

11、nd 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, or disclosure of this document may violate laws that pr

12、otect 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 intellectual property rights in this document.Patent rightsAttenti

13、on 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 determination of the validity of any such patent rights is

14、 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 electronic form:.load this document onto a computer for the

15、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 copies, and only if this Legal Notice appears on each such c

16、opy.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.If you do not agree with any of the terms and conditions c

17、ontained 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 the terms and conditions of this Legal Notice.CSA Standard

18、s Update ServiceCAN/CSA-ISO/IEC 9075-3-09October 2009Title: Information technology Database languages SQL Part 3: Call-Level Interface (SQL/CLI)Pagination: 406 pages (CSA/1CSA/4, ixi, and 391 text)To register for e-mail notification about any updates to this publicationgo to www.ShopCSA.caclick on E

19、-mail Services under MY ACCOUNTclick on CSA Standards Update ServiceThe List ID that you will need to register for updates to this publication is 2419899.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

20、 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-profit, nonstatutory, volunt

21、ary 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 are used widely by indus

22、try 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 CSAs standardsdevelopme

23、nt 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 chosen. Sustaining membersh

24、ipsrepresent 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 Associationregularly and continua

25、lly 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 the necessary expertis

26、e 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 f

27、urther information on CSA services, write toCanadian Standards Association5060 Spectrum Way, Suite 100Mississauga, Ontario, L4W 5N6CanadaThe Standards Council of Canada (SCC) is thecoordinating body of the National StandardsSystem, a coalition of independent, autonomousorganizations working towards

28、the furtherdevelopment and improvement of voluntarystandardization in the national interest.The principal objects of the SCC are to fosterand promote voluntary standardization as a meansof advancing the national economy, benefiting thehealth, safety, and welfare of the public, assistingand protectin

29、g the consumer, facilitating domesticand international trade, and furthering internationalcooperation in the field of standards.A National Standard of Canada (NSC) is a standardprepared or reviewed by an accredited StandardsDevelopment Organization (SDO) and approvedby the SCC according to the requi

30、rements of CAN-P-2.Approval does not refer to the technical content of thestandard; this remains the continuing responsibility 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

31、 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 contributionto the national interest.Those who have a need to apply stan

32、dards areencouraged to use NSCs. These standards are subjectto periodic review. Users of NSCs are cautionedto obtain the latest edition from the SDO whichpublishes the standard.The responsibility for approving standards asNational Standards of Canada rests with theStandards Council of Canada270 Albe

33、rt Street, Suite 200Ottawa, Ontario, K1P 6N7CanadaAlthough the intended 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.Registered trade-mark of Canadian Standard

34、s AssociationCette norme est offerte en anglais seulement pour le moment. La CSA publiera la version enfranais ds quelle sera produite par lorganisme rdacteur.Reviewed byNational Standard of CanadaPublished in October 2009 by Canadian Standards AssociationA not-for-profit private sector organization

35、5060 Spectrum Way, Suite 100, Mississauga, Ontario, Canada L4W 5N61-800-463-6727 416-747-4044Visit our Online Store at www.ShopCSA.caApproved byStandards Council of CanadaCAN/CSA-ISO/IEC 9075-3-09Information technology Database languages SQL Part 3: Call-Level Interface (SQL/CLI)Prepared by Internat

36、ional Organization for Standardization/ International Electrotechnical CommissionCAN/CSA-ISO/IEC 9075-3-09Information technology Database languages SQL Part 3: Call-Level Interface (SQL/CLI)CSA/4 Canadian Standards Association October 2009CAN/CSA-ISO/IEC 9075-3-09Information technology Database lang

37、uages SQL Part 3: Call-Level Interface (SQL/CLI)CSA PrefaceStandards development within the Information Technology sector is harmonized with international standards development. Through the CSA Technical Committee on Information Technology (TCIT), Canadians serve as the Canadian Advisory Committee (

38、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 of the Canadian National Committee of the IEC. Also, as a member of the International Telecommunication Union (ITU), Canada parti

39、cipates in the International Telegraph and Telephone Consultative Committee (ITU-T).This Standard supersedes CAN/CSA-ISO/IEC 9075-3-04 (adoption of ISO/IEC 9075-3:2003). At the time of publication, ISO/IEC 9075-3:2008 is available from ISO and IEC in English only. CSA will publish the French version

40、 when it becomes available from ISO and IEC.This International Standard was reviewed by the CSA TCIT under the jurisdiction of the Strategic Steering Committee on Information Technology and deemed acceptable for use in Canada. From time to time, ISO/IEC may publish addenda, corrigenda, etc. The CSA

41、TCIT will review these documents for approval and publication. For a listing, refer to the CSA Information Products catalogue or CSA Info Update or contact a CSA Sales representative. This Standard has been formally approved, without modification, by the Technical Committee and has been approved as

42、a National Standard of Canada by the Standards Council of Canada.October 2009 Canadian Standards Association 2009All rights reserved. No part of this publication may be reproduced in any form whatsoever without the prior permission of the publisher. ISO/IEC material is reprinted with permission. Whe

43、re 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 toCanadian Standards Association5060 Spectrum Way, Suite 100, Mississauga, Ontario, Canada L4W 5N61

44、-800-463-6727 416-747-4000www.csa.caTo purchase CSA Standards and related publications, visit CSAs Online Store at www.ShopCSA.ca or call toll-free 1-800-463-6727 or 416-747-4044.CSA Standards are subject to periodic review, and suggestions for their improvement will be referred to the appropriate c

45、ommittee. To submit a proposal for change to CSA Standards, please send the following information to inquiriescsa.ca 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 proposed change; and(d) rat

46、ionale for the change.Reference numberISO/IEC 9075-3:2008(E)ISO/IEC 2008INTERNATIONAL STANDARD ISO/IEC9075-3Fourth edition2008-07-15Information technology Database languages SQL Part 3: Call-Level Interface (SQL/CLI) Technologies de linformation Langages de base de donnes SQL Partie 3: Interface de

47、niveau dappel (SQL/CLI) ISO/IEC 9075-3:2008(E) PDF disclaimer This PDF file may contain embedded typefaces. In accordance with Adobes licensing policy, this file may be printed or viewed but shall not be edited unless the typefaces which are embedded are licensed to and installed on the computer per

48、forming the editing. In downloading this 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 software products used to create this

49、PDF file can be found in the General Info relative to the file; the PDF-creation parameters were optimized for printing. Every care has been taken to ensure that the file is suitable for use by ISO member bodies. In the unlikely event that a problem relating to it is found, please inform the Central Secretariat at the address given below. COPYRIGHT PROTECTED DOCUMENT ISO/IEC 2008 All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized in any form or by any means, e