The named set of properties, used with a DirectConnect 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 Access Service Library interacts with exactly one target and is named accordingly. See also service library.
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, service library.
The IBM implementation of the UNIX operating system. The RISC System/6000, among other workstations, runs the AIX operating system. See also UNIX.
Hardware and software that characterize the LU 6.2 architecture and its implementations in products. See also logical unit 6.2.
The component of MainframeConnect for DB2 UDB that allows clients to submit SQL statements to DB2 UDB. It is a CICS transaction that receives SQL statements sent from DirectConnect and submits them to DB2 UDB, using the DB2 UDB dynamic SQL facility. It also receives the results and messages from DB2 UDB and returns them to DirectConnect.
The programming language interface between the user and Open ClientConnect or Open ServerConnect. The API for Open ClientConnect is Client-Library. The API for Open ServerConnect is Gateway-Library.
In the Sybase environment, this term has different meanings depending on the context:
In CICS, it is an SNA command used to establish a connection between LUs, or a TCP/IP call that connects an application to a port on its system.
In DB2 UDB, it compiles the Database Request Module, the precompiler product that contains SQL statements in the incoming request, and produces an access plan, a machine code version of the SQL statements that specifies the optimal access strategy for each statement.
In the mainframe access product set, it establishes a connection between a TRS port and a CICS or IMS region.
A system table that contains information about objects in a database, such as tables, views, columns, and authorizations.
A component of the DB2 UDB Access Module that allows clients to access DB2 UDB system catalogs. It uses an interface compatible with the catalog interface for the ODBC API.
A procedure, used in SQL generation and application development, that provides information about tables, columns, and authorizations.
A set of specific (usually standardized) characters with an encoding scheme that uniquely defines each character. ASCII is a common character set.
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 responsible for the user interface that sends requests to applications acting as servers. See also client/server.
A library of routines that is part of Open ClientConnect. The Open ClientConnect Client-Library comprises a subset of the Open Client Client-Library routines.
An architecture in which the client is an application that handles the user interface and local data manipulation functions, and the server is an application providing data processing access and management. See also client application.
A customer-written CICS program initiated on the host that uses the Sybase API to invoke MainframeConnect for DB2 UDB as a client to DirectConnect or to SQL Server. See also application program interface, Client Services for CICS.
A Sybase host API that invokes Open ServerConnect as a client to an access service for DB2 UDB or SQL Server. See also Application program interface, Customer Information Control System, Client Services Application, Open ServerConnect.
A process that makes permanent all changes made to one or more database files since the initiation of the application program, the start of an interactive session, or the last commit or rollback operation. Compare with rollback.
A network path between two systems. For SNA, the path connects a logical unit (LU) on one machine to an LU on a separate machine. For TCP/IP, the path connects TCP modules on separate machines.
A program provided with Open ClientConnect that directs requests to particular remote servers. Mainframe system programmers use the connection router to define remote servers and server connections to Open ClientConnect.
A memory-resident table maintained by an Open ClientConnect system programmer that lists servers and the connections that a Client-Library transaction can use to access them.
The passing of client login information to the mainframe by TRS when it allocates a conversation.
An IBM licensed program that enables transactions entered at remote terminals to be processed concurrently by user-written application programs. Open ServerConnect, MainframeConnect for DB2 UDB, and Open ClientConnect are available for CICS.
A computer-based system for defining, creating, manipulating, controlling, managing, and using databases.
A single action against the database. For DirectConnect, a database operation is usually a single SQL statement. One or more database actions can be grouped together to form a request. See also request.
A Sybase and Microsoft API that allows client applications to interact with ODS applications. See also application program interface.
A request sent directly from a client workstation through Transaction Router Service to DirectConnect without going through SQL Server. Contract with indirect request.
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 (transfer), and remote systems management. The name replaces the names MDI Database Gateway and OmniSQL Access Module. 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.
The component that provides general management and support functions to service libraries.
The 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.
A file containing executable code and data bound to a program at load time or runtime, rather than during linking.
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. Compare with static SQL.
A person who connects to DirectConnect using an application in order to access databases and perform transfers. See also transfer.
A variable that describes how an operating system runs and the devices it recognizes.
An add-on security package for the z/OS mainframe, licensed by Computer Associates.
Connectivity software that allows two or more computer systems with different network architectures to communicate.
A library of communication, conversion, tracing, and accounting functions supplied with Open ServerConnect.
The mainframe or other machine on which a database, an application, or a program resides. In TCP/IP, this is any system that is associated with at least one Internet address. See also Transmission Control Protocol/Internet Protocol.
In Open ServerConnect, the ID that the TRS passes to the mainframe with a client request. The host ID is part of the client login definition at the TRS.
In Open ServerConnect, the password that the TRS passes to the mainframe with a client request The host password is part of the client login definition at the TRS.
A DB2 UDB table that contains host-resident SQL statements that can be executed dynamically. See also host-resident request.
A SQL request that resides on MainframeConnect in the host request library. See also host request library.
A client request that is routed through a stored procedure on a SQL Server, which forwards the request to TRS as an RPC. Compare with direct request.
A database/data communication system that can manage complex databases and networks.
An operating system file that determines how the host client software connects to a Sybase product. An interfaces file entry contains the name of any DirectConnect server and a list of services provided by that server.
The name TRS uses to represent a client’s language request. TRS treats a language request as a remote procedure call (RPC) and maps it to a language transaction at the remote server.
The Sybase Integrated Product Set that provides heterogeneous data integration.
The server transaction that processes client language requests. The MainframeConnect for DB2 UDB language transaction is AMD2, which uses the DB2 UDB dynamic SQL facilities to process incoming SQL strings. The OmniSQL Access module for DB2 for IMS and z/OS uses SYRT by default.
A type of network addressable unit that enables a network user to gain access to network facilities and communicate remotely. A connection between a TRS and a CICS region is a connection between logical units.
A type of logical unit that supports general communication between programs in a distributed processing environment. See also advanced program-to-program communication.
Client information made available to Open ServerConnect. The client program sets this information in a login packet and sends it to the TRS, which forwards it to the mainframe.
A transaction that accepts more than one client request. Whereas short transactions end the communication after returning results to a client, a long-running transaction can await and process another request. Compare with short transaction.
Sybase products that enable client applications to communicate with mainframes in a client/server environment. See client/server.
A Sybase mainframe solution that provides dynamic access to DB2 UDB data. It replaces the OmniSQL Access Module for DB2 (in CICS only) and the functionality in the MDI Access Server. See also Customer Information Control System, Database 2, Multiple Virtual Storage.
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 provides communication between a mainframe and a LAN server. Net-Gateway is the predecessor of the DirectConnect TRS.
A variation of Sybase ASE Server that provides a Transact-SQL interface to various sources of external data. The name replaces the names OmniSQL Gateway and OmniSQL Server. The CIS functionality of ASE has incorporated the functionality of OmniConnect and is referred to as ASE/CIS. See ASE/CIS.
A Sybase mainframe solution that provides access to DB2 data. It is the predecessor of MainframeConnect for DB2 UDB.
A Sybase product that provides customer applications, third-party products, and other Sybase products with the interfaces required to communicate with Open Client and Open Server applications.
A Sybase product that allows mainframe clients to send requests to SQL Server, Open Server, MainframeConnect for DB2 UDB and Open ServerConnect, using Client-Library. Open ClientConnect provides capability for the mainframe to act as a client to LAN-based resources.
The Sybase capability for the mainframe to act as a client to LAN-based resources in the CICS environment.
The Sybase capability for the mainframe to act as a client to LAN-based resources in the IMS TM and native MVS environments.
A product that provides a framework for creating server applications that respond to DB-Library clients.
A Microsoft API that allows access to both relational and non relational databases. See also application program interface.
A Sybase product that provides the tools and interfaces required to create a custom server. Clients can route requests to DirectConnect through an Open Server configured to meet specific needs, such as the preprocessing of SQL statements.
A Sybase product that provides capability for programmatic access to mainframe data. It allows workstation-based clients to execute customer-written mainframe transactions remotely. See also Gateway-Library.
The Sybase capability to provide programmatic access to mainframe data in the CICS environment.
The Sybase capability to provide programmatic access to mainframe data in the IMS™ and native MVS environments.
A variable that is given a constant value for a specified application and can denote the application. Compare with property.
An IBM password management program with CICS Version 3.3 through an optional program temporary fix, and as an integral part of CICS with version 4.1 and higher.
A programming language designed for use in a wide range of commercial and scientific computer applications.
A setting for a server or service that defines the characteristics of the service, such as how events are logged. Compare with parameter.
The rules for requests and responses used to manage a network, transfer data, and synchronize the states of network components.
The part of the Windows operating system that holds configuration information for a particular machine.
A database in which data is viewed as being stored in tables consisting of columns (data items) and rows (units of information).
A call to execute a stored procedure on a remote server. For Open ServerConnect, an RPC is a direct request from a client to TRS. For Open ClientConnect, a Client-Library transaction that calls a procedure on a remote server acts like an RPC.
A customer-written CICS program that resides on the mainframe and communicates with MainframeConnect for DB2/MVS. See also Customer Information Control System, stored procedure. Compare with Client Services Application.
A feature that allows a system administrator to manage multiple DirectConnect servers and multiple services from a client.
A Sybase SQL Server application that maintains replicated data and processes data transactions received from a data source.
One or more database operations an application sends as a unit to the database. Depending upon the response, the application commits or rolls back the request. See also commit, rollback, unit of work.
An instruction to a database to back out of changes requested in a unit of work. Compare with commit.
A functional unit that provides shared services to workstations over a network. See also client/server. Compare with client.
A functionality available to DirectConnect applications. It is the pairing of a service library and a set of specific configuration properties.
In DirectConnect applications, a set of configuration properties that determine service functionality. See also access service library, administrative service library, transaction router service library, transfer service library.
A type of service name resolution that allows a system administrator to create an alternative mechanism to map connections with services. See also service name resolution. Compare with direct resolution.
The DirectConnect server mapping of an incoming service name to an actual service. See also direct resolution, service name redirection.
A connection between two programs or processes. In APPC communications, sessions allow transaction programs to have conversations between the partner LUs. See also advanced program-to-program communication.
A mainframe transaction that ends the communication when it finishes returning results to the client. Compare with long-running transaction.
The interfaces file containing definitions for each DirectConnect server to which a workstation can connect. The file must reside on every client machine that connects to SQL Servers.
The server in the Sybase Client-Server architecture. It manages multiple databases and 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 prepared during the program preparation process before the program runs. Compare with dynamic SQL.
A collection of SQL statements and optional control-of-flow statements stored under a particular name. Sybase SQL Server stored procedures are called “system procedures.” See also remote stored procedure, system procedure.
An IBM industry-standard language for processing data in a relational database.
The component of OmniSQL Access Module for DB2 that allows clients to submit SQL language requests to DB2 through IMS TM or MVS (z/OS).
A stored procedure that Sybase SQL Server supplies for use in system administration. System procedures serve as shortcuts for retrieving information from system tables, or a mechanism for accomplishing database administration. See also stored procedure.
An IBM proprietary plan for the structure, formats, protocols, and operational sequences for transmitting information units through networks. See also advanced program-to-program communication.
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.
A Sybase application-level protocol that defines the form and content of relational database requests and replies.
A system, program, or device that interprets, rejects, satisfies, or replies to requests received from a source.
A unit of processing initiated by a single request. A transaction consists of one or more application programs that, when executed, accomplish a particular action. In Open ServerConnect, a client request (RPC or language request) invokes a mainframe transaction. In Open ClientConnect, a mainframe transaction executes a stored procedure on a remote server.
A sequence of operations on a database that is viewed by the user as a single, individual operation.
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 transactions from virtually any mainframe data source. See also service library.
A DirectConnect feature that allows users to move data or copies of data from one database to another.
A service library that provides copy management functionality. See also service library.
A set of communication protocols that supports peer-to-peer connectivity functions for both local and wide area networks.
One or more database operations grouped under a commit or rollback. A unit of work ends when the application commits or rolls back a series of requests, or when the application terminates. See also commit, rollback, transaction.
User identification. The ID number by which a user is known in a specific database or system.
An entity that is assigned a value. DirectConnect has two kinds of variables: local and global.
An IBM licensed program that controls communication and the flow of data in an SNA network.
| Copyright © 2005. Sybase Inc. All rights reserved. | ||
