A number or binary code assigned to programs, documents, or folders that allows authorized users to access them.
A logical server application, used with an access service library, to which clients connect. Each DirectConnect for z/OS Option server can have multiple access services.
A component of the DirectConnect for z/OS Option, 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 and access service.
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. Formerly known as SQL Server.
Hardware and software that characterize the LU 6.2 architecture and its various implementations in products. See also logical unit 6.2 (LU 6.2).
See ASCII (American Standard Code for Information Interchange).
Hardware and software configured to enable a remote transaction program to establish an APPC conversation with a partner transaction program in an SNA network. See also Systems Network Architecture (SNA).
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.
A 7-bit standard code that permits transmittal of text, numbers, and some special characters among systems. Characters are represented by the numbers between 32 and 127, inclusive. The set includes uppercase and lowercase letters, numbers, and frequently-used special characters (such as $ & ; : # . ,).
SQL statements from a compiled mainframe program where the access to DB2 UDB was optimized and saved as static SQL in an application plan.
A block of memory used to establish a connection between nodes in an SNA network architecture.
SNA is no longer supported for the Client Option.
The action of bringing a computer program, a routine, or a subroutine into effect, usually by specifying the entry conditions and jumping to an entry point.
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. Contrast with server.
Software that is responsible for the user interface, including menus, data entry windows, and report formats or an application that sends requests to another application that acts as a server. See also client, client/server, server.
A Sybase product that provides capability for the mainframe to act as a client to LAN-based resources. See client.
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 application.
A customer-written CICS program initiated on the host that uses the Sybase API to invoke The Server Option for DB2 UDB as a client to The Server Option or to SQL Server. See also application program interface (API).
A high-level programming language, based on English, that is used primarily for business applications.
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. Contrast with rollback.
A control section used to reserve a main storage area that can be referred to by other modules.
The SAA Common Programming Interface (CPI) 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.
To translate all or part of a program that is expressed in a high-level language into a computer program that is expressed in an intermediate language, an assembler language, or a machine language.
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 may be a conditional statement, or an imperative statement.
a) A dialog between a user and an interactive data processing system.
b) Within the context of APPC, an exchange of information or a sequence of messages sent between two transaction programs. Conversations take place between two LUs over an established session. Also, a sequence of messages sent between two applications (for instance, client application and SQL Server).
In SQL, a named control structure used by an application program to point to a row of data. The position of the row is within a table or view, and the cursor is used interactively to select rows from the columns.
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 set of related data tables and other database objects that are organized and presented to serve a specific purpose.
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.
A job control statement describing a data set associated with a specific job step. See also job control language (JCL).
In a program, an element of data structure, such as a file, array, or operand, that is needed for the execution of a program and that is named or otherwise specified by the allowable character set of the language in which the program is coded.
An object that communicates and stores data used by several programs in a job or between jobs.
A collection of items of information from the standpoint of its use in an application, as the user supplies it. The data record is stored physically separate from its associated control information in a control interval.
The major unit of data storage and retrieval, consisting of a collection of data in one of several prescribed arrangements and described by control information to which the system has access.
A Sybase and Microsoft API that allows client applications to interact with ODS applications. See also application program interface (API).
A Sybase mainframe solution that provides dynamic access to DB2 UDB data. It replaces the OmniSQL Access Module for DB2 UDB-CICS and the functionality in the MDI Access Server. See also Customer Information Control System (CICS), DB2 UDB , Multiple Virtual Storage (OS/390).
A device in which access time is effectively independent of the location of the data.
A Sybase Open Server application that provides access management for non-Sybase databases, copy management (transfer), and remote systems management. Each DirectConnect for z/OS Option consists of a server and one or more service libraries to provide access to a specific data source. The DirectConnect for z/OS Option replaces the products “MDI Database Gateway” and “Net-Gateway.”
A Sybase Windows application that provides remote management capabilities for DirectConnect for z/OS Option products. These capabilities include starting, stopping, creating, and copying services.
A type of file containing the names and controlling information for other files or other directories.
A set of characters in which each character is represented by 2 bytes. Languages such as Japanese, Chinese, and Korean, which contain more symbols than can be represented by 256 code points, require double-byte character sets. Because each character requires 2 bytes, the typing, display, and printing of DBCS characters requires hardware and programs that support DBCS. Contrast with single-byte character set (SBCS).
To record, at a particular moment, the contents of all or part of one storage device in another storage device. Dumping is usually for the purpose of debugging.
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. Contrast with static SQL.
A coded character set of 256 8-bit characters.
SQL statements that are embedded within a program and are prepared in the program preparation 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.
In interactive communications, to load and start a subsystem, or to design a product in such a way as to facilitate the inclusion of national language functions.
A variable that describes how an operating system runs and the devices it recognizes.
A data set or file in a product or system where error information is stored for later access.
See embedded SQL (ESQL).
In programming languages, a language construct for computing a value from one or more operands; for example, literals, identifiers, array references, and function calls.
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.
In programming languages, a language construct that specifies the representation, in character form, of data objects in a file.
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. Contrast with router.
The combination of internationalization and localization. See also 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 combination of alphanumeric characters that corresponds to a specific group name. The group ID can often be substituted in commands that take a group name as a value.
A routine that controls a program’s reaction to specific external events; for example, an interrupt handler.
A system of numbers to the base 16; hexadecimal digits range from 0 through 9 and A through F, where A represents 10 and F represents 16.
A database/data communication (DB/DC) system that can manage complex databases and networks.
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 may be localized for a specific culture. See also globalization. Contrast with localization.
In OS/390, a control language used to identify a job to an operating system and to describe the job’s requirements.
A graphic character set consisting of symbols used in Japanese idiographic alphabets. Each character is represented by 2 bytes.
In programming languages, a lexical unit that, in certain contexts, characterizes some language construct; a keyword normally has the form of an identifier.
a) A named area on disk that can contain programs and related information (not files). A library consists of different sections, called library members.
b) A partitioned data set containing file members for the mainframe.
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 for creating load modules from one or more object modules or creating load modules by resolving cross references among the modules and, if necessary, adjusting addresses.
To create a loadable computer program by means of a linkage editor. See also linkage editor.
All or part of a computer program in a form suitable for loading into main storage for execution. A load module is usually the output of a linkage editor.
A computer network located on the user’s premises and covering a limited geographical area. Communication within a local area network is not subject to external regulations; however, communication across the LAN boundary can be subject to some form of regulation.
The process of preparing an extracted module for a target environment. The following items are addressed: 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. Contrast with internationalization.
A variable that is defined and used only in one specified portion of a computer program. Contrast with global variable.
The log file maintained by the The Server Option server. The server log file contains entries of events for each service managed by the The Server Option Server.
A type of network-accessible unit that enables end users to gain access to network resources and communicate with each other.
A type of logical unit that supports general communication between programs in a distributed processing environment. See also advanced program-to-program communication (APPC).
An instruction in a source language that is to be replaced by a defined sequence of instructions in the same source language and that can also specify values for parameters in the replaced instructions.
A large computer, in particular one to which other computers can be connected so that they can share facilities the mainframe provides; for example, a System/370 computing system to which personal computers are attached so that they can upload and download programs and data.
Sybase products that enable client applications to communicate with mainframes in a client/server environment. See client/server.
Program-addressable storage from which instructions and other data can be loaded directly into registers for subsequent execution or processing.
A program unit that is discrete and identifiable with respect to compiling, combining with other units, and loading; for example, the input to or output from an assembler, compiler, linkage editor, or executive routine.
An IBM operating system that runs on most mainframes. It supports 24-bit addressing up to 16 megabytes.
An end-of-life Sybase product that provided communication between a mainframe and a LAN server. Net-Gateway was the “ancestor” of the DirectConnect for z/OS Option Transaction Router Service.
To incorporate one or more structures of one kind into a structure of the same kind; for example, to nest one loop (the nested or inner loop) within another loop (the nesting or outer loop); to nest one subroutine within another subroutine.
An IBM licensed program that provides communication controller support for single domain, multiple-domain, and interConnected network capability.
A passive entity that contains or receives information but cannot change the information it contains. In The Server Option, objects include rows, tables, databases, stored procedures, triggers, defaults, and views.
Output from a compiler or assembler that is also executable machine code or is suitable for processing to produce executable machine code. Contrast with source code.
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 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 product that provides the tools and interfaces required to create a custom server. For example, clients can route requests to the DirectConnect for z/OS Option, which is an Open Server application that they configured to meet specific needs, such as the preprocessing of SQL statements or decision making about routing RPCs to Transaction Router Service for DB2 UDB or to other servers. See the Open Server documentation for information about this product.
An application programming language. Open Client Client-Library and Open Server Gateway-Library are both available for PL/1.
To write into an area of storage, thereby destroying the data previously stored in the same area.
A variable that is given a constant value for a specified application and that can denote the application. Contrast with property.
In systems with time sharing, to analyze the operands entered with a command and create a parameter list for the command processor from the information.
To direct data so that the output from one process becomes the input to another process. The standard output of one command can be connected to the standard input of another with the pipe operator (|). Two commands connected in this way constitute a pipeline.
To process programs containing SQL statements before they are compiled. SQL statements are replaced with statements that will be recognized by the host language compiler. The output from this precompile includes source code that can be submitted to the compiler and used in the bind process.
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 or how datatypes are converted. Contrast with parameter.
A set of instructions that is logically structured but does not follow the syntax of any particular programming language.
A database in which data is viewed as being stored in tables consisting of columns (data items) and rows (units of information). Data from different tables can be combined to form new data relationships.
An application that controls relational databases. See also relational database. Contrast with database management system (DBMS).
A stored procedure executed on a different The Server Option server from the one onto which a user is logged.
A customer-written CICS program that resides on the mainframe and communicates with The Server Option for CICS. See also Customer Information Control System (CICS). Contrast with Client Services Application (CSA).
A main storage table that associates each resource identifier with an external logical unit (LU) or application program.
A value returned to a program to indicate the results of an operation requested by that program.
An instruction to a database to back out of the changes requested in a unit of work. Contrast with commit.
An attaching device that connects two LAN segments, which use similar or different architectures, at the OSI reference model network layer. Contrast with gateway.
A functional unit that provides shared services to workstations over a network. Contrast with client. See client/server.
A functionality available to DirectConnect for z/OS Option applications. It is the pairing of a service library and a set of specific configuration properties.
A set of configuration properties that determine service functionality. Examples of service libraries include access service libraries, transfer service libraries, administrative service libraries, and transaction router service libraries. See also Access Service Library (ACSLIB).
A command interpreter that acts as an interface between the user and the operating system. A shell can contain another shell nested inside it; the outer shell is the parent shell, and the inner shell is the child.
A character set in which each character is represented by a 1-byte code. Contrast with double-byte character set (DBCS).
A unique host identifier created by the concatenation of a port identifier with a TCP/IP address.
The input to a compiler or assembler, written in a source language. Contrast with object code.
An area in which a CSA exchanges information with the Client Option.
A set of variables used in the processing of certain SQL statements. The SQLDA is intended for dynamic SQL programs.
The movement of data from an off-line or low-priority device back to an online or higher-priority device, usually on demand of the system or on request of a user.
The primary source of data entered into a command. Standard input comes from the keyboard unless redirection or piping is used, in which case standard input can be from a file or the output from another command.
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. Contrast with dynamic SQL.
In programming languages, the form of data used for storing and manipulating text. For example, in PL/1, a string is a sequence of characters or bits that is treated as a single data item; and in SQL, a string is a character string.
A mechanism that permits variable-length data or non-3270 data to be encoded for transmission in the 3270 data stream.
An IBM industry-standard language for processing data in a relational database.
A program module that transfers remote procedure calls and responses between a client and a server. See client, server.
SAA is an architecture composed of a set of selected software interfaces, conventions, and protocols designed to provide a framework for developing distributed applications. The key benefits of SAA are: portability, consistency, and connectivity. The components of SAA are specifications for the key application interfaces points: common user access, common communication support, and common programming interface.
A user authorized to handle The Server Option system administration, including creating user accounts, assigning permissions, and creating new databases.
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 (APPC).
SNA is no longer supported for the Client Option.
A programmer who plans, generates, maintains, extends, and controls the use of an operating system with the aim of improving overall productivity of an installation.
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.
The proprietary Sybase protocol that defines the format of data transmitted between client and server programs in an efficient, self-describing manner.
An exchange between a program on a local system and a program on a remote system that accomplishes a particular action or result.
A DirectConnect for z/OS Option feature that allows users to move data or copies of data from one database to another.
A program or subroutine that does not reside in main storage or in a temporary storage area for such a program.
A DirectConnect for z/OS Option product used when the mainframe acts as a transaction server to route requests from remote clients to a mainframe transaction and return results to the clients. See also DirectConnect for z/OS Option.
A set of communication protocols that supports peer-to-peer connectivity functions for both local and wide area networks.
An application programming language. Open Client Client-Library and Open Server Gateway-Library are both available for COBOL.
An IBM operating system that runs on most mainframes. It supports 24-bit addressing up to 16 megabytes. See Multiple Virtual Storage (OS/390).
Copyright © 2005. Sybase Inc. All rights reserved. |