Name:
CAN/CSA-ISO/IEC 4/4/9075 PDF

Published Date:
12/01/2004

Status:
Active

Description:

Information Technology - Database Languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM) (Adopted ISO/IEC 9075-4:2003, third edition, 2003-12-15), Includes Technical Corrigendum 1:2006 and Technical Corrigendum 2:2008

Publisher:
Canada National Standard/Canadian Standards - ISO/IEC

Document status:

Active

Format:

Electronic (PDF)

Delivery time:

10 minutes

Delivery time (for Russian version):

200 business days

SKU:

This is a text searchable PDF

1 Scope

This part of International Standard ISO/IEC 9075 specifies the syntax and semantics of a database language for declaring and maintaining persistent database language routines in SQL-server modules.

The database language for externally-invoked procedures andSQL-invoked routine>s includes: - The specification of statements to direct the flow of control. - The assignment of the result of expressions to variables and parameters. - The specification of condition handlers that allow SQL-invoked routines to deal with various conditions that arise during their execution. - The specification of statements to signal and resignal conditions. - The declaration of local cursors. - The declaration of local variables.

It also includes the definition of the Information Schema tables that contain schema information pertaining to SQL-server modules and SQL-invoked routines.

File Size :	1 file , 7.7 MB
Number of Pages :	189
Published :	12/01/2004

History

CAN/CSA-ISO/IEC 9075-4:18 (R2022)

Published Date: 01/01/2018

Information technology - Database languages - SQL - Part 4: Persistent stored modules (SQL/PSM) (Adopted ISO/IEC 9075-4:2016, sixth edition, 2016-12-15), Includes Technical Corrigendum 1:2020

$68.7

CAN/CSA-ISO/IEC 9075-4:13 (R2017)

Published Date: 01/01/2013

Information technology - Database languages - SQL - Part 4: Persistent stored modules (SQL/PSM) (Adopted ISO/IEC 9075-4:2011, fourth edition, 2011-12-15), Includes Technical Corrigendum 1:2015, Technical Corrigendum 2:2016

$95.7

CAN/CSA-ISO/IEC 4/9/9075

Published Date: 10/01/2009

Information technology - Database languages - SQL - Part 4: Persistent stored modules (SQL/PSM) (Adopted ISO/IEC 9075-4:2008, fourth edition, 2008-07-15), Includes Technical Corrigendum 1:2012

$96

CAN/CSA-ISO/IEC 4/4/9075

Published Date: 12/01/2004

Information Technology - Database Languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM) (Adopted ISO/IEC 9075-4:2003, third edition, 2003-12-15), Includes Technical Corrigendum 1:2006 and Technical Corrigendum 2:2008

$75.6

Related products

CAN/CSA-ISO/IEC 7811-3-96 (R2000)

Published Date: 01/18/2000

Identification Cards - Recording Technique - Part 3: Location of Embossed Characters on ID-1 Cards (Adopted ISO/IEC 7811-3:1995)

$9.6

CAN/CSA-ISO/IEC 9579-1-95 (R2000)

Published Date: 01/19/2000

Information Technology - Open Systems Interconnection - Remote Database Access - Part 1: Generic Model, Service and Protocol (Adopted ISO/IEC 9579-1:1993)

$42.6

CAN/CSA-ISO/IEC 10967-3-07 (R2022)

Published Date: 10/31/2007

Information Technology - Language Independent Arithmetic - Part 3: Complex Integer and Floating Point Arithmetic and Complex Elementary Numerical Functions (Adopted ISO/IEC 10967-3:2006, first edition, 2006-05-01)

$96

CAN/CSA-ISO/IEC 29794-1:18 (R2022)

Published Date: 01/01/2018

Information technology - Biometric sample quality - Part 1: Framework (Adopted ISO/IEC 29794-1:2016, second edition 2016-01-15, corrected version 2016-09-15)

$41.7

Best-Selling Products

ANSI/NEMA 250-2020

Published Date: 2020

Enclosures for Electrical Equipment (1,000 Volts Maximum)

$65.7

ANSI/NEMA 62321-1-2013

Published Date: 2022

Determination of Certain Substances in Electrotechnical Products Part 1: Introduction and Overview Published

$39.9

ANSI/NEMA 62321-10-2020

Published Date: 2020

Determination of Certain Substances in Electrotechnical Products Part 10: Polycyclic Aromatic Hydrocarbons (PAHs) in Polymers and Electronics by Gas Chromatography-Mass Spectrometry (GC-MS)

$81.6

ANSI/NEMA 62321-2-2013

Published Date: 2022

Determination of Certain Substances in Electrotechnical Products Part 2: Disassembly, Disjointment and Mechanical Sample Preparation

$104.1

ANSI/NEMA 62321-3-1-2013

Published Date: 2023

Determination of Certain Substances in Electrotechnical Products Part 3-1: Screening--Lead, Mercury, Cadmium, Total Chromium and Total Bromine Using X-Ray Fluorescence Spectrometry

$93.6

ANSI/NEMA 62321-3-2-2020

Published Date: 2023

Determination of Certain Substances in Electrotechnical Products Part 3-2: Screening--Fluorine, Bromine and Chlorine in Polymer and Electronics by Combustion-Ion Chromatography (C-IC)

$121.8