IBM DB2 9.7 advanced application developer cookbook [[electronic resource] /] / Sanjay Kumar, Mohankumar Saraswatipura |
Autore | Kumar Sanjay |
Edizione | [1st edition] |
Pubbl/distr/stampa | Birmingham, U.K., : Packt Pub., 2012 |
Descrizione fisica | 1 online resource (442 p.) |
Disciplina | 005.7565 |
Altri autori (Persone) | SaraswatipuraMohankumar |
Soggetto topico |
Relational databases
Database management |
Soggetto genere / forma | Electronic books. |
ISBN |
1-280-12733-3
9786613531216 1-84968-397-2 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Application Development Enhancements in DB2 9.7; Introduction; Changing column names online using the ALTER TABLE operation; Using the CREATE OR REPLACE clause while creating objects; Using the ALTER TABLE operation in a single transaction; Using the CREATE WITH ERROR support; Using the soft invalidation and automatic revalidation support; Using the ALTER COLUMN SET DATA TYPE extended support; Using the new TRUNCATE statement; Using AUTONOMOUS transactions
Using implicit casting during application enablementUsing the DEFAULT values and NAMED arguments in procedures; Chapter 2: DB2 Application Techniques; Introduction; Granting and revoking instance-level authorities; Granting and revoking database-level authorities; Granting and revoking object privileges; Implementing static SQL in DB2; Implementing dynamic SQL in DB2; Creating Declared Global Temporary Tables (DGTTs); Using XML in a declared temporary table; Improving performance by creating indexes on a DGTT; Creating created global temporary tables (CGTT); Using generated columns in tables Creating a savepointRolling back to a savepoint; Using savepoints in JDBC; Using savepoints in SQLJ; Creating a sequence object; Modifying a sequence object; Referencing a sequence object; Chapter 3: General Application Design; Introduction; Improving concurrency by using a connection concentrator; Using trusted contexts for improved security; Using trusted connections in JDBC; Using trusted connections in PHP; Securing data by using DB2 encryption; Improving concurrency by using enhanced optimistic locking; Working with user-defined types (UDT); Working with structured types Chapter 4: Procedures, Functions, Triggers, and ModulesIntroduction; Creating a simple stored procedure; Using dynamic SQL in stored procedures; Working with result sets in stored procedures; Using ARRAY objects in stored procedures; Handling errors in stored procedures; Designing external stored procedures; Using PL/SQL exception handling in a procedure; Working with the message buffer in stored procedures; Planning and designing triggers; Using scalar user-defined functions; Writing external user-defined functions; Designing external table functions; Working with modules in DB2 Chapter 5: Designing Java ApplicationsIntroduction; Creating connection objects in JDBC applications; Creating connection objects in SQLJ applications; Manipulating XML Data in Java applications; Batch processing in JDBC applications; Batch processing in SQLJ applications; Working with scrollable result sets; Handling errors and warnings in JDBC applications; Developing Java applications for high availability; Using SSL in Java applications; Chapter 6: DB2 9.7 Application Enablement; Introduction; First step towards enabling Oracle application to DB2 9.7; Using ROWNUM and DUAL in DB2 9.7 Using CUR_COMMIT concurrency control isolation level |
Record Nr. | UNINA-9910461928503321 |
Kumar Sanjay | ||
Birmingham, U.K., : Packt Pub., 2012 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
IBM DB2 9.7 advanced application developer cookbook [[electronic resource] /] / Sanjay Kumar, Mohankumar Saraswatipura |
Autore | Kumar Sanjay |
Edizione | [1st edition] |
Pubbl/distr/stampa | Birmingham, U.K., : Packt Pub., 2012 |
Descrizione fisica | 1 online resource (442 p.) |
Disciplina | 005.7565 |
Altri autori (Persone) | SaraswatipuraMohankumar |
Soggetto topico |
Relational databases
Database management |
ISBN |
1-280-12733-3
9786613531216 1-84968-397-2 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Application Development Enhancements in DB2 9.7; Introduction; Changing column names online using the ALTER TABLE operation; Using the CREATE OR REPLACE clause while creating objects; Using the ALTER TABLE operation in a single transaction; Using the CREATE WITH ERROR support; Using the soft invalidation and automatic revalidation support; Using the ALTER COLUMN SET DATA TYPE extended support; Using the new TRUNCATE statement; Using AUTONOMOUS transactions
Using implicit casting during application enablementUsing the DEFAULT values and NAMED arguments in procedures; Chapter 2: DB2 Application Techniques; Introduction; Granting and revoking instance-level authorities; Granting and revoking database-level authorities; Granting and revoking object privileges; Implementing static SQL in DB2; Implementing dynamic SQL in DB2; Creating Declared Global Temporary Tables (DGTTs); Using XML in a declared temporary table; Improving performance by creating indexes on a DGTT; Creating created global temporary tables (CGTT); Using generated columns in tables Creating a savepointRolling back to a savepoint; Using savepoints in JDBC; Using savepoints in SQLJ; Creating a sequence object; Modifying a sequence object; Referencing a sequence object; Chapter 3: General Application Design; Introduction; Improving concurrency by using a connection concentrator; Using trusted contexts for improved security; Using trusted connections in JDBC; Using trusted connections in PHP; Securing data by using DB2 encryption; Improving concurrency by using enhanced optimistic locking; Working with user-defined types (UDT); Working with structured types Chapter 4: Procedures, Functions, Triggers, and ModulesIntroduction; Creating a simple stored procedure; Using dynamic SQL in stored procedures; Working with result sets in stored procedures; Using ARRAY objects in stored procedures; Handling errors in stored procedures; Designing external stored procedures; Using PL/SQL exception handling in a procedure; Working with the message buffer in stored procedures; Planning and designing triggers; Using scalar user-defined functions; Writing external user-defined functions; Designing external table functions; Working with modules in DB2 Chapter 5: Designing Java ApplicationsIntroduction; Creating connection objects in JDBC applications; Creating connection objects in SQLJ applications; Manipulating XML Data in Java applications; Batch processing in JDBC applications; Batch processing in SQLJ applications; Working with scrollable result sets; Handling errors and warnings in JDBC applications; Developing Java applications for high availability; Using SSL in Java applications; Chapter 6: DB2 9.7 Application Enablement; Introduction; First step towards enabling Oracle application to DB2 9.7; Using ROWNUM and DUAL in DB2 9.7 Using CUR_COMMIT concurrency control isolation level |
Record Nr. | UNINA-9910789949903321 |
Kumar Sanjay | ||
Birmingham, U.K., : Packt Pub., 2012 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
IBM DB2 9.7 advanced application developer cookbook / / Sanjay Kumar, Mohankumar Saraswatipura |
Autore | Kumar Sanjay |
Edizione | [1st edition] |
Pubbl/distr/stampa | Birmingham, U.K., : Packt Pub., 2012 |
Descrizione fisica | 1 online resource (442 p.) |
Disciplina | 005.7565 |
Altri autori (Persone) | SaraswatipuraMohankumar |
Soggetto topico |
Relational databases
Database management |
ISBN |
1-280-12733-3
9786613531216 1-84968-397-2 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Application Development Enhancements in DB2 9.7; Introduction; Changing column names online using the ALTER TABLE operation; Using the CREATE OR REPLACE clause while creating objects; Using the ALTER TABLE operation in a single transaction; Using the CREATE WITH ERROR support; Using the soft invalidation and automatic revalidation support; Using the ALTER COLUMN SET DATA TYPE extended support; Using the new TRUNCATE statement; Using AUTONOMOUS transactions
Using implicit casting during application enablementUsing the DEFAULT values and NAMED arguments in procedures; Chapter 2: DB2 Application Techniques; Introduction; Granting and revoking instance-level authorities; Granting and revoking database-level authorities; Granting and revoking object privileges; Implementing static SQL in DB2; Implementing dynamic SQL in DB2; Creating Declared Global Temporary Tables (DGTTs); Using XML in a declared temporary table; Improving performance by creating indexes on a DGTT; Creating created global temporary tables (CGTT); Using generated columns in tables Creating a savepointRolling back to a savepoint; Using savepoints in JDBC; Using savepoints in SQLJ; Creating a sequence object; Modifying a sequence object; Referencing a sequence object; Chapter 3: General Application Design; Introduction; Improving concurrency by using a connection concentrator; Using trusted contexts for improved security; Using trusted connections in JDBC; Using trusted connections in PHP; Securing data by using DB2 encryption; Improving concurrency by using enhanced optimistic locking; Working with user-defined types (UDT); Working with structured types Chapter 4: Procedures, Functions, Triggers, and ModulesIntroduction; Creating a simple stored procedure; Using dynamic SQL in stored procedures; Working with result sets in stored procedures; Using ARRAY objects in stored procedures; Handling errors in stored procedures; Designing external stored procedures; Using PL/SQL exception handling in a procedure; Working with the message buffer in stored procedures; Planning and designing triggers; Using scalar user-defined functions; Writing external user-defined functions; Designing external table functions; Working with modules in DB2 Chapter 5: Designing Java ApplicationsIntroduction; Creating connection objects in JDBC applications; Creating connection objects in SQLJ applications; Manipulating XML Data in Java applications; Batch processing in JDBC applications; Batch processing in SQLJ applications; Working with scrollable result sets; Handling errors and warnings in JDBC applications; Developing Java applications for high availability; Using SSL in Java applications; Chapter 6: DB2 9.7 Application Enablement; Introduction; First step towards enabling Oracle application to DB2 9.7; Using ROWNUM and DUAL in DB2 9.7 Using CUR_COMMIT concurrency control isolation level |
Record Nr. | UNINA-9910826322403321 |
Kumar Sanjay | ||
Birmingham, U.K., : Packt Pub., 2012 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|