The named set of properties, used with an 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.
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 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 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 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.
The passing of client login information to the mainframe by TRS when it allocates a conversation.
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 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.
Connectivity software that allows two or more computer systems with different network architectures to communicate.
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.
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 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 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.
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 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 DirectConnect 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.
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 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.
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 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 ASE.
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.
The person in charge of server system administration, including installing and maintaining DirectConnect 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.
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 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.
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.