MOMENTAN AUSVERKAUFT
Über dieses Produkt
Product Identifiers
PublisherPrentice Hall PTR
ISBN-10013675919X
ISBN-139780136759195
eBay Product ID (ePID)10038280219
Product Key Features
Number of Pages512 Pages
Publication NameProgramming Informix Sql 4gl : a Step-By-Step Approach
LanguageEnglish
SubjectProgramming Languages / General, Desktop Applications / Databases, Databases / General
Publication Year1997
TypeTextbook
AuthorCathy Kipp
Subject AreaComputers
SeriesPrentice Hall Ptr Informix Ser.
FormatTrade Paperback
Dimensions
Item Height1.8 in
Item Weight48.6 Oz
Item Length9.3 in
Item Width7 in
Additional Product Features
Edition Number2
Intended AudienceScholarly & Professional
LCCN97-034776
Dewey Edition21
IllustratedYes
Dewey Decimal005.75/65
Table Of Content1. Relational Database Design. What is a Relational Database? Elements of a Database: Tables, Columns, and Rows. Tables. Columns. Rows. Primary Keys. Foreign Keys. Types of Relationships. One-to-One or Zero. One-to-Many (or Many-to-One). Many-to-Many. What Is Normalization? Formal Normalization. First Normal Form. Second Normal Form. Third Normal Form. Intuitive Normalization. Indexing Strategies. Composite Indexes. Unique Indexes. Duplicate Indexes. Shorter Is Better. Numeric versus Character Indexes. Clustered Indexes. Small Tables. Description of the Sample Database. Summary. 2. The SQL Working Environment. About Informix's Implementation of SQL. About DB-Access. Setting UNIX Environment Variables. Environment Variables Needed by Informix. Optional Environment Variables. Using DB-Access. DB-Access Options with Ring Menus. Getting Around in Informix Ring Menus. Choosing Options from a List. Working From the Command Line. Viewing Error Messages. Summary. 3. Creating the Database. The Database Administrator. INFORMIX Database Engines. Database Statements. Data Types. Character and String Data Types. Numer Data Types. Date, Time, and Interval Data Types. Extra data types for INFORMIX-OnLine. Summary of Data Type Conversions. Tables. Creating a New Table. Changing an Existing Table. Deleting a Table. Renaming Tables and Columns. Privileges. Granting Database Privileges. Granting Table Privileges. Revoking Privileges. Roles. Creating Schema Authorization. Indexes. Creating the Sample Database. Viewing the Database. Summary. 4. Maintaining the Database. Update Statistics. Checking Database Integrity. INFORMIX-SE Database Integrity. INFORMIX-OnLine Database Integrity. Database Backups. INFORMIX-SE Backups. INFORMIX-OnLine Backups. Logging. What Is a Transaction? Transaction Logging in INFORMIX-SE. Transaction Logging in INFORMIX-OnLine. Audit Trails-INFORMIX-SE Only. Summary. 5. Data: Adding, Changing, and Deleting. Insert. Update. Delete. Locking. Locking a Database. Locking a Table. Set Lock Mode. INFORMIX-OnLine Table Option. Load and Unload. Loading Data. Unloading Data. dbload. The Command File. Examples. dbexport and dbimport. dbexport. dbimport. Tips for Faster Data Loads. Summary. 6. The Select Statement. Overview of the Select Statement. Select. From. Where. Conditional Expressions. Matches and Like. Other Conditionals. Group By. Having. Order By. Into Temp. Union. Joins. Outer Joins. Output To. Summary. 7. The 4GL Programming Environment. INFORMIX-4GL Flavors: r4gl and c4gl. INFORMIX-4GL File Name Suffixes. Menu Driven Development. Command Line Development. Compiling and Running 4GL Code in the Rapid Development System. Compiling and Running Compiled 4GL Code. Compiling Informix Screen Forms. Make Files. Make Rules. The Make File. Prototyping. Summary. 8. 4GL Program Structure. Overview. Database. Globals. Main. Modules. Functions. Exit Program. Comments. Summary. 9. Data Types and Definitions. 4GL Data Types. Character and String Data Types. Numeric Data Types. Date, Time, and Interval Data Types. BLOB Data Types. INFORMIX-4GL Only Data Types and Indirect Typing. Defining Variables. Scope of Variables. Use of Nulls. Operators in 4GL. Converting between Data Types. Character and String Data Types. Numeric Data Types. Date, Time, and Interval Data Types. Formatting Data with the using Clause. Formatting Dates. Formatting Numbers. Summary. 10. Menus. Overview of Menus. A Simple Ring Menu. Menu Simplicity and Consistency. Menu Features. Command Keys. Help. Next Option. Continue Menu. Hidden Menu Options. Hide Option. Show Option. Before Menu. Summary. 11. Output and Standard Program Statements. <
SynopsisThe up-to-date primer for every INFORMIX SQL/4GL database developer This example-rich primer covers everything you need to know to successfully design, implement, and maintain databases with Informix's version of SQL. You'll quickly review the basics of database design, with easy-to-understand explanations of normalization, indexing strategies, and more. Then discover the SQL working environment, DB-Access, and the unique capabilities and features of Informix's SQL implementation; and how INFORMIX-SE and INFORMIX-OnLine compare. Walk step by step through creating and maintaining a database, reviewing database statements, data types, insert, update, delete, load/unload, dbexport/dbimport, locking, and select. Then take a close look at the 4GL programming environment, both r4gl and c4gl, including: * Program structure * Data types and definitions * Menus, output, and much more Programming Informix SQL/4GL presents detailed, end-to-end coverage of screen forms, options, creating context-sensitive help, and error handling. You'll learn how to make the most of advanced Informix capabilities, including user-defined searches, input array statements, complex screen I/O, matrix, and multi-, This is the second edition of Cathy Kipp's programming Informix SQL/4GL. It has been updated based on user comment we received on the first edition, and to cover changes in the Informix SQL/4GL languages. This book will use the more trade-oriented Informix Press design, and it will include a CD-ROM with various software packages for Informix programmers., An indispensable tutorial and reference in one volume, this second edition has been revised and updated based on end-user feedback and changes in the Informix SQL/4GL languages. The CD-ROM contains many helpful software packages and hundreds of examples that help readers understand Informix 4GL and Informix SQL.
LC Classification NumberQA76.9.D3K498 1998
