| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Access Service User's Guide DirectConnect for DRDA |
![[-]](/dwicons/i_colpse.gif)
| About This Book |
This book describes how to install, configure and use a DirectConnect for DRDA Access Service, including information about datatype conversion, request processing, data transfer, and stored procedures.
This chapter includes the following topics:
This guide is for System Administrators, application programmers, or other qualified persons familiar with their system environment, resources, and devices.
This book covers the following topics:
Chapter 1, "Introducing DirectConnect for DRDA" introduces the product and describes the globalization process.
Chapter 2, "Configuring the DirectConnect Access Service library" tells how to configure access service library and access service properties.
Chapter 3, "Querying and setting operating values" explains how to use global variables and set statements to query and set operating values for your client connections.
Chapter 4, "Converting Datatypes" describes datatype conversions between ODBC and Open Client/Server(TM).
Chapter 5, "Managing transactions" describes the transaction management processing flow and explains how to configure properties to manage the process.
Chapter 6, "Issuing SQL statements" describes SQL transformation modes and standard transformations for SQL commands.
Chapter 7, "Using Sybase mode commands" describes SQL commands that the DirectConnect for DRDA Access Service recognizes in sybase mode.
Chapter 8, "Understanding the transfer process" describes several concepts of the transfer process.
Chapter 9, "Using Bulk Copy transfer" describes how to use bulk copy transfer, including syntax statements and error handling.
Chapter 10, "Using Destination-Template transfer" explains how to use destination-template transfer, including syntax statements and error handling.
Chapter 11, "Accessing catalog information with CSPs" provides a description and reference for supported catalog stored procedures.
Chapter 12, "Retrieving information with System Procedures" provides a description and reference for supported system procedures.
Chapter 13, "Using DB2 Stored Procedures" describes stored procedures and rules for using them.
Appendix A, "Configuration property Quick Reference" contains a quick reference table for configuration properties.
The glossary provides definitions of technical terms used in this guide.
To install, configure and administer DirectConnect for DRDA products, use the following guides that are available on the Technical Library CD (included with the product):
DirectConnect Installation Guide for the Enterprise Connect Data Access IPS
DirectConnect Server Administration Guide
DirectConnect Error Message Guide
For ODBC information, use the following document:
Microsoft ODBC 3.5 Programmer's Reference and SDK Guide
For additional references, use the following documents:
Open Client-Library/C Reference Manual
Open Client DB-Library/C Reference Manual
Open Server-Library/C Reference Manual
Installing Open Client/Server (by platform)
Sybase Adaptive Server Reference Manual, v 1
Sybase Adaptive Server Reference Manual, v 2
The following sections describe style and syntax conventions used in this book.
This book uses the following style conventions:
The names of files and directories are shown as:
econnect\ServerName\CFG
The names of programs, utilities, procedures, and commands are shown as:
the set statement
The names of properties are shown as:
Allocate
The names of options are shown as:
connect
Code examples and text on screen are shown as:
** Prepare the statement.
In a sample command line display, commands you should enter are shown as:
Allocate=connect
In a sample command line display, variables (which are words you should replace with the appropriate value for your system) are shown as:
ClientIdleTimeout=integer
Syntax statements that display options for a command look like this:
sp_columns table_name [, table_owner] [, table_qualifier] [, column_name]
The following table explains the syntax conventions used in this book.
Symbol | Convention |
( ) | Include parentheses as part of the command. |
{ } | Braces indicate that you must choose at least one of the enclosed options. Do not type the braces when you type the option. |
[ ] | Brackets indicate that you can choose one or more of the enclosed options, or none. Do not type the brackets when you type the options. |
| | The vertical bar indicates that you can select only one of the options shown. Do not type the bar in your command. |
, | The comma indicates that you can choose one or more of the options shown. Separate each choice by using a comma as part of the command. |
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 have any questions about this installation or need assistance during the installation process, 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
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 onsite 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.
Use the Sybase Technical Library CD and the Technical Library Web site to learn more about your product:
The Technical Library CD contains product manuals and technical documents and is included with your software. The DynaText browser (included on the Technical Library CD) allows you to access technical information about your product in an easy-to-use format.
Refer to the Technical Library Installation Guide in your documentation package for instructions on installing and starting the Technical Library.
The Technical Library Web site includes the Product Manuals site, which is an HTML version of the Technical Library CD that you can access using a standard Web browser. In addition, you'll find links to the Technical Documents Web site (formerly known as Tech Info Library), the Solved Cases page, and Sybase/Powersoft newsgroups.
To access the Technical Library Web site, go to support.sybase.com, click the Manuals tab, select a link to a product family - Middleware, and select a link to DirectConnect. Select your document.
Technical documentation at the Sybase Web site is updated frequently.
Point your Web browser to Technical Documents at the following Web site:
techinfo.sybase.com
In the Browse section, click on the What's Hot entry.
Explore your area of interest: Hot Docs covering various topics, or Hot Links to Technical News, Certification Reports, Partner Certifications, and so on.
Point your Web browser to Technical Documents at the following Web site:
techinfo.sybase.com
In the Browse section, click on the What's Hot entry.
Click on the EBF Rollups entry.
You can research EBFs using Technical Documents, and you can download EBFs using Electronic Software Distribution (ESD).
Follow the instructions associated with the SupportPlusSMOnline Services entries.
You can register by following the instructions on the Web.
To use SupportPlus, you need:
A Web browser that supports the Secure Sockets Layer (SSL), such as Netscape Navigator 1.2 or later
An active support license
A named technical support contact
Your user ID and password
You may access Sybase Technical Documents or Certification Reports at this site:
Point your Web browser to Technical Documents at the following Web site:
techinfo.sybase.com
In the Browse section, click on the What's Hot entry.
Click on the topic that interests you.
To order additional copies of DirectConnect documentation, see "Document Orders" on the disclaimer page following the title page.
If you have questions, comments, or suggestions about DirectConnect documentation, 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.
|
|