DB2 SQL Procedural Language for Linux, Unix, and Windows

Collectif d'auteurs

334 pages, parution le 16/01/2003

Ajouter à une liste

Indisponible

Résumé

DB2 SQL Procedural Language for Linux, UNIX, and Windows offers start-to-finish coverage of setting up your SQL PL development environment and using every element of the SQL PL language. Along the way, IBM's experts share tips and best practices for optimizing performance, developing more manageable code, troubleshooting, and even deployment.

The only book to combine practical SQL PL tutorials and detailed syntax reference information, DB2SQL Procedural Language for Linux, UNIX, and Windows draws on the authors' unparalleled expertise with SQL PL in real customer environments. Coverage includes:

Understanding your options for creating stored procedures in DB2 environments
Using the IBM DB2® Version 8 Development Center
Basic SQL PL procedure structure: parameters, declarations, and variable data types
Flow control and condition handling
Dynamic SQL
Full coverage of cursors
Making the most of nested stored procedures
Advanced features: global temporary tables, handling multiple result sets, savepoints, and more

Whether you're developing new applications, migrating or tuning existing applications, or administering DB2, DB2 SQL Procedural Language for Linux, UNIX, and Windows will be an invaluable resource.

The ultimate developer's resource for writing OB2 SQL procedures-straight from IBM
Expert tips and best practices drawn from extensive SQL PL experience in real customer environments
Covers everything from basic program structure through advanced techniques
Contains never-before-published guidance on using SQL PL

About the CD
The CD-ROM included with this book contains all of the book's source code, DB2 product documentation, a complete trial version of DB2 Universal Database, Version 8, and the IBM Redbook Cross-Platform DB2 Stored Procedures: Building and Debugging.
The book's official website ibm.com/software/data/developer/sqlplbook/ provides: latest updates to the book, bonus material, and book FAQs

Contents

Introduction
Basic SQL Procedure Structure
Using Flow of Control Statements
Understanding and Using Cursors and Result Sets
Condition Handling
Working with Dynamic SQL
Working with Nested SQL Procedures
Leveraging DB2 Advanced Features
Deploying SQL Procedures
Working with Triggers and User-Defined Functions

A- Getting Started with DB2
B- Setting up the Build Environment
C- Using the DB2 Development Center
D- Security Considerations in SQL Procedures
E- Built-in Function Reference
F- DDL
G- Additional Resources
H- Sample Application Code for Receiving Cursor Result Sets
I- SQL PL Cross-Platform Compatibility

L'auteur - Collectif d'auteurs

Autres livres de Collectif d'auteurs

Daniel Buren, mot à mot

Familles. Permanence et métamorphoses

Architecture studio

Structuration et management des organisations

Découvrir tous les livres de Collectif d'auteurs

Caractéristiques techniques

	PAPIER
Éditeur(s)	Prentice Hall
Auteur(s)	Collectif d'auteurs
Parution	16/01/2003
Nb. de pages	334
Format	17,6 x 23,4
Couverture	Broché
Poids	687g
Intérieur	Noir et Blanc
EAN13	9780131007727

Avantages Eyrolles.com

Livraison à partir de 0,01 € en France métropolitaine

Paiement en ligne SÉCURISÉ

Livraison dans le monde

Retour sous 15 jours

+ d'un million et demi de livres disponibles

Consultez aussi

Informatique Bases de données Produits SGBD DB2