Informix Comandos Base De Datos
Páginas: 466 (116387 palabras)
Publicado: 9 de julio de 2012
DB2 IBM Informix
®
Version 10.0/8.5
IBM Informix Guide to SQL: Tutorial
G251-2285-00
DB2 IBM Informix
®
Version 10.0/8.5
IBM Informix Guide to SQL: Tutorial
G251-2285-00
Note! Before using this information and the product it supports, read the information in “Notices” on page B-1.
First Edition (December 2004) This document contains proprietary information of IBM.It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties, and any statements provided in this manual should not be interpreted as such. When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incurringany obligation to you. © Copyright International Business Machines Corporation 1996, 2004. All rights reserved. US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
Contents
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xi About This Manual . . . . . . . . . . . . . . . . . . . . . . . . . .. . xi Types of Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xii Software Dependencies . . . . . . . . . . . . . . . . . . . . . . . . . . xii Assumptions About Your Locale . . . . . . . . . . . . . . . . . . . . . . . xii Demonstration Database . . . . . . . . . . . . . . . . . . . . . . . . . xiii New Features in Dynamic Server, Version 10.0 . . . . . . . . . . . . . . . . . .. xiii Documentation Conventions . . . . . . . . . . . . . . . . . . . . . . . . . xiv Typographical Conventions . . . . . . . . . . . . . . . . . . . . . . . . xiv Feature, Product, and Platform . . . . . . . . . . . . . . . . . . . . . . . xv Syntax Diagrams . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvi Example Code Conventions . . . . . . . . . . . . . . . . . . . . . . . . xxAdditional Documentation . . . . . . . . . . . . . . . . . . . . . . . . . . xxi Installation Guides . . . . . . . . . . . . . . . . . . . . . . . . . . . xxi Online Notes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxi Informix Error Messages . . . . . . . . . . . . . . . . . . . . . . . . . xxiii Manuals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxiv Online Help . .. . . . . . . . . . . . . . . . . . . . . . . . . . . xxiv Accessibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxiv IBM Informix Dynamic Server Version 10.0 and CSDK Version 2.90 Documentation Set . . . . . xxiv Compliance with Industry Standards . . . . . . . . . . . . . . . . . . . . . xxvii IBM Welcomes Your Comments . . . . . . . . . . . . . . . . . . . . . . . xxviiiChapter 1. Database Concepts . . . Illustration of a Data Model . . . . Storing Data . . . . . . . . Querying Data . . . . . . . . Modifying Data . . . . . . . Concurrent Use and Security . . . . Controlling Database Use . . . . Centralized Management . . . . Important Database Terms . . . . . The Relational Database Model . . Tables . . . . . . . . . . . Columns . . . . . . . . . . Rows . . . . . .. . . . Views . . . . . . . . . . Sequences . . . . . . . . . Operations on Tables . . . . . The Object-Relational Model (IDS) . Structured Query Language . . . . Standard SQL. . . . . . . . Informix SQL and ANSI SQL . . Interactive SQL . . . . . . . General Programming . . . . .
© Copyright IBM Corp. 1996, 2004
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . ....
®
Version 10.0/8.5
IBM Informix Guide to SQL: Tutorial
G251-2285-00
DB2 IBM Informix
®
Version 10.0/8.5
IBM Informix Guide to SQL: Tutorial
G251-2285-00
Note! Before using this information and the product it supports, read the information in “Notices” on page B-1.
First Edition (December 2004) This document contains proprietary information of IBM.It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties, and any statements provided in this manual should not be interpreted as such. When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incurringany obligation to you. © Copyright International Business Machines Corporation 1996, 2004. All rights reserved. US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
Contents
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xi About This Manual . . . . . . . . . . . . . . . . . . . . . . . . . .. . xi Types of Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xii Software Dependencies . . . . . . . . . . . . . . . . . . . . . . . . . . xii Assumptions About Your Locale . . . . . . . . . . . . . . . . . . . . . . . xii Demonstration Database . . . . . . . . . . . . . . . . . . . . . . . . . xiii New Features in Dynamic Server, Version 10.0 . . . . . . . . . . . . . . . . . .. xiii Documentation Conventions . . . . . . . . . . . . . . . . . . . . . . . . . xiv Typographical Conventions . . . . . . . . . . . . . . . . . . . . . . . . xiv Feature, Product, and Platform . . . . . . . . . . . . . . . . . . . . . . . xv Syntax Diagrams . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvi Example Code Conventions . . . . . . . . . . . . . . . . . . . . . . . . xxAdditional Documentation . . . . . . . . . . . . . . . . . . . . . . . . . . xxi Installation Guides . . . . . . . . . . . . . . . . . . . . . . . . . . . xxi Online Notes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxi Informix Error Messages . . . . . . . . . . . . . . . . . . . . . . . . . xxiii Manuals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxiv Online Help . .. . . . . . . . . . . . . . . . . . . . . . . . . . . xxiv Accessibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxiv IBM Informix Dynamic Server Version 10.0 and CSDK Version 2.90 Documentation Set . . . . . xxiv Compliance with Industry Standards . . . . . . . . . . . . . . . . . . . . . xxvii IBM Welcomes Your Comments . . . . . . . . . . . . . . . . . . . . . . . xxviiiChapter 1. Database Concepts . . . Illustration of a Data Model . . . . Storing Data . . . . . . . . Querying Data . . . . . . . . Modifying Data . . . . . . . Concurrent Use and Security . . . . Controlling Database Use . . . . Centralized Management . . . . Important Database Terms . . . . . The Relational Database Model . . Tables . . . . . . . . . . . Columns . . . . . . . . . . Rows . . . . . .. . . . Views . . . . . . . . . . Sequences . . . . . . . . . Operations on Tables . . . . . The Object-Relational Model (IDS) . Structured Query Language . . . . Standard SQL. . . . . . . . Informix SQL and ANSI SQL . . Interactive SQL . . . . . . . General Programming . . . . .
© Copyright IBM Corp. 1996, 2004
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . ....
Leer documento completo
Regístrate para leer el documento completo.