ANSI INCITS ISO IEC 9075-9 CORR 1-2010 Information technology - Database languages - SQL - Part 9 Management of External Data (SQL MED) Technical Corrigendum 1.pdf

1、 INCITS/ISO/IEC 9075-9:2008/Cor 1: 2010 2012 (ISO/IEC 9075-9:2008/Cor 1:2010, IDT) Information technology Database languages SQL Part 9: Management of External Data (SQL/MED) Technical Corrigendum 1 INCITS/ISO/IEC 9075-9:2008/Cor 1:2010 2012 PDF disclaimer This PDF file may contain embedded typeface

2、s. 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 performing the editing. In downloading this file, parties accept therein the responsibility of not infringin

3、g 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 PDF file can be found in the General Info relative to the file; the PDF-creation parameters were optimize

4、d 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. Adopted by INCITS (InterNational Committee for Information Techn

5、ology Standards) as an American National Standard. Date of ANSI Approval: 8/27/2012 Published by American National Standards Institute, 25 West 43rd Street, New York, New York 10036 Copyright 2012 by Information Technology Industry Council (ITI). All rights reserved. These materials are subject to c

6、opyright claims of International Standardization Organization (ISO), International Electrotechnical Commission (IEC), American National Standards Institute (ANSI), and Information Technology Industry Council (ITI). Not for resale. No part of this publication may be reproduced in any form, including

7、an electronic retrieval system, without the prior written permission of ITI. All requests pertaining to this standard should be submitted to ITI, 1250 Eye Street NW, Washington, DC 20005. Printed in the United States of America ii ITIC 2012 All rights reserved Contents Page11 Schema definition and m

8、anipulation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111.5a . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111.5a . . . . . . . . . . . . . . . . . . . . .

9、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121 SQL/MED common specifications. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221.2 Implicit foreign-data wrapper cursor. . . . . . . . . . . . . .

10、. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2ii ISO/IEC 2010 All rights reservedISO/IEC 9075-9:2008/Cor.1: 2010(E)Information technology Database languages SQL Part 9:Management of External Data (SQL/MED)TECHNICAL CORRIGENDUM 111 Schema definition and manipu

11、lation11.5a 1. Rationale: Supply missing subclause.Insert the following Subclause:11.5a This Subclause 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 Rules

12、No additional Access Rules.General RulesNo additional General Rules.Conformance RulesNo additional Conformance Rules.ISO/IEC 2010 All rights reserved 1ISO/IEC 9075-9:2008/Cor.1: 2010(E)21 SQL/MED common specifications21.2 Implicit foreign-data wrapper cursor1. Rationale: Nullary functions other than

13、 should be sensitive to s.Replace GR 4) a) 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

14、 effectively replaced by the value resulting 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 rights reservedISO/IEC 9075-9:2008/Cor.1: 2010(E)