Franklin

DB2 for z/OS and OS/390 : Ready for Java.

Other records:
Author/Creator:
Redbooks, IBM.
Publication:
Durham : I B M, 2003.
Format/Description:
Book
1 online resource (368 pages)
Subjects:
WebSphere.
Client/server computing.
Form/Genre:
Electronic books.
Contents:
Front cover
Contents
Figures
Tables
Examples
Notices
Trademarks
Preface
The team that wrote this redbook
Become a published author
Comments welcome
Summary of changes
December 2004
Part 1 Introduction
Chapter 1. A brief history of Java
1.1 From toaster to the enterprise
1.1.1 Java and the consumer electronics revolution
1.1.2 Accessing the data
1.1.3 The rise of the Internet server
1.1.4 The Internet and the enterprise
1.2 Java and the z/OS and OS/390 platforms
Chapter 2. An introduction to Java 2 Enterprise Edition
2.1 The three technology editions for the Java 2 platform
2.2 Java 2 Platform, Enterprise Edition
2.3 Java 2 features
2.3.1 Object-oriented programming
2.3.2 Primitive data types
2.3.3 Garbage collection
2.3.4 Removal of pointers
2.3.5 No more GOTOs
2.3.6 Java Virtual Machine
2.4 Java application environments
2.4.1 Stand-alone Java applications
2.4.2 Java applets
2.4.3 Java Servlets
2.4.4 JavaServer Pages
2.4.5 JavaScript
2.4.6 Java Beans
2.4.7 Enterprise Java Beans
Chapter 3. Accessing DB2 from Java
3.1 JDBC basics
3.1.1 JDBC driver types
3.1.2 The IBM DB2 Universal Driver for SQLJ and JDBC
3.2 Different ways to connect to a DB2 for z/OS and OS/390
3.2.1 Direct (T2) connection to a local DB2 subsystem
3.2.2 Using the Type 4 driver to talk to a local DB2 for z/OS and OS/390
3.2.3 Type 4 connectivity from a non-z/OS platform
3.2.4 Type 2 connectivity from a non-z/OS platform
3.2.5 DB2 for z/OS and OS/390 as a DRDA Application Requester
3.2.6 IBM z/OS Application Connectivity to DB2 for z/OS and OS/390
3.3 Developing a Java application using JDBC
3.3.1 Connecting to a database
3.3.2 Using the DriverManager interface
3.3.3 Connecting using the DataSource API.
3.4 Accessing data using SQLJ
3.5 Using JDBC or SQLJ
3.5.1 SQLJ is easier to code
3.5.2 SQLJ catches errors sooner
3.5.3 SQLJ is faster
3.5.4 SQLJ provides better authorization control
3.5.5 SQLJ is more predictable and reliable
3.5.6 SQLJ allows for better monitoring
3.5.7 SQLJ Tooling
3.5.8 Use JDBC for flexible SQL statements
3.5.9 SQLJ/JDBC interoperability
3.6 Summary
Part 2 Prerequisites and setup
Chapter 4. Products and levels - Now and soon
4.1 Products and levels
4.1.1 Now
4.1.2 Soon
Chapter 5. Setup
5.1 DB2 for OS/390 and z/OS V7
5.1.1 Installing DB2 SQLJ/JDBC support
5.1.2 Installing the Universal Driver on a z/OS or OS/390 platform
5.1.3 Required DB2 for z/OS changes to enable the Universal Driver
5.2 Workload Manager (WLM)
5.3 Unix System Services
5.3.1 Setting up a USS session
5.3.2 Setting up the JDBC/SQLJ environment variables
5.4 DB2 Universal Driver - Setup for a Windows environment
5.5 WSAD setup
5.5.1 Using the data perspective
5.6 WebSphere for z/OS datasource setup
5.6.1 Log onto the WAS Administrative Console
5.6.2 Setting up system variables
Part 3 Putting it all together
Chapter 6. Getting started with JDBC
6.1 Creating the project
6.1.1 Loading the JDBC driver
6.1.2 Establishing the connection
6.1.3 Preparing an SQL statement for execution
6.1.4 Populating parameter markers
6.1.5 Executing the statement
6.1.6 Processing the result set
6.1.7 Cleaning up resources
6.2 Running the Hello application from WSAD
6.2.1 Creating the launch configuration
6.2.2 Setting up the classpath
6.2.3 Troubleshooting
6.3 Running the Hello application from Unix System Services
6.3.1 Exporting to a shared file system
6.3.2 Exporting via FTP
6.3.3 Running the program.
6.4 Running a Java program from a Windows command prompt
6.4.1 Compile the Java program (javac)
6.4.2 Run the Java program (java)
6.5 Debugging the application on the workstation
6.6 Remote debugging
Chapter 7. JDBC revisited
7.1 INSERT, UPDATE and DELETE statements
7.1.1 INSERT
7.1.2 UPDATE
7.1.3 DELETE
7.2 NULL handling
7.3 Examining result sets
7.4 Database metadata
7.4.1 Information about the JDBC driver
7.4.2 Information about the database server
7.4.3 Information about database objects
7.5 Positioned UPDATE and DELETE
7.5.1 Positioned UPDATE
7.5.2 Positioned DELETE
7.6 Large objects (LOBs)
7.7 Scrollable cursors
7.8 A complete example: Poor man's SPUFI
Chapter 8. Getting started with SQLJ
8.1 Creating the source file
8.2 Running the Hello application from WSAD
8.2.1 Creating the launch configuration
8.2.2 Specifying command line parameters
8.3 Running the Hello application from Unix System Services
8.4 Running the Hello application from MVS batch
Chapter 9. The SQLJ program preparation process
9.1 Program preparation in other languages
9.2 Overview of the SQLJ program preparation process
9.2.1 The SQLJ translator
9.2.2 More about profiles
9.3 The DB2 profile customizer
9.3.1 Isolation levels
9.3.2 Why online checking is good for you
9.4 The DB2 profile binder
9.5 The DB2 profile printer
9.6 Preparing an application to use static SQL
9.6.1 Preparing SQLJ programs to use static SQL through WSAD
9.6.2 Doing it yourself - Manual program preparation for static SQLJ
9.6.3 Running your sqlj program locally on a DB2 for z/OS system
9.6.4 In summary
Chapter 10. SQLJ tutorial and reference
10.1 The basic syntax of SQLJ statements
10.1.1 Executable statements
10.1.2 Iterator declarations.
10.2 Host variables and expressions
10.3 Null values
10.4 Data type mapping
10.5 Queries, iterators, and the assignment statement
10.5.1 Using positioned iterators
10.5.2 Using named iterators
10.5.3 SQLJ iterators versus cursors
10.5.4 Holdable iterators
10.5.5 Positioned UPDATE and DELETE
10.5.6 Calling stored procedures
10.6 Connection contexts
10.6.1 Setting up and using an implicit connection context
10.6.2 Why the connection context is important
10.6.3 Declaring a context class
10.6.4 Creating an instance of the context class
10.6.5 Specifying which connection instance to use
10.6.6 Using more than one context class
10.6.7 Summary of ConnectionContext methods
10.7 Execution contexts
10.8 Interoperability between JDBC and SQLJ
10.8.1 Converting a JDBC result set into an SQLJ iterator
10.8.2 Converting an SQLJ iterator into a JDBC result set
Chapter 11. SQLJ revisited
11.1 Introduction
11.2 Creating the Employee class
11.2.1 Implementing attributes, accessors, and constructors
11.2.2 Implementing the constructor to create new employees
11.2.3 Implementing the insert() method
11.2.4 Creating a test driver
11.2.5 Verifying that the program worked
11.2.6 Implementing the findByPrimaryKey() method
11.2.7 Implementing the delete() method
11.2.8 Implementing the update() method
11.2.9 Implementing the findAll() method
11.2.10 Working with LOB data: The getPicture() and setPicture() methods
Chapter 12. The DB2 Universal Driver
12.1 What the DB2 Universal Driver for SQLJ and JDBC is
12.2 Setting connection properties in the URL
12.3 Functionality enhancements
12.3.1 Scrollable cursor support
12.3.2 Batch updates
12.3.3 Improved security for DB2 authentication
12.3.4 Improved Java SQL error information.
12.3.5 Java API for Set Client Information (SQLESETI)
12.3.6 Java API for application monitoring
12.3.7 Native DB2 server SQL error messages
12.3.8 Multiple open cursors
12.3.9 SAVEPOINT support
12.3.10 Auto-generated keys
Chapter 13. Performance topics
13.1 General performance recommendations
13.1.1 Use static SQL wherever possible
13.1.2 Turn auto commit off
13.1.3 Only retrieve/update columns as needed
13.1.4 Store numbers as numeric data types
13.1.5 Use DB2 built-in functions
13.1.6 Release resources
13.2 JDBC recommendation
13.3 SQLJ performance considerations
13.3.1 Use matching data types
13.3.2 Use positioned iterators, not named iterators
13.3.3 Always customize with online checking enabled
13.3.4 Check explain tables
13.3.5 Rebind packages regularly
13.4 System-level performance tuning
13.4.1 Tune the JVM heap size
13.4.2 Get the latest code and maintenance
13.4.3 Turn on DB2 dynamic statement caching
Chapter 14. Error handling and diagnosis
14.1 Basic error handling
14.2 SQLCODE and SQLSTATE
14.3 Cleaning up resources
14.4 DB2 specific error handling
14.5 Tracing
14.5.1 Turning on tracing in the program
14.5.2 Turning on tracing using connection properties
Part 4 Accessing DB2 from Web applications
Chapter 15. Using Servlets to access DB2
15.1 Creating the project
15.2 Creating the EmployeeList Servlet
15.2.1 Implementing the doGet() method
15.2.2 Testing the Servlet
15.2.3 Displaying the employee list
15.3 Running the completed EmployeeList Servlet
15.4 Creating the EmployeeDetail Servlet
15.5 Creating the EmployeePic Servlet
15.6 Putting it together
15.6.1 Modifying the EmployeeList Servlet
15.6.2 Modifying the EmployeeDetail and EmployeePic Servlets.
15.6.3 Using EmployeePicServlet from EmployeeDetailServlet.
Notes:
Description based on publisher supplied metadata and other sources.
Local notes:
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2021. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Other format:
Print version: Redbooks, IBM DB2 for z/OS and OS/390
ISBN:
9780738427850
OCLC:
137342136
Loading...
Location Notes Your Loan Policy
Description Status Barcode Your Loan Policy