BS ISO/IEC 9075-10:2000

Foreword
Introduction
1 Scope
2 Normative references
      2.1 JTC 1 standards
      2.2 Publicly-available specifications
3 Definitions, notations, and conventions
      3.1 Definitions
      3.2 Notations
      3.3 Conventions
      3.4 Object identifier for Database Language SQL
4 Concepts
      4.1 Introduction
      4.2 Embedded syntax
      4.3 SQL constructs
      4.4 Character strings
      4.5 Host variables
      4.6 Host expressions
      4.7 SQLJ clauses
      4.8 Database connection context
      4.9 Default connection context
      4.10 Schema checking using exemplar schemas
      4.11 Using multiple SQLJ contexts and connections
      4.12 Dynamic SQL and JDBC/SQLJ Connection
             interoperability
      4.13 SQL execution control and status
      4.14 Interators
      4.15 Input and output assignability
      4.16 Calls to stored procedures and functions
      4.17 Multiple JDBC ResultSet objects from stored
             procedure calls
      4.18 JDBC/SQLJ ResultSet interoperability
      4.19 Multi-threading considerations
      4.20 User-defined data types
      4.21 Batch updates
      4.22 SQLJ language elements
5 Lexical elements
      5.1
6 Scalar expressions
      6.1 and
7 Additional common elements
      7.1
8 Embedded SQL
      8.1
      8.2
9 Binary portability
      9.1 Components of binary portable applications
      9.2 Naming runtime components
      9.3 Binary portability requirements
      9.4 Profile overview
      9.5 Profile generation and naming
      9.6 SQLJ application packaging
      9.7 Profile customization overview
      9.8 Customization interface
      9.9 EntryInfo overview
      9.10 TypeInfo overview
      9.11 SQLJ datatype properties
10 SQLJ grammar constructs
      10.1 Grammar notation
      10.2 Keyword and SQL case sensitivity rules
      10.3 Commenting rules
      10.4 SQLJ reserved names
      10.5 Clause structure
      10.6 Common subelements
11 and contents
      11.1
      11.2
      11.3 Generated connection class
      11.4
      11.5
      11.6 Generated positioned iterator class
      11.7
      11.8 Generated named iterator class
      11.9
      11.10
      11.11
      11.12
      11.13
      11.14
      11.15
      11.16
      11.17
      11.18
      11.19
      11.20
      11.21
      11.22
      11.23
      11.24
12 Additional features
      12.1 SQL blocks
      12.2 sqlj.runtime.ExecutionContext
13 Package sqlj.runtime
      13.1 SQLJ runtime interfaces
      13.2 SQLJ Runtime Classes
14 Package sqlj.runtime.profile
      14.1 SQLJ sqlj.runtime.profile Interfaces
      14.2 SQLJ sqlj.runtime.profile Classes
15 sqlj.runtime.profile.util.ProfileCustomizer
      15.1 Methods
16 Dynamic SQL
      16.1 Description of SQL descriptor areas
      16.2
      16.3
      16.4
17 Call-Level Interface specifications
      17.1 Implicit DESCRIBE USING clause
      17.2 Description of CLI item descriptor areas
      17.3 Other tables associated with CLI
18 Definition Schema
      18.1 SQL_LANGUAGES base table
19 Status codes
      19.1 SQLSTATE
20 Conformance
      20.1 Claims of conformance
      20.2 Extensions and options
      20.3 The SQLJ subset
Annex A - SQL Conformance Summary
Annex B - Implementation-defined elements
Annex C - Implementation-dependent elements
Annex D - Deprecated features
Annex E - Typical header files
      E.1 - C header file SQLCLI.H
      E.2 - COBOL library item SQLCLI
Annex F - SQL Feature Taxonomy
Annex G - SQLJ tutorial
      G.1 - Design goals
      G.2 - Advantages of SQLJ over JDBC
      G.3 - Consistency with existing embedded SQL languages
      G.4 - Examples
Index
Tables

Abstract

Defines extensions of Database language SQL to support embedding of SQL statements into programs written in the Java programming language. The embedding of SQL into Java is commonly known as "SQLJ". This part of ISO/IEC 9075 specifies the syntax and semantics of SQLJ, as well as mechanisms to ensure binary portability of resulting SQLJ applications. In addition, it specifies a number of Java packages and their contained classes.

General Product Information

Committee	IST/40
DevelopmentNote	Supersedes 98/650717 DC. (07/2005)
DocumentType	Standard
Pages	394
PublisherName	British Standards Institution
Status	Withdrawn
SupersededBy	BS ISO/IEC 9075 1-4,9-11,13-14:2003

International Equivalents

Standards	Relationship
ISO/IEC 9075-10:2016	Identical

Standards Referencing This Book

ISO/IEC 9075-2:2016	Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation)
ISO/IEC 9075-5:1999	Information technology Database languages SQL Part 5: Host Language Bindings (SQL/Bindings)
ISO/IEC 10032:1995	Information technology — Reference Model of Data Management
ISO/IEC 9075-3:2016	Information technology — Database languages — SQL — Part 3: Call-Level Interface (SQL/CLI)
ISO/IEC 10646-1:2000	Information technology Universal Multiple-Octet Coded Character Set (UCS) Part 1: Architecture and Basic Multilingual Plane
ISO/IEC 9075-4:2016	Information technology — Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM)
ISO/IEC 9075-1:2016	Information technology — Database languages — SQL — Part 1: Framework (SQL/Framework)

Category

Subcategory

Access your standards online with a subscription

Features

• Simple online access to standards, technical information and regulations.

• Critical updates of standards and customisable alerts and notifications.

• Multi-user online standards collection: secure, flexible and cost effective.

Learn more on subscription solutions

or

Get in touch with us

Contact us

• 

  ILI LIMITED (Trading As Intertek Inform), 12 Davy Ave Knowlhill, Milton Keynes MK5 8NL

• 

  standards@intertekinform.com

• 

  Monday to Friday 9 am to 5 pm (GMT)

• 

  +44 (0)203 327 3140