Tous nos rayons

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

CRÉER VOTRE COMPTE
SQL for eServer i5 and iSeries
Ajouter à une liste

Librairie Eyrolles - Paris 5e
Indisponible

SQL for eServer i5 and iSeries

SQL for eServer i5 and iSeries

Kevin Forsythe

354 pages, parution le 18/10/2004

Résumé

In this book, you will learn about Structured Query Language (SQL), but with an IBM eServer i5/iSeries twist. The future seems clear on this point: SQL is the direction of the future for IBM's Universal Database. While it is true that the majority of existing databases on the i5 and iSeries were created with DDS, it's still undeniable that DDS will slowly fade from use, much like the RPG program cycle.

With a practical "how-to" style, SQL for eServer i5 and iSeries first introduces you to the basics essential for any developer to build a solid foundation. Then the book examines--in detail--the many ways in which SQL functions on the iSeries. All possible environments are explored: the traditional 5250 green-screen applications, the SQL scripting tool within iSeries Navigator, and the methods of accessing iSeries databases from within Visual Basic.

Learn through real-life examples of using SQL to interact with DB2 databases. You'll learn the ins and outs of sub-selects, joins, unions, and views, as well as tips and techniques for interacting with legacy applications, and so much more. Though intended for programmers already familiar with SQL, beginners will appreciate the book's handy tutorial Appendix to get started with SQL basics.

After reading this book, you'll see that the i5/iSeries platform is far more than the green-screen application server it's often perceived as and that it is indeed one of the finest systems available for use as a business server today. Make your database access cutting-edge with SQL for eServer i5 and iSeries.

In this book you will learn to:

  • Incorporate SQL into existing iSeries business and client-side applications
  • Embed SQL within RPG programs, merging the flexibility of SQL with the power of RPG
  • Implement referential constraints, primary and unique key indexes, and check constraints
  • Journal physical files, and find out why this task is so important
  • Extend your database with user-defined functions and procedures
  • Use new GUI development tools for running, debugging, and tuning SQL statements

Sommaire

  • Introduction
  • Interactive SQL
  • SQL in iSeries Navigator
  • Embedded SQL
  • Advanced SQL Examples
  • Optimizing SQL
  • Creating Databases Objects
  • Creating Functions
  • Creating Stored Procedures
  • Creating SQL-based Tools
  • Using SQL from within Microsoft Office
  • Appendix A: SQL Basics for Beginners
Voir tout
Replier

Caractéristiques techniques

  PAPIER
Éditeur(s) MC Press
Auteur(s) Kevin Forsythe
Parution 18/10/2004
Nb. de pages 354
Format 18 x 23
Couverture Broché
Poids 575g
Intérieur Noir et Blanc
EAN13 9781583470480
ISBN13 978-1-58347-048-0

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
satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients sav@commande.eyrolles.com
librairie française
Librairie française depuis 1925
Recevez nos newsletters
Vous serez régulièrement informé(e) de toutes nos actualités.
Inscription