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

588573264.002.png

588573264.003.png

iSeries

DB2 Universal Database for iSeries SQL Programming

Concepts

Version 5

588573264.004.png

588573264.005.png

© 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

588573264.001.png

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin