c067370_ISO_IEC_9075-4_2011_Cor_2_20015.pdf

INTERNATIONAL STANDARD ISO/IEC 9075-42011 TECHNICAL CORRIGENDUM 2 Published 2015-10-01 INTERNATIONAL ORGANIZATION FOR STANDARDIZATION  МЕЖДУНАРОДНАЯ ОРГАНИЗАЦИЯ ПО СТАНДАРТИЗАЦИИ  ORGANISATION INTERNATIONALE DE NORMALISATION INTERNATIONAL ELECTROTECHNICAL COMMISSION  МЕЖДУНАРОДНАЯ ЭЛЕКТРОТЕХНИЧЕСКАЯ КОМИССИЯ  COMMISSION LECTROTECHNIQUE INTERNATIONALE Ination technology Database languages SQL Part 4 Persistent Stored Modules SQL/PSM TECHNICAL CORRIGENDUM 2 Technologies de lination Langages de base de donnes SQL Partie 4 Modules stocks persistants SQL/PSM RECTIFICATIF TECHNIQUE 2 Technical Corrigendum 2 to ISO/IEC 9075-42011 was prepared by Joint Technical Committee ISO/IEC JTC 1, Ination technology, Subcommittee SC 32, Data management and interchange. ICS 35.060 Ref. No. ISO/IEC 9075-42011/Cor.22015E ISO/IEC 2015 – All rights reserved Published in Switzerland ContentsPage 8Additional common elements. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 8.1. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 9Schema definition and manipulation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 9.11. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 11SQL-client modules. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 11.2. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 12Data manipulation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 12.8. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 14Control statements. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 14.1. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 iiISO/IEC 2015 – All rights reserved ISO/IEC 9075-42011/Cor.2 2015E Ination technology Database languages SQL Part 4 Persistent Stored Modules SQL/PSM TECHNICAL CORRIGENDUM 2 8Additional common elements 8.1 1.RationaleEditorial to match change in Foundation. Replace Syntax Rule 4 with 4Replace SR 9giii3 If XAi is an , an , a , or a , then the Syntax Rules of Subclause 9.2, “Store assignment”, in ISO/IEC 9075-2, are applied with Pi as TARGET and XAi as VALUE. 9Schema definition and manipulation 9.11 1.RationaleClarify that adding a subview may not violate a dependency of an SQL-schema object on some property of the subview’s supertable. Insert a new Syntax Rule. 1.1Insert after SR21sv.15 The module descriptor of any SQL-server module. 11 SQL-client modules 11.2 1.RationaleClarify the cution of an SQL-statement. Replace General Rule 1 with ISO/IEC 2015 – All rights reserved1 1Replace GR 5.2 If S is not an or a , then the first diagnostics area is emptied. 12 Data manipulation 12.8 1.RationaleA can be cuted in direct SQL. Replace Syntax Rule 1 with 1Replace SR 2 TTD shall be contained in an , in a or in an . 14 Control statements 14.1 This Subclause is modified by Subclause 11.27, “”, in ISO/IEC 9075-10. This Subclause is modified by Subclause 15.1, “”, in ISO/IEC 9075-14. 1.RationaleIf there is an unhandled exception, leave the loop and per all clean-up actions. Replace General Rule 3 c ii with 3... c... iiIf there are unhandled exception conditions at the completion of the cution of a handler if any, then the cution of GR3 is terminated immediately and uation continues with GR 4. 2ISO/IEC 2015 – All rights reserved ISO/IEC 9075-42011/Cor.2 2015E