Access Service User's Guide DirectConnect for AS/400

See

When You Are Ready To

Chapter 1 Understanding Enterprise Connect

Understand Enterprise Connect products and the DirectConnect for AS/400 environment

Chapter 2 Configuring the DirectConnect for AS/400 Access Service Library

Configure the access service library and access service properties

Chapter 3 Querying and Setting Operating Values

Use global variables and set statements to query and set operating values for your client connections

Chapter 4 Converting Datatypes

Review datatype conversions between AS/400 and Open Client/Server

Chapter 5 Understanding the Request Process

Begin the SQL request process

Chapter 6 Issuing SQL Statements

Review SQL transformation modes and cursor, dynamic, and language commands

Chapter 7 Using Sybase Mode Commands

Issue structured query language (SQL) commands that an access service recognizes and acts upon when the SQL transformation mode is set to Sybase mode

Chapter 8 Issuing Remote Procedure Calls

Issue Adaptive Server Remote Procedure Calls (RPCs) that initiate events in remote databases

Chapter 9 Understanding the Transfer Process

Review the transfer process, including transfer targets, datatype conversion for transfer processing, errors and error handling, and backward compatibility

Chapter 10 Using Bulk Copy Transfer

Use bulk copy transfer to transfer data

Chapter 11 Using Destination-Template Transfer

Use destination-template transfer to transfer data

Chapter 12 Accessing Catalog Information with CSPs

Code Catalog Stored Procedures (CSPs)

Chapter 13 Retrieving Information with System Procedures

Use system procedures

Chapter 14 Using AS/400 Stored Procedures

Create and use stored procedures within the AS/400

Appendix A Backward Compatibility with MDI Database Gateways

Compare differences between access services and MDI Database Gateways

Quick Reference

• Access a synopsis of information about configuration properties and how they interact in transaction management

• Review supported client and target code set tables