| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Access Service User's Guide DirectConnect |
![[-]](/dwicons/i_colpse.gif)
| About This Book |
This guide describes how to configure and use a DirectConnect(TM) for MVS 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 guide is for DirectConnect System Administrators, application programmers, or other qualified persons familiar with their system environment, resources, and devices.
This guide 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 |
Be introduced to DirectConnect products | |
Chapter 2, "Configuring the DirectConnect Access Service Library" | Configure the access service library and access service properties |
Use global variables and set statements to query and set operating values for your client connections | |
Review datatype conversions between DB2 and Open Client/Server | |
Begin the SQL request process | |
Review SQL transformation modes and cursor, dynamic, and language 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. | |
Issue SQL Server Remote Procedure Calls (RPCs) that initiate events in remote databases. | |
Review the transfer process, including transfer targets, datatype conversion for transfer processing, errors and error handling, and backward compatibility | |
Use bulk copy transfer to transfer data | |
Use destination-template transfer to transfer data | |
To obtain information about database objects, you need to access the database catalog. Catalog Stored Procedures (CSPs) provide this catalog access. This chapter describes how to use CSPs to access the DB2 catalog | |
Use system procedures | |
Chapter 14, "Remote Stored Procedures and Host-Resident requests" | Create, execute, and delete Remote Stored Procedures (RSPs) and host-resident requests |
Appendix A, "Backward compatibility with MDI Database Gateways" | Compare differences between access services and MDI Database Gateways |
Access a synopsis of information about configuration properties and how they interact in transaction management, and refer to code set information |
To install DirectConnect products and DirectConnect Manager, use the DirectConnect for MVS Installation Guide.
To configure and administer DirectConnect Server, use the DirectConnect Server Administration Guide.
To configure and administer the DirectConnect Transaction Router Service Library (TRS) and to administer Mainframe Client Connect, use the DirectConnect Transaction Router Service User's Guide.
To install and administer the other Mainframe Connect Integrated Product Set (IPS) products, use the following documents:
MainframeConnect for DB2/MVS-CICS Installation and Administration Guide
Open ServerConnect Installation and Administration Guide for IBM CICS/MVS
Open ServerConnect Installation and Administration Guide for IBM IMS TM and MVS
Open ServerConnect Programmer's Guide for Remote Stored Procedures
Open ClientConnect Installation and Administration for IBM CICS/MVS
Open ClientConnect Installation and Administration Guide for IBM IMS TM and MVS
Open ClientConnect Programmer's Guide for Client Services Applications
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 |
SQL 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.
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 guide.
Symbol | Convention |
( ) | Parentheses are 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 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 assistance to customers who pay the applicable support fees, as defined the Software License Agreement. Assistance includes the following services:
Identifying problems
Offering a fix, if available
Documenting software problems and enhancement suggestions in the Sybase customer support database
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 phone or through e-mail. Before you contact Sybase Technical Support, complete these steps:
Thoroughly review the documentation, especially all troubleshooting sections.
Be prepared to generate a trace, if Sybase Technical Support asks you to do so.
You can reach Sybase Technical Support by calling (800) 8SYBASE.
Hours are 5:00 AM to 6:30 PM, Monday through Friday, Mountain Standard or Daylight Savings Time (MST or MDT), except holidays.
Outside the continental United States and Canada, obtain the correct telephone numbers from your sales representative and record them here for future reference:______________________________.
Send an e-mail to Sybase Technical Support in the following circumstances:
If you have a general question that is not urgent, for instance, a question about configuration planning.
If you need help with a product outside of the working hours of Sybase Technical Support, you can send an e-mail to be received as soon as personnel become available.
Use this address to send e-mail to Sybase Technical Support:
icdtech@sybase.com
You can send log and trace files or other documents to Sybase Technical Support using the Sybase file transfer protocol (ftp) site or the Bulletin Board Service (BBS).
To place trace output or other documents on the Sybase ftp server:
Save your trace output as an ASCII file.
In the directory where the file resides, type ftp at the command line.
When prompted, provide the following information:
Sybase server = ftp.sybase.com
ID = anonymous
Password = your e-mail address
Type:
cd /pub/incoming/wcss
To change to binary mode, type:
bin
Place one or more files into the directory.
To place one file in the directory, type:
put filename
To place multiple files in the directory, type:
mput filename filename filename
When prompted, type Y and press Enter 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 here 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 Electronic Support Services tab, and select a link under the Technical Library heading.
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 SupportPlusSM Online 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.
|
|