《ISO-9075-4-CORR-1-2005.pdf》由会员分享，可在线阅读，更多相关《ISO-9075-4-CORR-1-2005.pdf（20页珍藏版）》请在三一文库上搜索。
1、 ICS 35.060 Ref. No. ISO/IEC 9075-4:2003/Cor.1:2005(E) ISO/IEC 2005 All rights reserved Published in Switzerland INTERNATIONAL STANDARD ISO/IEC 9075-4:2003 TECHNICAL CORRIGENDUM 1 Published 2005-11-15 INTERNATIONAL ORGANIZATION FOR STANDARDIZATION ORGANISATION INTERNATIONALE DE NORMALISATION INTERNA
2、TIONAL ELECTROTECHNICAL COMMISSION COMMISSION LECTROTECHNIQUE INTERNATIONALE Information technology Database languages SQL Part 4: Persistent Stored Modules (SQL/PSM) TECHNICAL CORRIGENDUM 1 Technologies de linformation Langages de base de donnes SQL Partie 4: Modules stocks persistants (SQL/PSM) RE
3、CTIFICATIF TECHNIQUE 1 Technical Corrigendum 1 to ISO/IEC 9075-4:2003 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 statement indicating the rationale for each change to ISO/I
4、EC 9075-4:2003 is included. This is to inform the users of ISO/IEC 9075-4:2003 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 error or an omission in the original wording. Notes on numbe
5、ring 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.2), etc. Those inserted before Rule 1) are numbered 0.1)
6、, 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 example, 4.3.1 are numbered 4.3.0, 4.3.0a, etc. Copyright I
7、nternational Organization for Standardization Provided by IHS under license with ISO Licensee=HP Monitoring/1111111164 Not for Resale, 12/04/2007 20:50:21 MSTNo reproduction or networking permitted without license from IHS -,-,- ISO/IEC 9075-4:2003/Cor.1:2005(E) ii ISO/IEC 2005 All rights reserved C
8、opyright International Organization for Standardization Provided by IHS under license with ISO Licensee=HP Monitoring/1111111164 Not for Resale, 12/04/2007 20:50:21 MSTNo reproduction or networking permitted without license from IHS -,-,- ISO/IEC 9075-4:2003/Cor.1:2005(E) ISO/IEC 2005 All rights res
9、erved iii ContentsPage Foreword. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 4Concepts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
10、. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 4.8Cursors. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 4.8.1General description of cursors. . . . . . . .
11、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 4.13Dynamic SQL concepts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 4.13.1Dynamic SQL statements
12、and descriptor areas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 5Lexical elements. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 5.2Names and i
13、dentifiers. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 6Scalar expressions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
14、 . . . . . . . 2 6.1 and . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 9Schema definition and manipulation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 9.2a. . . . . . . . . . . . .
15、. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 9.2b. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 9.3. . . . . . . . . . . . . . . .
16、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 9.24. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 9.25. . . . . . . . . . . . . . . . . . . . . . . .
17、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 10Access control. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 10.3. . . . . . . . . . . . . .
18、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 11SQL-client modules. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 11.2 . . . . . . .
19、. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 12Data manipulation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 12.3. . . . . . . . .
20、. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 13Control statements. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 13.1. .
21、. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 13.2. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 13.4. . . . . . . . . .
22、. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 13.5. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 13.9. . . . . . . . . . . . . . . . . . . . . . . .
23、. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 13.13. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 Copyright International Organization for Standard
24、ization Provided by IHS under license with ISO Licensee=HP Monitoring/1111111164 Not for Resale, 12/04/2007 20:50:21 MSTNo reproduction or networking permitted without license from IHS -,-,- ISO/IEC 9075-4:2003/Cor.1:2005(E) iv ISO/IEC 2005 All rights reserved 17Information Schema. . . . . . . . . .
25、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 17.2MODULE_PRIVILEGES view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 17.5PARAMETERS view. . . . .
26、. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 18Definition Schema. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 18.4M
27、ODULES base table. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 Annex DIncompatibilities with ISO/IEC 9075:1999. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 Copyright In
28、ternational Organization for Standardization Provided by IHS under license with ISO Licensee=HP Monitoring/1111111164 Not for Resale, 12/04/2007 20:50:21 MSTNo reproduction or networking permitted without license from IHS -,-,- ISO/IEC 9075-4:2003/Cor.1:2005(E) ISO/IEC 2005 All rights reserved 1 Inf
29、ormation technology Database languages SQL Part 4: TECHNICAL CORRIGENDUM 1 Foreword 1.Rationale:Remove incorrect reference to obsolete part. In the 7th paragraph, delete the 5th bullet. 4Concepts 4.8Cursors 4.8.1General description of cursors 1.Rationale:Clarify the specifications concerning dynamic
30、 result sets. Replace the 1st paragraph with: Insert this paragraph For every in a , a cursor is effectively created each time the is executed and destroyed when that execution completes. NOTE 0.1 Destroying an open with-result cursor does not simultaneously destroy that cursors result set. 4.13Dyna
31、mic SQL concepts 1.Rationale:Clarification of the method of identification of dynamic objects. Insert the following new Subclause: 4.13Dynamic SQL concepts This Subclause modifies Subclause 4.24, “Dynamic SQL concepts”, in ISO/IEC 9075-2. Persistent Stored Modules (SQL/PSM) Copyright International O
32、rganization for Standardization Provided by IHS under license with ISO Licensee=HP Monitoring/1111111164 Not for Resale, 12/04/2007 20:50:21 MSTNo reproduction or networking permitted without license from IHS -,-,- ISO/IEC 9075-4:2003/Cor.1:2005(E) 2 ISO/IEC 2005 All rights reserved 4.13.1Dynamic SQ
33、L statements and descriptor areas Replace the 8th paragraph A cursor declared by either a or a has a . A is immediately contained in a . A is immediately contained either in the of an or the of a . The scope of a is the innermost or that contains it. 5Lexical elements 5.2Names and identifiers 1.Rati
34、onale:Provide replacement Syntax Rule for in Part 2. Insert the following Syntax Rule: 6)Replace Syntax Rule 7) Let CN be a . At least one of the following shall be true: a)CN is contained, without an intervening in an whose contain a or whose is CN. b)CN is contained, without an intervening , in a
35、whose contains a whose is CN. 6Scalar expressions 6.1 and 1.Rationale:Add SQL variable to what a and can specify. Insert the following General Rules: 1)Replace GR 3) A specifies a target that is a host parameter, an output SQL parameter, a column of a new transition variable, an element of a target
36、whose declared type is an array type, a parameter used in a dynamically prepared statement, a host variable, or an SQL variable, according to whether the is a , an , a , a , a , an , or an , respectively. Copyright International Organization for Standardization Provided by IHS under license with ISO
37、 Licensee=HP Monitoring/1111111164 Not for Resale, 12/04/2007 20:50:21 MSTNo reproduction or networking permitted without license from IHS -,-,- ISO/IEC 9075-4:2003/Cor.1:2005(E) ISO/IEC 2005 All rights reserved 3 2)Replace GR 13) A specifies a target that is a host parameter, an output SQL paramete
38、r, a column of a new transition variable, a host variable, or an SQL variable, according to whether the is a , an , a , an , or an , respectively. NOTE 2.1 A can never be assigned the null value. 9Schema definition and manipulation 9.2a 1.Rationale:Prohibit s in DDL. Insert the following new Subclau
39、se: 9.2a This Subclause modifies Subclause 11.3, “”, in ISO/IEC 9075-2. Function Define a persistent base table, a created local temporary table, or a global temporary table. Format No additional Format items. Syntax Rules 1)Replace SR 0.1) The shall not contain a , an , a , an , or an . Access Rule
40、s No additional Access Rules. General Rules No additional General Rules. Copyright International Organization for Standardization Provided by IHS under license with ISO Licensee=HP Monitoring/1111111164 Not for Resale, 12/04/2007 20:50:21 MSTNo reproduction or networking permitted without license fr
41、om IHS -,-,- ISO/IEC 9075-4:2003/Cor.1:2005(E) 4 ISO/IEC 2005 All rights reserved Conformance Rules No additional Conformance Rules. 9.2b 1.Rationale:Prohibit s in DDL. Insert the following new Subclause: 9.2b This Subclause modifies Subclause 11.4, “”, in ISO/IEC 9075-2. Function Define a column of
42、 a base table. Format No additional Format items. Syntax Rules 1)Replace SR 0.1) The shall not contain a , an , a , an , or an . Access Rules No additional Access Rules. General Rules No additional General Rules. Conformance Rules No additional Conformance Rules. Copyright International Organization
43、 for Standardization Provided by IHS under license with ISO Licensee=HP Monitoring/1111111164 Not for Resale, 12/04/2007 20:50:21 MSTNo reproduction or networking permitted without license from IHS -,-,- ISO/IEC 9075-4:2003/Cor.1:2005(E) ISO/IEC 2005 All rights reserved 5 9.3 1.Rationale:Correct ove
44、rride of General Rules. Replace the General Rules with: General Rules No additional General Rules. 9.24 1.Rationale:Add to what a cannot contain. Insert the following Subclause: 9.24 Function Specify a condition for the SQL-data. Format No additional Format items. Syntax Rules 1)Replace SR 1) The sh
45、all not contain a , an , a , an , or an . Access Rules No additional Access Rules. General Rules No additional General Rules. Copyright International Organization for Standardization Provided by IHS under license with ISO Licensee=HP Monitoring/1111111164 Not for Resale, 12/04/2007 20:50:21 MSTNo re
46、production or networking permitted without license from IHS -,-,- ISO/IEC 9075-4:2003/Cor.1:2005(E) 6 ISO/IEC 2005 All rights reserved Conformance Rules No additional Conformance Rules. 9.25 1.Rationale:Add to what a cannot contain. Insert the following Subclause: 9.25 Function Specify a condition f
47、or the SQL-data. Format No additional Format items. Syntax Rules 1)Replace SR 3) The shall not contain a , an , a , an , or an . Access Rules No additional Access Rules. General Rules No additional General Rules. Conformance Rules No additional Conformance Rules. Copyright International Organization for Standardization Provided by IHS under license with ISO Licensee=HP Monitoring/1111111164 Not for Resale, 12/04/2007 20:50:21 MSTNo reproduction or networking permitted without license from IHS -,-,- ISO/IEC 9075-4:2003/Cor.1:2005(E) ISO/IEC 2005 All rights rese