| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Access Service User's Guide DirectConnect for AS/400 |
![[-]](/dwicons/i_colpse.gif)
| About This Book |
This guide describes how to configure and use a DirectConnect for AS/400(TM) Access Service, including information about datatype conversion, request processing, data transfer, and stored procedures.
This guide also provides information about compatibility with MDI Database Gateways.
This section includes the following topics:
This book is for DirectConnect System Administrators, application programmers, or other qualified persons who are familiar with their system environment, resources, and devices.
This book describes a set of tasks, with each chapter representing a task. The following table shows how this book is organized.
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 |
|
To install DirectConnect for AS/400 and DirectConnect Manager, use the DirectConnect Installation Guide for Enterprise Connect Data Access IPS.
For explanations of DirectConnect error messages, see the DirectConnect Error Message Guide.
For additional references, use the following documents:
Open Client and Open Server Common Libraries Reference Manual
Open Client Client-Library/C Programmer's Guide
Open Client Client-Library/C Reference Manual
Open Client DB-Library/C Reference Manual
Open Server Server-Library/C Reference Manual
This book uses the following style conventions:
This type of information | Looks like this |
Gateway-Library function names | TDINIT, TDCANCEL |
Client-Library function names | CTBINIT, CTBCANCEL |
Other executables (DB-Library routines, SQL commands) in text | the dbrpcparam routine, a select statement |
Directory names, path names, and file names | /usr/bin directory, interfaces file |
Variables | n bytes |
Adaptive Server datatypes | datetime, float |
Sample code | 01 BUFFER PIC S9(9) COMP SYNC |
User input | 01 BUFFER PIC X(n) |
Client-Library and Gateway-Library function argument names | BUFFER, RETCODE |
Names of objects stored on the mainframe | SYCTSAA5 |
Symbolic values used with function arguments, properties, and structure fields | CS_UNUSED, FMT_NAME, CS_SV_FATAL |
Client-Library property names | CS_PASSWORD, CS_USERNAME |
Client-Library and Gateway-Library datatypes | CS_CHAR, TDSCHAR |
All other names and terms are in regular typeface.
Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you cannot resolve a problem using the manuals or online help, please have the designated person contact Sybase Technical Support or the Sybase subsidiary in your area.
If you need help using a Sybase product, the following resources are available:
Sybase Technical Support
Sybase Professional Services
Other sources of information
Sybase Technical Support provides various forms of customer assistance, including the following services:
Identifying problems.
Offering a fix, if available.
Documenting software problems and enhancement suggestions in our customer support database.
Communicating status information on open problems.
Sharing information on new products or releases of existing products.
In addition, Sybase system engineers are available for technical assistance in various geographical territories.
The following subsections explain how to contact Sybase Technical Support and how to send log and trace files, if necessary.
Contacting Sybase Technical SupportYou can contact Sybase Technical Support by calling (800) 8SYBASE. Before you contact Sybase Technical Support, complete these steps:
Thoroughly review the documentation, especially all troubleshooting sections.
Be prepared to generate a trace, if requested to do so by Technical Support.
Outside the continental United States and Canada, obtain the correct telephone numbers from your sales representative and record them for future reference.
Sending log and trace files to Sybase Technical SupportYou can send log and trace files or other documents to Sybase Technical Support using the Sybase file transfer protocol.
Save your trace output as an ASCII file.
In the directory in which the file resides, type the following at the command line:
ftp
When prompted, provide the following information:
Sybase server = ftp.sybase.com
ID = anonymous
Password = your e-mail address
Type the following:
cd /pub/incoming/wcss
To change to binary mode, type the following:
bin
Place one or more files into the directory as follows.
To place one file in the directory, type the following:
put filename
To place multiple files in the directory, type the following:
mput filename filename filename
When prompted, enter Y to transfer each file.
Notify Sybase Technical Support of the exact name of the file(s) you sent to the server. (Remember that the UNIX system is case-sensitive.
Sybase Professional Services offers on-site consulting and training programs to help you maximize the benefits of our products. For more information, call (303) 486-7700.
Outside the continental United States and Canada, obtain the correct telephone numbers from your sales representative and record them for future reference.
If you have any questions, comments, or suggestions about this book, contact the Sybase documentation group directly by electronic mail at:
icd_doc@sybase.com
Feel free to forward any information, comments, or questions about:
Missing, incorrect, or unclear information
Information you found particularly useful
Organization or style
We will respond as promptly as possible by electronic mail. Your feedback helps us provide more accurate, detailed, and easy-to-use documentation.
Please send comments about product features, functionality, or problems to your system engineer or Sybase Technical Support.
To order additional copies of Sybase documentation, see "Document Orders" on the disclaimer page following the title page.
|
|