| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Access Service User's Guide DirectConnect for AS/400 |
![[-]](/dwicons/i_colpse.gif)
| Chapter 1 Introducing DirectConnect for AS/400 |
Chapter 1
This chapter provides an overview of DirectConnect for AS/400 and includes the following topics:
DirectConnect for AS/400 is a component of the Enterprise Connect Data Access IPS, which consists of components that provide access to distributed data. For more information about the Enterprise Connect Data Access IPS, see the Overview Guide for the Enterprise Connect Data Access IPS.
This section describes DirectConnect for AS/400 and other related Sybase products. This section includes the following subsections:
DirectConnect Manager is a graphical user interface (GUI) systems management tool for administering the DirectConnect configuration.DirectConnect Manager runs only on Windows 95 or Windows 98. It provides the following capabilities:
Remote start, stop, and configuration of DirectConnect services
Dynamic configuration of services
Drag-and-drop service creation and copying
Remote log filtering and downloading
Heartbeat services
DirectConnect consists of a server and one or more service libraries. The server provides the framework in which the service libraries operate. Each access service library accesses data from a particular target database, such as AS/400, DB2, Informix, ODBC, and others.The DirectConnect Anywhere Access Service Library accesses ODBC-accessible data. It consists of one or more access services that have specific sets of configuration properties.
DRDA is an IBM application-level protocol that transfers database and stored procedure requests and replies between clients and servers. A DRDA to ODBC driver is used to access the DRDA target databases.
DirectConnect for DRDA consists of a server and one or more service libraries. The server provides the framework in which the service libraries operate. Each access service library accesses data from a particular target database, such as AS/400, DB2, Informix, and others. The first release of DirectConnect for DRDA will be certified for DB2 only.The DirectConnect for DRDA Access Service Library accesses DRDA-accessible data. It consists of one or more access services that contain specific sets of configuration properties.
DirectConnect for Informix is a Sybase product that provides basic connectivity to non-Sybase data sources. In particular, it provides access management, copy management, and remote systems management.
DirectConnect for Informix consists of a DirectConnect Server, DirectConnect for Informix Service Libraries, and DirectConnect for Informix Services.
The DirectConnect Server routes incoming client requests and provides a set of support functions that includes logging, tracing, and message handling. You can use it to add and delete services, configure service properties, and manage other features.
Each DirectConnect for Informix Service Library provides a specific function. The server provides the framework within which the service libraries operate.
DirectConnect for MSS consists of a server and one or more service libraries. The server provides the framework in which the service libraries operate. Each access service library accesses data from a particular target database, such as AS/400, DB2, Informix, ODBC, and so forth.
The DirectConnect for Microsoft SQL Server Access Service Library accesses ODBC-accessible data. It consists of one or more access services that are specific sets of configuration properties.
DirectConnect for AS/400 is Open Server-based software that supports DB-Library, CT-Library, and Open Database Connectivity (ODBC) application programming interfaces (APIs).
DirectConnect for AS/400 consists of a server and one or more service libraries. The server provides the framework in which the service libraries operate.
In addition, DirectConnect provides access to non-Sybase data and can be used with other Sybase products, such as ASE/CIS (formerly OmniConnect), Sybase Adaptive Server, and Replication Server.
The access service library, the program component of DirectConnect for AS/400 that accesses AS/400 data, consists of one or more access services. The following figure shows the relationship of DirectConnect for AS/400 access service library and its access services with the components of the client workstation, LAN, and AS/400 environment.
This guide contains information about access service libraries, and how you configure properties in the access services to access and retrieve AS/400 data in the format you need.
An access service provides access to non-Sybase data sources, such as the AS/400. It is a logical server application, used with an access service library, to which clients connect. As shown in Figure 1-1 , each DirectConnect Server can have multiple access services.
An access service:
Transforms SQL
Converts datatypes
Supports RPCs
Transfers data between the AS/400 and other servers, if the servers are accessible through Open Client
Supports Catalog Stored Procedures (CSP) and system stored procedures
Supports AS/400 stored procedures
Using DirectConnect Manager for Microsoft Windows NT, Windows 95, and Windows 98, you can dynamically configure access service configuration properties, instead of editing the access service library configuration file.
The following figure shows the relationship between the access service libraries, the DirectConnect server, AS/400, and the AS/400 database.
Figure 1-1: DirectConnect for AS/400 environment
Globalization consists of internationalization and localization of messages.
Internationalization consists of character code set conversion and cultural formatting.
Character code set conversion is the process of converting the hexadecimal representation of a character from a code set in a target database to a code set in a client application, or the reverse. DirectConnect for AS/400 provides the ability to convert code sets.
Cultural formatting involves designating decimal separators, monetary signs, date and time separators, and a three-digit grouping symbol. Cultural formatting in DirectConnect for AS/400 is performed through the use of configuration properties.
Supported character setsThe Unicode Library supports the following character sets:
Belgium
Canada
Denmark/Norway
EURO symbol
France
Germany
Italy
Japan
Sweden/Finland
Switzerland
UK
USA
For a list of the supported code sets, see Appendix B, "Quick Reference."
For current information on certified character code sets, check the Sybase Web site or contact your local Sybase office. To request certification for a new character code set, contact your local Sybase office.
Supported date and time formatsTo facilitate internationalization, the access service can be set to return dates and time in any one of the following formats:
char_iso: yyyy-mm-dd-hh.mm.ss.nnnnnn
char_usa: mm/dd/yyyy hh:mm PM
char_eur: dd.mm.yyyy hh.mm.ss
char_jis: yyyy-mm-dd hh:mm:ss
char_odbc: yyyy-mm-dd hh:mm:ss.nnnnnn
Two sets of messages can be localized:
Messages generated by the target database manager and passed to the client application without change
Messages generated in DirectConnect for AS/400
Database manager messages are not localized by DirectConnect for AS/400. For information on how to set up localization of such messages, see your database manager documentation.
If you wrote client applications for MDI Database Gateways, you can still use those applications with DirectConnect.
Warning!
To ensure compatibility with your client applications and DirectConnect, read Appendix A, "Backward compatibility with MDI database gateways" before you configure the access service library.
|
|