Home

	Expand Search

Access Service User's Guide DirectConnect for DRDA

Glossary

Glossary

A DirectConnect feature that provides connectivity to non-Sybase targets.

The named set of properties, used with a DirectConnect Access Service Library, to which clients connect. Each DirectConnect Server can have multiple services.

A component of DirectConnect. A service library that provides access to non-Sybase data contained in a database management system or other type of repository. Each such repository is called a "target." Each access service library interacts with exactly one target and is named accordingly. See also service library.

See access service library.

The server in the Sybase Client-Server architecture. It manages multiple databases and multiple users, tracks the actual location of data on disks, maintains mapping of logical data description to physical data storage, and maintains data and procedure caches in memory.

A service library that provides remote management capabilities and server-side support. It supports a number of remote procedures (invoked as RPC requests) that enable remote DirectConnect management. See also remote procedure call and service library.

See administrative service library.

The standard code used for information interchange among data processing systems, data communication systems, and associated equipment. The code uses a coded character set consisting of seven-bit coded characters (eight bits including a parity check).

See application program interface.

A functional interface, supplied by an operating system or other licensed program, that allows an application program written in a high-level language to use specific data or functions of the operating system or the licensed program.

See American Standard Code for Information Interchange.

Adaptive Server Enterprise / Component Integration Services (formerly OmniConnect). An add-on product for Adaptive Server that provides a Transact-SQL interface to external data sources, including host data files and tables in other database systems. OmniConnect replaces OmniSQL Gateway and OmniSQL Server. The CIS functionality of ASE has replaced OmniConnect and is referred to as ASE/CIS.

A transfer method in which multiple rows of data are inserted into a table in the target database. See also transfer. Compare with destination-template transfer.

A programming style that calls database functions directly from the top level of the code. Usually it is contrasted with embedded SQL. See also dynamic SQL and embedded SQL.

A system table that contains information about objects in a database, such as tables, views, columns, and authorizations.

A stored procedure that provides information about tables, columns, and authorizations. It is used in SQL generation and application development. See also stored procedures.

A set of specific (usually standardized) characters with an encoding scheme that uniquely defines each character. ASCII is a common character set.

Component Integration Services (formerly Omni) within ASE

See call level interface.

In client/server systems, the part of the system that sends requests to servers and processes the results of those requests. See also client/server. Compare with server.

Software that is responsible for the user interface, including menus, data entry screens, and report formats. See also client/server.

A library of routines that is part of Open ClientConnect(TM). See also Open ClientConnect.

An architecture in which the client is an application that handles the user interface and local data manipulation functions, while the server provides data processing access and management for multiple clients. See also client, client application, and server.

An index in which the physical order and the logical (indexed) order is the same. Compare with nonclustered index.

See character set.

An instruction to a database to make permanent all changes made to one or more database files since the last commit or rollback operation and to make the changed records available to other users. Compare with rollback.

A means of grouping file operations that allows a group of database changes to be processed as a single unit, or the removal of a group of database changes as a single unit. See also commit, rollback.

A file that specifies the characteristics of a system or subsystem.

A grouping into which service library configuration files are divided.

Information required to make an Open ClientConnect or Open ServerConnect(TM) connection. The connection specification consists of the server name, platform, Net-Library(TM) driver name, and address information required by the Net-Library driver being used.

The transformation between values that represent the same data item but which belong to different datatypes. Information can be lost due to conversion because accuracy of data representation varies among different data types.

See catalog stored procedure.

See Client-Library.

A language for describing data and data relationships in a database.

A computer-based system for defining, creating, manipulating, controlling, managing, and using databases.

A keyword that identifies the characteristics of stored information on a computer.

A Sybase and Microsoft API that allows client applications to interact with ODS applications. See also application program interface.

See database management system.

See data definition language.

A transfer method in which source data is briefly put into a template where the user can specify that some action be performed on it before execution against a target database. See also transfer. Compare with bulk copy transfer.

A type of service name resolution that relies upon a client application specifying the exact name of the service to be used. See also service name resolution. Compare with service name redirection.

A Sybase Open Server application that provides access management for non-Sybase databases, copy management, and remote systems management. Each DirectConnect consists of a server and one or more service libraries to provide access to a specific data source. DirectConnect replaces the MDI Database Gateway(TM) and the OmniSQL Access Module(TM).

A Sybase application for Microsoft Windows that provides remote management capabilities for DirectConnect products. These capabilities include starting, stopping, creating, and copying services.

The component that provides general management and support functions (such as log file management) to service libraries.

A named set of properties, used with a DirectConnect Service Library, to which clients connect.

The component that provides a set of functions within the DirectConnect Server environment.

See dynamic link library.

DRDA is an IBM aplication-level protocol that transfers database and stored procedure requests and replies, between clients and servers.

A file containing executable code and data bound to a program at load time or run time, rather than during linking. The code and data in a dynamic link library can be shared by several applications simultaneously.

A term pertaining to the preparation and processing of SQL source statements within a program while the program runs. The SQL source statements are contained in host-language variables rather than coded directly into the application program. Compare with static SQL.

A SQL statement embedded within a source program and prepared before the program executes. After it is prepared, the statement itself does not change, although values of host variables specified within the statement can change.

A device that processes requests and manages client communication.

System-defined variables that DirectConnect or the client application updates on an ongoing basis.

The combination of internationalization and localization. See also internationalization, localization.

