ISO/IEC 9075-4:2023

INTERNATIONAL ISO/IEC
STANDARD 9075-4
Seventh edition
2023-06
Information technology — Database
languages SQL —
Part 4:
Persistent stored modules (SQL/PSM)
Technologies de l'information — Langages de base de données SQL —
Partie 4: Modules stockés persistants (SQL/PSM)
Reference number
© ISO/IEC 2023
© ISO/IEC 2023
All rights reserved. Unless otherwise specified, or required in the context of its implementation, no part of this publication may
be reproduced or utilized otherwise in any form or by any means, electronic or mechanical, including photocopying, or posting on
the internet or an intranet, without prior written permission. Permission can be requested from either ISO at the address below
or ISO’s member body in the country of the requester.
ISO copyright office
CP 401 • Ch. de Blandonnet 8
CH-1214 Vernier, Geneva
Phone: +41 22 749 01 11
Email: copyright@iso.org
Website: www.iso.org
Published in Switzerland
ii
© ISO/IEC 2023 – All rights reserved

ISO/IEC9075-4:2023(E)
Contents Page
Foreword.viii
Introduction.x
1 Scope.1
2 Normativereferences.2
3 Termsanddefinitions.3
4 Concepts.4
4.1 Notationsandconventions.4
4.1.1 Notations.4
4.1.2 Useofterms.4
4.2 SQL-server modules.4
4.3 Tables.5
4.3.1 Basetables.5
4.3.1.1 Temporary tables.5
4.3.2 Uniqueidentificationoftables.5
4.4 SQL-schemas.5
4.5 SQL-invokedroutines.6
4.5.1 OverviewofSQL-invokedroutines.6
4.5.2 ExecutionofconventionalSQL-invokedroutines.6
4.5.3 Routinedescriptors.6
4.6 SQL-paths.6
4.7 Host parameters.6
4.7.1 Statusparameters.6
4.8 Diagnostics area.6
4.9 Condition handling.7
4.10 Cursors.8
4.10.1 Generaldescriptionofcursors.8
4.11 SQL-statements.9
4.11.1 ClassesofSQL-statements.9
4.11.2 SQL-statementsclassifiedbyfunction.9
4.11.2.1 SQL-schemastatements.9
4.11.2.2 SQL-control statements.9
4.11.2.3 SQL-controldeclarations.9
4.11.2.4 SQL-diagnosticsstatements.10
4.11.3 SQL-statementsandtransactionstates.10
4.11.4 SQL-statementatomicityandstatementexecutioncontexts.10
4.11.5 EmbeddableSQL-statements.10
4.11.6 PreparableandimmediatelyexecutableSQL-statements.11
4.11.7 DirectlyexecutableSQL-statements.11
©ISO/IEC2023–Allrightsreserved iii

ISO/IEC9075-4:2023(E)
4.11.8 IteratedSQL-statements.11
4.11.9 Compoundstatements.12
4.12 Basicsecuritymodel.12
4.12.1 Privileges.12
4.13 SQL-sessions.12
4.13.1 GeneraldescriptionofSQL-sessions.12
5 Lexicalelements.13
5.1 and.13
5.2 Namesandidentifiers.15
6 Scalarexpressions.17
6.1 and.17
6.2 .19
6.3 .21
6.4 .22
7 Queryexpressions.23
7.1 .23
7.2 .24
8 Additionalcommonrules.25
8.1 Potentialsourcesofnon-determinism.25
8.2 Executingan.26
8.3 Executinga.27
8.4 InvokinganSQL-invokedroutine.29
8.5 Transformationofqueryspecifications.30
8.6 Handlerexecution.31
9 Additionalcommonelements.34
9.1 .34
10 Schemadefinitionandmanipulation.36
10.1 .36
10.2 .37
10.3 .38
10.4 .39
10.5 .40
10.6 .41
10.7 .42
10.8 .43
10.9 .44
10.10 .45
10.11 .46
10.12 .47
10.13 .48
10.14 .49
10.15 .50
10.16 .51
10.17 .52
10.18 .53
iv ©ISO/IEC2023–Allrightsreserved

ISO/IEC9075-4:2023(E)
10.19 .54
10.20 .55
10.21 .56
10.22 .59
10.23 .60
10.24 .61
10.25 .63
10.26 .64
11 Accesscontrol.65
11.1 .65
11.2 .66
11.3 .67
12 SQL-clientmodules.71
12.1 .71
12.2 .73
13 Datamanipulation.74
13.1 .74
13.2 .75
13.3 .76
13.4 .77
13.5 .78
13.6 .79
13.7 .80
13.8 .81
14 Additionaldatamanipulationrules.82
14.1 Effectofopeningacursor.82
15 Control statements.83
15.1 .83
15.2 .86
15.3 .88
15.4 .89
15.5 .90
15.6 .94
15.7 .97
15.8 .99
15.9 .100
15.10 .101
15.11 .102
15.12 .104
15.13 .105
16 DynamicSQL.108
16.1 .108
16.2 .110
16.3 .111
17 EmbeddedSQL.112
©ISO/IEC2023–Allrightsreserved v

ISO/IEC9075-4:2023(E)
17.1 .112
18 DirectinvocationofSQL.114
18.1 .114
19 Diagnosticsmanagement.115
19.1 .115
19.2 .117
19.3 .119
20 InformationSchema.121
20.1 InformationSchemadigitalartifact.121
20.2 MODULE_COLUMN_USAGEview.121
20.3 MODULE_PRIVILEGESview.123
20.4 MODULE_TABLE_USAGEview.124
20.5 MODULESview.125
20.6 PARAMETERSview.126
20.7 ROLE_MODULE_GRANTS view.127
20.8 ROUTINESview.
...