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.
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 RPC, service library.
Hardware and software that characterize the LU 6.2 architecture and its various implementations in products. See also LU 6.2.
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.
Adaptive Server Enterprise / Component Integration Services (formerly OmniConnect). A variation of Sybase SQL Server that provides a Transact-SQL interface to various sources of external data, including host data files and tables in other database systems. The name replaces the names “OmniSQL Gateway” and “OmniSQL Server.”
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 procedure that provides information about tables, columns, and authorizations. It is used in SQL generation and application development.
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 Sybase API that allows a client application to interact with Open Server applications.
An architecture in which the client is an application that handles the user interface and local data manipulation functions, while the server provides data access and management for multiple clients. See also client application.
A user-written CICS program, initiated on the host, that uses the Client Services for CICS API to invoke MainframeConnect for DB2 as a client to DirectConnect or to Adaptive Server. Compare with Remote Stored Procedures (RSPs).
An index in which the physical order and the logical (indexed) order is the same. The leaf level of a clustered index represents the data pages themselves. Compare with non-clustered index.
A number that uniquely identifies a specific set of encoding scheme identifier, character set identifier(s), code page identifier(s), and additional coding-related required information.
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.
Information required to make an Open ClientConnect or Open ServerConnect connection. The connection specification consists of the server name, platform, Net-Library driver name, and address information required by the Net-Library driver being used.
In programming languages, the transformation between values that represent the same data item but belong to different datatypes. Information can be lost due to conversion because accuracy of data representation varies among different data types. See character set conversion.
An IBM-licensed program that enables transactions entered at remote terminals to be processed concurrently by user-written application programs. It includes facilities for building, using, and maintaining databases.
A computer-based system for defining, creating, manipulating, controlling, managing, and using databases. The software for using a database can be part of the database management system, or it can be a stand-alone database system. Compare with relational database management system (RDBMS).
A language for describing data and their relationships in a database.
A keyword that identifies the characteristics of stored information on a computer. Some common datatypes are char (character), int (integer), smallint (small integer), date, time, numeric, and float. Different databases support different datatypes.
A Sybase and Microsoft API that allows client applications to interact with ODS applications. See also application program interface (API).
The named set of properties, used with an DB2 access service library, to which clients connect. Each DirectConnect server can have multiple services.
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 DB2 access service library interacts with exactly one target and is named accordingly. See also service library.
IBM SAA (Systems Application Architecture) embedded SQL. The ANSI SQL-1-compliant SQL syntax used by DB2 UDB.
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 and dynamic SQL. Compare with bulk copy transfer.
A Sybase Open Server application that provides access management for non-Sybase database copy management (transfer) and remote systems management. Each DirectConnect consists of a server and one or more service libraries and provides access to a specific data source. DirectConnect replaces the “MDI Database Gateway” and “OmniSQL Access Module” names and products. Compare with Enterprise Connect.
A Sybase Windows application that provides remote management capabilities for DirectConnect products. These capabilities include starting, stopping, creating, and copying services.
A Sybase LAN-based solution that communicates with mainframe host components. It incorporates the functionality of the MDI Database Gateway and the Sybase Net-Library and includes LU 6.2 and TCP/IP support.
A Sybase LAN-based solution that communicates with DB2 UDB mainframe host components. It incorporates the functionality of the MDI Database Gateway and the Sybase Net-Library, and includes LU 6.2 and TCP/IP support.
The component that provides general management and support functions (such as log file management) to service libraries.
The named set of properties, used with a DirectConnect DB2 Access Service Library, to which clients connect.
The component that provides a set of functions within the DirectConnect server environment.
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.
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 being coded directly into the application program. The SQL statement can change several times while the program runs. Compare with static SQL. Compare with destination-template transfer.
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.
The encompassing architecture upon which Sybase implements heterogeneous data integration. Compare with DirectConnect.
A type of computer interface consisting of a visual metaphor of a real-world scene, often of a desktop. Within that scene are icons, representing actual objects, that the user can access and manipulate with a pointing device.
The Sybase DirectConnect server installation program. An interactive program that is used to install DirectConnect products and programs that support them.
An operating system file that determines how the host client software connects to a Sybase product. The file must be available on each machine that connects to DirectConnect or other Sybase products.
A word or phrase that is reserved for exclusive use by Transact-SQL. Also known as a reserved word.
A type of network-accessible unit that enables end users to gain access to network resources and communicate with each other. See also end user.
A type of logical unit that supports general communication between programs in a distributed processing environment. See also APPC.
Sybase products that enable desktop computer users to communicate with mainframes in a client/server environment.
A Sybase mainframe solution that provides dynamic access to DB2 data. It replaces the OmniSQL Access Module for DB2 and the functionality of the MDI Access Server.
An MDI legacy product that gives client applications access to supported data sources, such as DB2.
An IBM operating system that runs on most System/370 and System/390 mainframes. It supports 24-bit addressing up to 16 megabytes.
A Sybase product that lets PC applications become clients of SQL Server or Open Server. See also client, Open Server, SQL Server.
An index that stores key values and pointers to data. The leaf level points to data pages rather than containing the data itself. Compare with clustered index.
Functionality incorporated into CIS of Adaptive Server is referred to as ASE/CIS. 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 Microsoft API that allows access to both relational and non-relational databases. ODBC allows client application developers to produce vendor-neutral Windows applications that can access data sources without including code for a specific database. See also application program interface (API).
A Sybase and Microsoft 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.
The LU on the remote machine in a conversation. See also LU and conversation.
Scale is the number of digits to the right of the decimal; precision is the total number of digits. Precision minus scale is the number of digits to the left of the decimal. For example, using the number 123.45, scale is 2, precision is 5, and precision minus scale is 3.
In transfer processing, the database accessed by the DB2 access service. For example, for DirectConnect for z/OS, the primary database is DB2. Compare with secondary database.
A setting for a server or service that defines the characteristics of the service, such as how events are logged or how datatypes are converted. Compare with parameter and value.
The part of the Windows NT operating system that holds configuration information for a particular machine.
Operators supported in search conditions. Examples are: =, <>, <, >, <=, >=, and LIKE.
A stored procedure executed on a different server from the one onto which a user is logged.
A customer-written CICS program that resides on the mainframe and communicates with MainframeConnect for DB2 UDB. See also CICS, stored procedures.
A feature that allows a Systems Administrator to manage multiple DirectConnect servers and multiple services from a client. See DirectConnect Manager.
One or more database operations the application sends as one unit to the database. During a request, the application gives up control to the DBMS and waits for its response. Depending on the response, the application commits or rolls back the request. One or more requests can be grouped into a single unit of work. See also commit, rollback, unit of work.
An instruction to a database to not implement the changes requested in a unit of work and to return to the pre-transaction state. Compare with commit. See also transaction and unit of work.
The maximum number of digits that can be stored to the right of the decimal point by a numeric or decimal datatype. The scale must be less than or equal to the precision.
The connection specified in the transfer statement. It represents anything that can be accessed using Open Client Connect, such as Adaptive Server or another DB2 access service.
When performing transfers, one of the following: the Adaptive Server, another DirectConnect service, an MDI Database Gateway, or another 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. Compare with client. See also client/server.
A positive integer that uniquely identifies a client connection to the server. In Open Server, SPID is a thread ID. Each connection has its own thread. A client can have multiple connections to the server, each with its own SPID.
A functionality available to DirectConnect applications. It is essentially the pairing of a service library and a set of specific configuration properties.
For DirectConnect, a set of configuration properties that determine service functionality. Examples of service libraries include DB2 access service libraries, transfer service libraries, administrative service libraries, and transaction router service libraries. See also DB2 Access Service Library, Administrative Service Library, Transaction Router Service Library.
A file for service name resolution that allows a Systems Administrator to create an alternative mechanism to map connections with services. See also service name resolution. Compare with direct resolution.
A type of service name resolution that allows a Systems Administrator to create an alternative mechanism to map connections with services. See also service name resolution. Compare with direct resolution.
The mapping by the DirectConnect server of an incoming service name to an actual service. See also direct resolution, service name redirection.
An IBM industry-standard language for processing data in a relational database.
A set of variables that are used in the processing of certain SQL statements. The SQLDA is intended for dynamic SQL programs.
The interfaces file containing definitions for each DirectConnect server to which a workstation can connect. The file must be on every client machine that connects to SQL Servers.
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.
SQL statements that are embedded within a program and are prepared during the program preparation process before the program runs. After being prepared, the statement itself does not change, although values of host variables specified by the statement can change. Compare with call level interface and dynamic SQL.
A collection of SQL statements and optional control-of-flow statements stored under a particular name. Sybase Adaptive Server stored procedures are called “system procedures.” See also remote stored procedure, system procedures, host-resident requests and catalog stored procedures.
An IBM industry-standard language for processing data in a relational database.
A secondary or subordinate system, usually capable of operating independently of, or asynchronously with, a controlling system.
The user in charge of server system administration. For DirectConnect, the user responsible for installing and maintaining servers and service libraries.
An array of data or a named data object that contains a specific number of unordered rows. Each item in a row can be unambiguously identified by means of one or more arguments.
An application-level protocol that Sybase clients and servers use to communicate. It describes commands and results.
A system, program, or device that interprets, rejects or satisfies, and replies to requests received from a source.
The database to which DirectConnect transfers data or performs operations on specific data.
The process of recording the sequence in which the statements in a program execute and, optionally, the values of the program variables that the statements contain.
The DirectConnect program that accepts requests from workstation-based clients and routes them to Open ServerConnect.
A service library that facilitates access to remote transactions, allowing customers to execute thousands of transactions from virtually any mainframe data source. See also service library.
A Sybase-enhanced version of the SQL database language used to communicate with SQL Server. Enhancements include data integrity features and stored procedures.
A DirectConnect feature used to move data or copies of data from one database to another. See also bulk copy transfer, destination-template transfer.
One or more database operations grouped under one 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.
| Copyright © 2005. Sybase Inc. All rights reserved. | ||
