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.
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.
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).
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). 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.
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.
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-Library.
A library of routines that is part of Open ClientConnect™. 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.
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.
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 computer-based system for defining, creating, manipulating, controlling, managing, and using databases.
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.
A Sybase solution that gives client applications ODBC data access. It combines the functionality of the DirectConnect 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 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.
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.
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.
The data access product that provides access to DB2 UDB databases. Also known as DirectConnect for DB2 UDB.
The data access product that provides access to Informix data sources. Also known as DirectConnect for Informix.
The data access product that provides access to Microsoft SQL Server data sources. Also known as DirectConnect for Microsoft SQL Server.
The data access product that provides access to non-Sybase data sources. Also known as DirectConnect for ODBC.
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 name of the data access options that replaces the previous DirectConnect product names.
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 ODBC 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.
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 DB2 UDB.
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.
A Sybase component of SDK 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.
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.
The part of the Windows NT operating system that holds configuration information for a particular machine.
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 pre-transaction state. See also transaction and unit of work. Compare with commit.
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 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.
The name of the product that contains Open Client/C, Open Client ESQL C, Open Client ESQL COBOL, language modules, jConnect for JDBC, JRE, and ODBC, OLE DB, and ADO.NET (for Windows).
A single SQL statement that is statically bound to the database. See also stored procedures.
The interfaces file containing definitions for each DirectConnect server to which a workstation can connect. See also interfaces file.
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.
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 stored 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.
The database to which DirectConnect transfers data or performs operations on specific data.
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.
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.
