Contents

List of Figures

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Information
• Conventions

1 World JDBC Driver Overview

• 1.1 Java Database Connectivity
  • 1.1.1 Security Features
  • 1.1.2 Additional Features
• 1.2 Terms

2 World JDBC Driver Installation

• 2.1 System Requirements
  • 2.1.1 IBM i Server
  • 2.1.2 Client Systems
  • 2.1.3 Standards
  • 2.1.4 What You Should Know About
• 2.2 World JDBC Driver Installation
  • 2.2.1 Driver Jar Files
  • 2.2.2 Other Applications
• 2.3 JD Edwards World Database Connections
  • 2.3.1 Defining a JDBC Connection Using JDEWJDBCDriver
    • 2.3.1.1 Connection String
    • 2.3.1.2 Database Driver Class
  • 2.3.2 Defining a JDBC Connection Using a Data Source
    • 2.3.2.1 Data Source Connection Properties
    • 2.3.2.2 Database Data Source Class Name
  • 2.3.3 Identifying a JD Edwards World Environment
    • 2.3.3.1 Users with J98INIT as Initial Program
    • 2.3.3.2 Users with J98INITA as Initial Program
  • 2.3.4 JDBC Driver and Data Source Properties
    • 2.3.4.1 JD Edwards World JDBC Driver Properties
    • 2.3.4.2 IBM Toolbox for Java JDBC Properties
    • 2.3.4.3 Examples of Driver Connection Strings
  • 2.3.5 Alternate Object Reference Nomenclature
    • 2.3.5.1 Table Nomenclature Keywords
    • 2.3.5.2 Column Nomenclature Keywords
    • 2.3.5.3 Connection String or Property Options
    • 2.3.5.4 What You Should Know About Alternate Nomenclature
  • 2.3.6 Global JDBC Driver Properties
  • 2.3.7 JDBC Property Information Sources and Precedence for JDBC Connections
    • 2.3.7.1 Global Properties - (UDC 98/UD)
    • 2.3.7.2 JDBC Java VM Parameters
    • 2.3.7.3 JDBC Property Settings
    • 2.3.7.4 User Preferences (Format Properties Only)
    • 2.3.7.5 IBM System Values (Format Properties Only)
• 2.4 BI Publisher 11G JDBC Data Source Setup with WebLogic Application Server
  • 2.4.1 Install Jar Files to the WebLogic Server
  • 2.4.2 Define a Standard JDBC Data Source
  • 2.4.3 Define a Connection Pool JDBC Data Source
  • 2.4.4 Define an XA JDBC Data Source
• 2.5 BI Publisher 10G JDBC Data Source Setup on OC4J
  • 2.5.1 Install Jar Files to the OC4J Server
  • 2.5.2 Define a Standard JDBC Data Source
    • 2.5.2.1 Create a Connection Pool Definition
    • 2.5.2.2 Create a Named Data Source Instance of the Connection Pool Definition
  • 2.5.3 Define a JDBC Connection Pool Data Source

3 World JDBC Driver Administration

• 3.1 World JDBC Driver and JD Edwards World Security Features
  • 3.1.1 Action Code User Access Security
  • 3.1.2 Business Unit Security
  • 3.1.3 Field Security for Select
  • 3.1.4 File/Field Security for Insert/Update/Delete
  • 3.1.5 Action Security
• 3.2 World JDBC Driver and JD Edwards World Data-Specific Features
  • 3.2.1 Metadata Files
  • 3.2.2 Environments and Specifications

4 World JDBC Driver Data Features

• 4.1 JDBC Driver Overview
• 4.2 World JDBC Driver Data-Specific Features
  • 4.2.1 Presumptive Joins
  • 4.2.2 Data Transformations
    • 4.2.2.1 IBM i
  • 4.2.3 Identifying Tables, Columns, and Data Dictionary Items
  • 4.2.4 Decimal Position Placement
    • 4.2.4.1 Definitions of Decimal Placement
    • 4.2.4.2 JD Edwards World Data Dictionary
    • 4.2.4.3 Decimal Position Relational Expression Considerations
  • 4.2.5 Julian Date Conversion
    • 4.2.5.1 Julian Date Relational Expression Considerations
• 4.3 Other Considerations

Index