ImageVerifierCode 换一换
格式:PDF , 页数:506 ,大小:2.56MB ,
资源ID:591051      下载积分:10000 积分
快捷下载
登录下载
邮箱/手机:
温馨提示:
如需开发票,请勿充值!快捷下载时,用户名和密码都是您填写的邮箱或者手机号,方便查询和重复下载(系统自动生成)。
如填写123,账号就是123,密码也是123。
特别说明:
请自助下载,系统不会自动发送文件的哦; 如果您已付费,想二次下载,请登录后访问:我的下载记录
支付方式: 支付宝扫码支付 微信扫码支付   
注意:如需开发票,请勿充值!
验证码:   换一换

加入VIP,免费下载
 

温馨提示:由于个人手机设置不同,如果发现不能下载,请复制以下地址【http://www.mydoc123.com/d-591051.html】到电脑端继续下载(重复下载不扣费)。

已注册用户请登录:
账号:
密码:
验证码:   换一换
  忘记密码?
三方登录: 微信登录  

下载须知

1: 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。
2: 试题试卷类文档,如果标题没有明确说明有答案则都视为没有答案,请知晓。
3: 文件的所有权益归上传用户所有。
4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
5. 本站仅提供交流平台,并不能对任何下载内容负责。
6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

版权提示 | 免责声明

本文(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)为本站会员(arrownail386)主动上传,麦多课文库仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对上载内容本身不做任何修改或编辑。 若此文所含内容侵犯了您的版权或隐私,请立即通知麦多课文库(发送邮件至master@mydoc123.com或直接QQ联系客服),我们立即给予删除!

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,

copyright@ 2008-2019 麦多课文库(www.mydoc123.com)网站版权所有
备案/许可证编号:苏ICP备17064731号-1