US 6,473,807 B1Granted

System for invocation of CICS programs as database stored procedures

AssigneeMerrill Lynch & Co., Inc.

InventorsTheodore S. Hills, Gregory M. Saxton

Life of this patent

Estimating the term…

Loading patent…

Abstract

Novel techniques for operating a transactional processing system on which a CICS progran is stored. The CICS program includes logic for implementing business rules, and logic for accessing data. An ODBC invocation proven, stored on a client data processing system, is adapted to invoke stored procedures. The invocation program, executed by a remote computer, causes execution of the stored CICS program at the transactional processing system. The invocation program causes the CICS program to access data from a computer-readable data storage medium, and to filter the data by implementing business rules. The transactional processing system is equipped with business rules. The trnnsactional processing system is equipped with stored procedures (queries), executed in response to a query command stored in the invocation program and issued by the client data processing system. Thus, the result of the query include accessed data to which business rules have been applied. The results can be processed by stored client programs.

Claims27

Dependent claims

A method for utilizing a CICS program stored on a transactional data processing system, the CICS program containing (i) logic for implementing one or more business rules, and (ii) logic for accessing data, the method including the steps of

(a) storing an invocation program on a client data processing system, wherein the invocation program is adapted to invoke one or more stored procedures through ODBC (open database connectivity);
(b) executing the invocation program so as to invoke an execution of the stored CICS program by the transactional data processing system, wherein the invocation program causes the CICS program to:
(i) access data, and (ii) to filter the accessed data by implementing one or more business rules;
(c) receiving a transactional request from the client data processing system;
(d) translating the request for use at the transactional data processing system by using one or more application program interfaces (APIs);
(e) executing the translated request to generate request results;
(f) executing one or more application program interfaces (APIs) to translate the request result for subsequent use at the client data processing system;
and
(g) transferring the translated request results to the client data processing system;
wherein steps (d) and (f) are performed using a dynamically-linked library (DLL) to manage communication between the transactional data processing system and the client data processing system, and wherein the DLL is provided in the form of a specifically configured driver for managing communication between the transactional data processing system and the client data processing system.

7 more elements

(a) storing an invocation program on a client data processing system, wherein the invocation program is adapted to invoke one or more stored procedures through ODBC (open database connectivity);
(b) executing the invocation program so as to invoke an execution of the stored CICS program by the transactional data processing system, wherein the invocation program causes the CICS program to:
(i) access data, and (ii) to filter the accessed data by implementing one or more business rules;
(c) receiving a transactional request from the client data processing system;
(d) translating the request for use at the transactional data processing system by using one or more application program interfaces (APIs);
(e) executing the translated request to generate request results;
(f) executing one or more application program interfaces (APIs) to translate the request results for subsequent use at the client data processing system;
and
(g) transferring the translated request results to the client data processing system;
wherein steps (d) and (f) are performed using a dynamically-linked library (DLL) and SQL (structured query language) to manage communication between the transactional data processing system and the client data processing system and wherein the DLL is provided in the form of a specifically configured driver for managing communication between the transactional data processing system and the client data processing system.

7 more elements

A client data processing system for utilizing a CICS program stored on a transactional data processing system, the client data processing system including:

(a) a computer-readable data storage medium on which is stored an invocation program adapted to invoke a stored CICS program through ODBC (open database connectivity);
(b) a processing mechanism for executing the invocation program so as to invoke the stored CICS program at the transactional data processing system such that the CICS program:
(i) accesses data, and (ii) filters the accessed data by implementing one or more business rules;
and
(c) a communications link establishment mechanism for establishing a communications link between the client data processing system and the transactional data processing system;
wherein the processing mechanism is adapted to receive a transactional request, and to translate the request for use at the transactional data processing system by using one or more application program interfaces (APIs);
wherein the communications link establishment mechanism is adapted to transfer the request to the transactional data processing system;
the client data processing system further including a receiver for receiving a request result from the transactional data processing system, wherein the processing mechanism is adapted to execute one or more transactional data processing system application program interfaces (APIs) to translate the received request result for subsequent use at the client data processing system, and wherein the one or more APIs are implemented using SQL (structured query language) commands;
the client data processing system further including a receiving mechanism for receiving a transactional request;
wherein the processing mechanism further includes a translation mechanism for translating the request for subsequent use at the transactional data processing system, the translation mechanism using one or more transactional data processing system application program interfaces (APIs);
the client data processing system further including a data transmission mechanism for transferring the request to the transactional data processing system, and wherein the receiving mechanism is further adapted to receive a request result from the transactional data processing system;
wherein the computer-readable data storage medium is equipped with a dynamically-linked library (DLL) for use by the processing mechanism to manage communication between the transactional data processing system and the client data processing system and wherein the DLL is provided in the form of a specifically configured driver for managing communication between the transactional data processing system and the client data processing system.

9 more elements

A transactional data processing system comprising:

(a) a computer-readable data storage medium on which is stored a CICS program;
(b) a communications link establishment mechanism for establishing a communications link to a client data processing system, the client data processing system including a client data processing mechanism for executing an invocation program adapted to invoke a CICS program through ODBC (open database connectivity);
and
(c) a transactional data processing mechanism, responsive to the invocation program, for invoking the stored CICS program such that the CICS program:
(i) accesses data, and (ii) filters the accessed data by implementing one or more business rules;
wherein the client data processing mechanism is adapted to receive a transactional request, and to translate the request for use at the transactional data processing system by using one or more application program interfaces (APIs) and one or more SQL (structured query language) commands;
wherein the communications link establishment mechanism is adapted to accept transactional requests from the client data processing system, and wherein the communications link establishment mechanism includes:
(i) a data receiver for receiving requests from the client data processing system, and (ii) a data transmitter for transmitting request results to the client data processing system;
wherein the transactional data processing mechanism further includes a translation mechanism for translating requests received from the client data processing system for subsequent use at the transactional data processing system, the translation mechanism using one or more transactional data processing system application program interfaces (APIs);
wherein the client data processing system further includes (i) a data transmission mechanism for transferring requests to the transactional data processing system, and (ii) a data receiving mechanism adapted to receive request results from the transactional data processing system;
wherein the computer-readable data storage medium is equipped with a dynamically-linked library (DLL) for use by the transactional data processing mechanism to manage communication between the transactional data processing system and the client data processing system, and wherein the DLL is provided in the form of a specifically configured driver for managing communication between the transactional data processing system and the client data processing system.

8 more elements

Dependencies are inferred from the claim text.