An operating system file that must be available on each machine from which connections to DirectConnect for DRDA or other Sybase products are made. Each entry in the file determines how the host client software connects to the Sybase product.

The process of extracting locale-specific components from the source code and moving them into one or more separate modules, making the code culturally neutral so it can be localized for a specific culture. See also globalization. Compare with localization.

A word or phrase reserved for exclusive use by Transact-SQL.

The process of preparing an extracted module for a target environment, in which messages are displayed and logged in the user's language. Numbers, money, dates, and time are represented using the user's cultural convention, and documents are displayed in the user's language. See also globalization. Compare with internationalization.

An MDI legacy product that gives client applications access to supported data sources, such as AS/400 and DB2.

A Sybase product that lets PC applications become clients of Adaptive Server or Open Server. See also client, Open Server.

An index that stores key values and pointers to data. Compare with clustered index.

See Open Database Connectivity.

See Open Data Services.

See ASE/CIS.

A Sybase product that provides customer applications, third-party products, and other Sybase products with the interfaces required to communicate with Open Server and Open Server applications.

A Sybase product that provides capability for the mainframe to act as a client to LAN-based resources.

A product that provides a framework for creating server applications that respond to DB-Library clients. See also DB-Library.

A Microsoft API that allows access to both relational and nonrelational databases.

A Sybase product that provides the tools and interfaces required to create a custom server.

A Sybase product that provides capability for programmatic access to mainframe data.

A variable with a constant value for a specified application that can denote the application. Compare with property.

Sybase publications that certify third-party or Sybase products to work with other Sybase products.

The maximum number of digits that can be represented in a decimal, numeric, or float column.

The number of digits to the left of the decimal point.

In transfer processing, the database accessed by the access service in a transfer statement. Compare with secondary database.

A setting for a server or service that defines characteristics, such as how events are logged or how datatypes are converted. Compare with parameter.

A set of rules that governs the behavior of the computers communicating on a network.

The part of the Windows NT operating system that holds configuration information for a particular machine.

Operators supported in search conditions.

See relational operators.

A stored procedure executed on a different server from the one onto which a user is logged or on which the initiating application resides.

A feature that allows a System Administrator to manage multiple DirectConnect Servers and multiple services from a client.

One or more database operations an application sends as a unit to the database. During a request, the application gives up control to the DBMS and waits for a response. See also commit, rollback, and unit of work.

An instruction to a database not to implement the changes requested in a unit of work and to return to the pretransaction state. See also transaction and unit of work. Compare with commit.

See remote procedure call.

The maximum number of digits that can be stored to the right of the decimal point by a numeric or decimal datatype.

The connection specified in the transfer statement. It represents anything that can be accessed using Open ClientConnect, such as Adaptive Server or another access service.

In transfer processing, the supported database that is specified in the transfer statement. Compare with primary database.

A functional unit that provides shared services to clients over a network. See also client/server. Compare with client.

A positive integer that uniquely identifies a client connection to the server.

A functionality available to DirectConnect applications. It is the pairing of a service library and a set of specific configuration properties.

A set of configuration properties that determines service functionality. Examples of service libraries include access service libraries and administrative service libraries. See also access service library and administrative service library.

A type of service name resolution that allows a System Administrator to map alternative connections to services. See also service name resolution. Compare with direct resolution.

The default name of the file used for the service name redirection feature. See also service name redirection.

The DirectConnect Server mapping of an incoming service name to an actual service. See also direct resolution, service name redirection.

See service name redirection file.

See server process ID.

See structured query language.

A set of variables used in the processing of SQL statements.

A single SQL statement that is statically bound to the database. See also stored procedures.

See SQL descriptor area.

A utility for creating and editing sql.ini files and file entries.

The interfaces file containing definitions for each DirectConnect Server to which a workstation can connect. See also interfaces file.

A single SQL operation, such as select, update, or delete.

SQL statements that are embedded within a program and prepared before the program runs. The statement itself does not change, although values of host variables specified by the statement can change. Compare with dynamic SQL.

A collection of SQL statements and optional control-of-flow statements stored under a particular name. See also Catalog Stored Procedure, SQL stored procedure, and system stored procedure.

An IBM industry-standard language for processing data in a relational database.

See Adaptive Server.

The user in charge of server system administration. For DirectConnect, the user responsible for installing and maintaining DirectConnect Servers and DirectConnect Service Libraries.

A Sybase-supplied store procedure that returns information about the access service and the target database. See also stored procedures.

An array of data or a named data object that contains a specific number of unordered rows. Each item in a row can be identified unambiguously by means of one or more arguments.

An application-level protocol that Sybase clients and servers use to communicate.

A system, program, or device that interprets and replies to requests received from a source.

The database to which DirectConnect transfers data or performs operations on specific data.

See Tabular Data Stream.

An exchange between a program on a local system and a program on a remote system that accomplishes a particular action or result.

A Sybase enhanced version of the SQL database language used to communicate with Adaptive Server.

A DirectConnect feature that allows users to move data or copies of data from one database to another. See also bulk copy transfer and destination-template transfer.

A form of stored procedure that automatically executes when a user issues a change statement to a specified table.

See Transact-SQL.

One or more database operations grouped under a commit or rollback. A unit of work ends when an application commits or rolls back a series of requests, or when the application terminates. See also commit, rollback, and transaction.

An alternative representation of data from one or more tables. A view can include all or some of the columns contained in the table or tables on which it is defined.

A special character that represents a range of characters in a search pattern.