Customer Support: 131 242

  • There are no items in your cart
We noticed you’re not on the correct regional site. Switch to our AMERICAS site for the best experience.
Dismiss alert

ANSI INCITS 135 : 1992

Superseded

Superseded

A superseded Standard is one, which is fully replaced by another Standard, which is a new edition of the same Standard.

View Superseded by
superseded

A superseded Standard is one, which is fully replaced by another Standard, which is a new edition of the same Standard.

INFORMATION SYSTEMS - DATABASE LANGUAGE - SQL

Available format(s)

Hardcopy , PDF

Superseded date

23-07-2013

Language(s)

English

Published date

01-01-1998

Foreword
Introduction
1 Scope
2 Normative references
3 Definitions, notations, and conventions
   3.1 Definitions
   3.2 Notation
   3.3 Conventions
   3.4 Object identifier for Database Language SQL
4 Concepts
   4.1 Data types
   4.2 Character strings
   4.3 Bit strings
   4.4 Numbers
   4.5 Datetimes and intervals
   4.6 Type conversions and mixing of data types
   4.7 Domains
   4.8 Columns
   4.9 Tables
   4.10 Integrity constraints
   4.11 SQL-schemas
   4.12 Catalogs
   4.13 Clusters of catalogs
   4.14 SQL-data
   4.15 SQL-environment
   4.16 Modules
   4.17 Procedures
   4.18 Parameters
   4.19 Diagnostics area
   4.20 Standard programming languages
   4.21 Cursors
   4.22 SQL-statements
   4.23 Embedded syntax
   4.24 SQL dynamic statements
   4.25 Direct invocation of SQL
   4.26 Privileges
   4.27 SQL-agents
   4.28 SQL-transactions
   4.29 SQL-connections
   4.30 SQL-sessions
   4.31 Client-server operation
   4.32 Information Schema
   4.33 Leveling
   4.34 SQL Flagger
5 Lexical elements
   5.1
   5.2 and
   5.3
   5.4 Names and identifiers
6 Scalar expressions
   6.1
   6.2 and
   6.3


   6.4
   6.5
   6.6
   6.7
   6.8
   6.9
   6.10
   6.11
   6.12
   6.13
   6.14
   6.15
7 Query expressions
   7.1
   7.2

   7.3

   7.4
   7.5
   7.6
   7.7
   7.8
   7.9
   7.10
   7.11 , , and

8 Predicates
   8.1
   8.2
   8.3
   8.4
   8.5
   8.6
   8.7
   8.8
   8.9
   8.10
   8.11
   8.12
9 Data assignment rules
   9.1 Retrieval assignment
   9.2 Store assignment
   9.3 Set operation result data types
10 Additional common elements
   10.1
   10.2
   10.3
   10.4
   10.5
   10.6 and
11 Schema definition and manipulation
   11.1
   11.2
   11.3

   11.4
   11.5
   11.6

   11.7
   11.8
   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
   11.25
   11.26
   11.27
   11.28
   11.29
   11.30
   11.31
   11.32
   11.33
   11.34
   11.35
   11.36
   11.37
12 Module
   12.1
   12.2
   12.3
   12.4 Call to a
   12.5
13 Data manipulation
   13.1
   13.2
   13.3
   13.4
   13.5
Committee
X3H2
DevelopmentNote
Supersedes ANSI INCITS 168. (05/2002)
DocumentType
Standard
Pages
626
PublisherName
Information Technology Industry Council
Status
Superseded
SupersededBy
Supersedes

CSA ISO/IEC 13818-6 : 2002 : R2010 INFORMATION TECHNOLOGY - GENERIC CODING OF MOVING PICTURES AND ASSOCIATED AUDIO INFORMATION - PART 6: EXTENSIONS FOR DSM-CC
CSA ISO/IEC 13818-6 : 2002 INFORMATION TECHNOLOGY - GENERIC CODING OF MOVING PICTURES AND ASSOCIATED AUDIO INFORMATION - PART 6: EXTENSIONS FOR DSM-CC
ANSI INCITS 168 : 1989 INFORMATION SYSTEMS - DATABASE LANGUAGE - EMBEDDED SQL
ANSI INCITS 135.10 : 1998 INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 10: OBJECT LANGUAGE BINDINGS (SQL/OLB)
ANSI INCITS 320 : 1998 INFORMATION TECHNOLOGY - SPATIAL DATA TRANSFER STANDARD (SDTS)
AIIM MS60 : 0 ELECTRONIC FOLDER INTERCHANGE DATASTREAM
ANSI INCITS 331.1 : 1999 INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQLJ - PART 1: SQL ROUTINES USING THE JAVA PROGRAMMING LANGUAGE
CSA ISO/IEC 13818-6 : 2002 : INC : AMD 3 : 2003 : R2015 INFORMATION TECHNOLOGY - GENERIC CODING OF MOVING PICTURES AND ASSOCIATED AUDIO INFORMATION - PART 6: EXTENSIONS FOR DSM-CC
ISO/IEC 13818-6:1998 Information technology — Generic coding of moving pictures and associated audio information — Part 6: Extensions for DSM-CC

ANSI INCITS 9 : 78(R1989) PROGRAMMING LANGUAGE FORTRAN
ISO/IEC 10646:2014 Information technology Universal Coded Character Set (UCS)
ANSI INCITS 53 : 1976 PROGRAMMING LANGUAGE PL/I
ISO/IEC 2022:1994 Information technology Character code structure and extension techniques
ISO/IEC 8824:1990 Information technology — Open Systems Interconnection — Specification of Abstract Syntax Notation One (ASN.1)
MIL-STD-1815 Revision A:1983
IEEE 770X3.160-1989 IEEE/ANSI Standard for the Programming Language Extended Pascal
ISO 8601:2004 Data elements and interchange formats Information interchange Representation of dates and times
ANSI INCITS 159 : 1989 "C" PROGRAMMING LANGUAGE
ISO/IEC 9579-2:1998 Information technology — Open Systems Interconnection — Remote Database Access — Part 2: SQL Specialization
ANSI INCITS 23 : 1985 PROGRAMMING LANGUAGE - COBOL
ANSI INCITS 198 : 1992 PROGRAMMING LANGUAGE - FORTRAN - EXTENDED
ISO/IEC 646:1991 Information technology ISO 7-bit coded character set for information interchange
MDC X11.1 : 1995 INFORMATION SYSTEMS - PROGRAMMING LANGUAGES - MUMPS

View more information
$98.22
Including GST where applicable

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.

Need help?
Call us on 131 242, then click here to start a Screen Sharing session
so we can help right away! Learn more