ISO/IEC 9075-4:2016/Cor 2:2022

Information technology — Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM) — Technical Corrigendum 2

Technologies de l'information — Langages de base de données — SQL — Partie 4: Modules stockés persistants (SQL/PSM) — Rectificatif technique 2

General Information

• Status: Published
• Publication Date: 23-Jun-2022
• ICS: 35.060 - Languages used in information technology
• Technical Committee: ISO/IEC JTC 1/SC 32 - Data management and interchange
• Drafting Committee: ISO/IEC JTC 1/SC 32 - Data management and interchange
• Current Stage: 9599 - Withdrawal of International Standard
• Completion Date: 01-Jun-2023

Relations

• Revised: ISO/IEC 9075-4:2023 - Information technology — Database languages SQL — Part 4: Persistent stored modules (SQL/PSM)
• Effective Date: 11-Feb-2023

Standards Content (Sample)

INTERNATIONAL STANDARD ISO/IEC 9075-4:2016
TECHNICAL CORRIGENDUM 2
Published 2022-06
INTERNATIONAL ORGANIZATION FOR STANDARDIZATION • МЕЖДУНАРОДНАЯ ОРГАНИЗАЦИЯ ПО СТАНДАРТИЗАЦИИ • ORGANISATION INTERNATIONALE DE NORMALISATION
INTERNATIONAL ELECTROTECHNICAL COMMISSION • МЕЖДУНАРОДНАЯ ЭЛЕКТРОТЕХНИЧЕСКАЯ КОМИССИЯ • COMMISSION ÉLECTROTECHNIQUE INTERNATIONALE
Information technology — Database languages — SQL — Part 4:
Persistent stored modules (SQL/PSM)
TECHNICAL CORRIGENDUM 2
Technologies de l'information — Langages de base de données — SQL — Partie 4: Modules
stockés persistants (SQL/PSM)
RECTIFICATIF TECHNIQUE 2
Technical Corrigendum 2 to ISO/IEC 9075-4:2016 was prepared by Joint Technical Committee
ISO/IEC JTC 1, Information technology, Subcommittee SC 32, Data management and interchange.
ICS 35.060 Ref. No. ISO/IEC 9075-4:2016/Cor.2:2022(E)
©  ISO/IEC 2022 – All rights reserved
Published in Switzerland

---------------------- Page: 1 ----------------------
ISO/IEC9075-4:2016/Cor.2:2022(E)
4 Concepts
4.1 SQL-servermodules
1. Rationale:Clarifytheprecisionoftimestamps.
th th
Replacethe9 bulletofthe5 paragraphwith:
— Thecreationtimestamp,ofanimplementation-definedtimestamptype.
5 Lexicalelements
5.2 Namesandidentifiers
1. Rationale:Addmissingcondition.
ReplacetheleadtextofSyntaxRule5)b)with:
5) .
b) IfUDTNissimplycontainedinandUDTNdoes
notcontaina,then
Case:
9 Additionalcommonelements
9.1
1. Rationale:Supplythecorrectarguments.
ReplaceSyntaxRule4)with:
4) ReplaceSR9)h)iii)5)IfXAisan,an,a
i
,ora,thentheSyntaxRulesof
Subclause9.2,“Storeassignment”,inISO/IEC9075-2,areappliedwithXAasTARGETandP
i i
asVALUE.
NOTE11—Thecanonlybeanewtransitionvariablecolumnreference.
11Accesscontrol
11.2
1. Rationale:Replacetheuseof"may"andclarify.
ReplaceSyntaxRule1)with:
2 © ISO/IEC 2022 – All rights reserved

---------------------- Page: 2 ----------------------
ISO/IEC9075-4:2016/Cor.2:2022(E)
1) InsertafterSR4)d) IftheobjectidentifiedbyONisanSQL-servermodule,thenACshall
specifyEXECUTE.
NOTE2—TheRulenumberaboveistheoneaftertheapplicationoftheTCforSQL/Foundation.
11.3
1. Rationale:Addmissingcontainersofsubjectroutines.
ReplaceGeneralRule8)with:
8) InsertafterGR29)a)EXECUTEprivilegeoneverySQL-servermodulethatincludesoneor
moreSQL-invokedroutinesthatareamongthesubjectroutinesofa,
,,orthatiscontainedin
theofRDorintheofanySQLparameterofRD.
2. Rationale:Addmissingcontainersofsubjectroutines.
ReplaceGeneralRules9)a)andb)with:
9) .
a) EXECUTEprivilegeoneveryschema-levelroutinethatisamongthesubjectroutinesofa
,,,or erence>thatiscontainedintheofanySQL-invokedroutineinclu
...