SQL Programing Concepts.pdf
(
1806 KB
)
Pobierz
DB2 UDB for iSeries SQL Programming Concepts V5R1
iSeries
DB2 Universal Database for iSeries SQL Programming
Concepts
Version 5
iSeries
DB2 Universal Database for iSeries SQL Programming
Concepts
Version 5
© Copyright International Business Machines Corporation 2000, 2001. All rights reserved.
US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract
with IBM Corp.
Contents
About DB2 UDB for iSeries SQL Programming Concepts
.................
xi
Who should read this book .............................
xi
Assumptions relating to examples of SQL statements ..................
xi
How to interpret syntax diagrams in this guide .....................
xii
What’s new in the V5R1 version of the SQL programming concepts information .........
xiii
Chapter 1. Introduction to DB2 UDB for iSeries Structured Query Language
.........
1
SQL concepts ..................................
1
SQL relational database and system terminology ....................
2
Types of SQL statements .............................
4
SQL Communication Area (SQLCA) .........................
5
SQL objects ...................................
5
Schemas ...................................
5
Tables, Rows, and Columns ............................
6
Aliases ....................................
7
Views ....................................
7
Indexes ...................................
8
Constraints ..................................
8
Triggers ...................................
8
Stored Procedures ...............................
8
User-defined functions ..............................
9
User-defined types ...............................
9
SQL Packages .................................
9
Application program objects .............................
9
User source file member .............................1
Output source file member ............................1
Program ...................................1
SQL Package .................................1
Module ...................................
12
Service program ................................
12
Chapter 2. Getting Started with SQL
.........................
13
Starting interactive SQL ..............................
13
Creating a schema ................................
13
Example: Creating the schema (SAMPLECOLL) ....................
13
Creating and using a table .............................
14
Example: Creating a table (INVENTORY_LIST) ....................
14
Creating the Supplier Table (SUPPLIERS) ......................
16
Using the LABEL ON statement ...........................
16
Inserting information into a table ...........................
17
Example: Inserting information into a table (INVENTORY_LIST) ..............
17
Getting information from a single table.........................
20
Getting information from more than one table ......................
22
Changing information in a table ...........................
24
Example: Changing information in a table ......................
24
Deleting information from a table ...........................
26
Example: Deleting information from a table (INVENTORY_LIST) ..............
27
Creating and using a view .............................
27
Example: Creating a view on a single table ......................
28
Example: Creating a view combining data from more than one table.............
28
Chapter 3. Getting started with Operations Navigator Database
..............
31
Starting Operations Navigator ............................
31
© Copyright IBM Corp. 2000, 2001
iii
Plik z chomika:
dragon8227
Inne pliki z tego folderu:
SQL.Server.2005.Replication].Apress.Pro.SQL.Server.2005.Replication.Dec.2006.pdf
(54756 KB)
Beginning Sql Server 2005 Express - Database Applications With Visual Basic Express And Visual We.pdf
(10151 KB)
Beginning SQL Server 2005 Express for Developers From Novice to Professional.pdf
(11058 KB)
Beginning Sql Server 2005 For Developers - From Novice To Professional.pdf
(18546 KB)
Beginning.SQL.Server.2005.Programming.Feb.2006.pdf
(11450 KB)
Inne foldery tego chomika:
Kurs MySQL II
Kurs1
Zgłoś jeśli
naruszono regulamin