Establishment of a SNA or TCP/IP connection between Mainframe Connect Server Option and Mainframe Connect DirectConnect for z/OS Option.
The named set of properties, used with an access service library, to which clients connect. Each DirectConnect server can have multiple services.
A number or binary code assigned to programs, documents, or folders that allows authorized users to access them.
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.
Includes a variation of ASE that provides a Transact-SQL interface to various sources of external data. Component Integration Services allows ASE to present a uniform view of enterprise data to client applications.
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 server 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.
Hardware and software that characterize the LU 6.2 architecture and its implementations in products. See also logical unit 6.2.
The component of the Mainframe Connect DB2 UDB Option that allows clients to submit SQL statements to DB2 UDB. It is a CICS transaction that receives SQL statements sent from Mainframe Connect DirectConnect for z/OS Option 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 Mainframe Connect DirectConnect for z/OS Option.
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 7-bit coded characters (including a parity check, 8 bits).
The programming language interface between the user and Mainframe Connect Client Option or Mainframe Connect Server Option. The API for Mainframe Connect Client Option is Client-Library. The API for Mainframe Connect Server Option 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 transfer method in which multiple rows of data are inserted into a table in the target database. Compare with destination-template transfer and express transfer.
A programming style that calls database functions directly from the top level of the code. Contrast with embedded SQL.
A system table that contains information about objects in a database, such as tables, views, columns, and authorizations.
A component of the Mainframe Connect DB2 UDB Option 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.
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 API to invoke the Mainframe Connect Client Option as a client to the Server Option server or to ASE. See also application program interface, Client Services for CICS.
A Sybase host API that invokes the Mainframe Connect Server Option as a client to an access service for DB2 UDB or ASE. See also application program interface, Customer Information Control System, Client Services Application, Mainframe Connect Server Option.
An index in which the physical order and the logical (indexed) order is the same. Compare with nonclustered index.
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.
Specifies the languages and services used to develop applications across SAA environments. The elements of the CPI specification are divided into two parts: processing logic and services.
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 datatypes.
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 Mainframe Connect Client Option that directs requests to particular remote servers. Mainframe system programmers use the connection router to define remote servers and server connections to Mainframe Connect Client Option.
A memory-resident table maintained by a Mainframe Connect Client Option system programmer that lists servers and the connections that a Client-Library transaction can use to access them.
The part of a program specified by the programmer to be a relocatable unit, all elements of which are to be loaded into adjoining main storage locations.
In programming languages, a statement that is used to alter the continuous sequential execution of statements. A control statement can be a conditional statement or an imperative statement.
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.
The term or phrase to identify a data set.A computer-based system for defining, creating, manipulating, controlling, managing, and using databases.
A single action against the database. For Mainframe Connect DirectConnect for z/OS Option, 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 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 and express transfer.
A device in which access time is effectively independent of the location of the data.
A request sent directly from a client workstation through Transaction Router Service to the DirectConnect server without going through ASE. 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 Java application from Sybase that can be used in Windows and UNIX environments. It provides remote management capabilities for DirectConnect products, including starting, stopping, creating, and copying services.
The component of Mainframe Connect DirectConnect for z/OS Option that provides general management and support functions to service libraries.
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. Contrast with static SQL.
A Sybase solution that allows client applications to access ODBC data. It combines the functionality of the ECDA Option for ODBC architecture with ODBC to provide dynamic SQL access to target data, as well as the ability to support stored procedures and text and image pointers.
A Sybase solution that provides Open Client access to Oracle databases. When used in combination with ASE, it provides many of the features of a distributed database system, such as location transparency, copy transparency, and distributed joins.
SQL statements that are embedded within a program and are prepared in the process before the program runs. After it is prepared, the statement itself does not change, although values of host variables specified within the statement might change.
A person who connects to a DirectConnect server using an application to access databases and perform transfers. See also transfer.
An integrated set of software applications and connectivity tools that allow access to data within a heterogeneous database environment, such as a variety of LAN-based, non-Sybase data sources, as well as mainframe data sources.
A variable that describes how an operating system runs and the devices it recognizes.
A form of bulk copy transfer that uses ODBC bulk APIs to improve performance when transferring bulk data between data sources. Because it uses the same syntax as bulk copy transfer, no modification of applications is required.
A CICS client facility that allows a program to call a CICS application as if the calling program had been linked synchronously from a previous program instead of started from a terminal.
An add-on security package for the z/OS mainframe, licensed by Computer Associates.
An object that contains the special processing requirements for output data streams received from a host system by a remote session.
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 Mainframe Connect Server Option.
The combination of internationalization and localization. See internationalization, localization.
A variable defined in one portion of a computer program and used in at least one other portion of the computer program. Contrast with local variable.
A routine that controls a program’s reaction to specific external events, for example, an interrupt handler.
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 Mainframe Connect Server Option, 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 Mainframe Connect Server Option, the password that the client passes to the mainframe with a client request.
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 in a DB2 UDB table called 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 Server Option server and a list of services provided by that server.
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.
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 server transaction that processes client language requests. The Mainframe Connect DB2 UDB Option language transaction for CICS is AMD2, which uses the DB2 UDB dynamic SQL facilities to process incoming SQL strings. The Mainframe Connect DB2 UDB Option for IMS uses SYRT by default.
In computer security, combining data or information from one information system with data or information from another system with the intention to derive additional information; for example, the combination of computer files from two or more sources.
A computer program that creates load modules from one or more object modules or creates load modules by resolving cross references among the modules, and if necessary, adjusts those addresses.
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.
A variable that is defined and used only in one specified portion of a computer program. Contrast with global variable.
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.
In Mainframe Connect Server Option, the ID that a client user uses to log in to the system.
Client information made available to Mainframe Connect Server Option. The client program sets this information in a login packet and sends it to 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 product that, using Client-Library, allows mainframe clients to send requests to SQL Server, Open Server, the Mainframe Connect DB2 UDB Option and Mainframe Connect Server Option. Mainframe Connect Client Option provides capability for the mainframe to act as a client to LAN-based resources in the CICS or the IMS and MVS environment.
A Sybase mainframe solution that provides dynamic access to DB2 UDB data. It is available in the CICS or IMS environment. See also Customer Information Control System, Database 2, Multiple Virtual Storage.
A Sybase Open Server application that provides access management for non-Sybase databases, copy management (transfer), and remote systems management.
A Sybase product that provides capability for programmatic access to mainframe data. It allows workstation-based clients to execute customer-written mainframe transactions remotely. It is available for the CICS and the IMS and MVS environments
An IBM operating system that runs on most System/370 and System/390 mainframes. It supports 24-bit addressing up to 16 megabytes.
An index that stores key values and pointers to data. Compare with clustered index.
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 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 the Server Option server through an Open Server configured to meet specific needs, such as the preprocessing of SQL statements.
A variable that is given a constant value for a specified application and can denote the application. Compare with property.
Sybase publications that certify third-party or Sybase products to work with other Sybase products.
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.
The database management system that the DirectConnect server is always connected to. It is implied in the transfer statement.
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 Mainframe Connect Server Option, an RPC is a direct request from a client to TRS. For Mainframe Connect Client Option, a Client-Library transaction that calls a procedure on a remote server acts like an RPC.
A customer-written CICS program using an API that resides on the mainframe and communicates with Mainframe Connect DB2 UDB Option. 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.
A main storage table that associates each resource identifier with an external logical unit (LU) or application program.
An instruction to a database to back out of changes requested in a unit of work. Compare with commit.
An attaching device that connects two LAN segments, which use similar or different architectures, at the Open System Interconnection (OSI) reference model network layer. Contrast with gateway.
The connection specified in the transfer statement. It represents anything that can be accessed using Mainframe Connect Client Option, such as ASE 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 workstations over a network. See also client/server. Compare with client.
A functionality available in Mainframe Connect DirectConnect for z/OS Option. It is the pairing of a service library and a set of specific configuration properties.
In Mainframe Connect DirectConnect for z/OS Option, 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 default name of the file used for the service name redirection feature. See service name redirection.
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 Server Option server to which a workstation can connect. The file must reside on every client machine that connects to ASE.
A single SQL statement that is statically bound to the database. See also stored procedure.
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. Adaptive Server stored procedures are called “system procedures.” See also remote stored procedure, system procedures.
An IBM industry-standard language for processing data in a relational database.
A program module that transfers remote procedure calls (RPCs) and responses between a client and a server.
The component of Mainframe Connect DB2 UDB for IMS that allows clients to submit SQL language requests to DB2 through IMS.
The person in charge of server system administration, including installing and maintaining DirectConnect servers and service libraries.
An IBM proprietary plan for the logical structure, formats, protocols, and operational sequences for transmitting information units through networks and controlling network configuration and operation. See also advanced program-to-program communication.
A stored procedure that ASE 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.
The database to which the DirectConnect server transfers data or performs operations on specific data.
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 Mainframe Connect Server Option, a client request (RPC or language request) invokes a mainframe transaction. In Mainframe Connect Client Option, 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.
A Mainframe Connect DirectConnect for z/OS Option program used when the mainframe acts as a transaction server to route requests from remote clients to the Mainframe Connect Server Option and return results to the clients.
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 Mainframe Connect DirectConnect for z/OS Option 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.
A form of stored procedure that automatically executes when a user issues a change statement to a specified table.
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. Mainframe Connect Server Option for z/OS Option has two kinds of variables: local and global.
An alternate representation of data from one or more tables. A view can include all or some of the columns contained the table or tables on which it is defined.
An IBM-licensed program that controls communication and the flow of data in an SNA network.
