System, method, and article of manufacture for propagating transaction processing facility based data and for providing the propagated data to a variety of clients

A data propagation method, comprising the steps of:

• propagating data from a data storage of a section processing facility (TPF) based computer to a server computer;
• generating via the server computer a structured query language (SQL) statement reflecting the propagated data;
• and
• updating a relational database associated with the server computer using the SQL statement, where the relational database is separate from the data storage of the TPF based computer and comprises data that has been propagated from the TPF based computer's data storage and converted into a structure that is different from the structure of the data as stored in the TPF based computer's data storage, where the data stored in the relational database can be accessed using SQL statements.

A data processing system comprising:

• a transaction processing facility (TPF) based computer comprising data storage that includes TPF data;
• a server computer including a relational database, coupled to the TPF based computer, the relational database being separate from the data storage of said TPF based computer and including a structured replica of the TPF data;
• and
• a client terminal for sending a miscellaneous function management request to the TPF based computer,
• wherein the TPF based computer sends the miscellaneous function management request to the server computer, which generates a structured query language (SQL) statement reflecting the miscellaneous function management request, and sends the generated SQL statement to the relational database, where the SQL statement is used to update the relational database.

A miscellaneous function management method, comprising the steps of:

• sending a miscellaneous function management request by a client terminal to a transaction processing facility (TPF) based computer, where the TPF based computer comprises data storage that includes TPF data;
• sending the miscellaneous function management request by the TPF based computer to a server computer, which includes a relational database separate from the data storage of the TPF based computer that has a structured replica of data stored in the data storage of the TPF based computer;
• and
• generating a structured query language (SQL) statement reflecting the miscellaneous function management request and sending the generated SQL statement by the server computer to the relational database;
• updating the relational database based on the SQL statement.

A computer readable medium containing instructions for causing a computer to perform a method for propagating data, comprising the steps of:

• propagating data from a data storage of a transaction processing facility (TPF) based computer to a server computer;
• generating via the server computer a structured query language (SQL) statement reflecting the propagated data;
• and
• updating a relational database associated with the server computer using the SQL statement where the relational database is separate from the data storage of the TPF based computer and comprises data that has been propagated from the TPF based computer's data storage and converted into a structure that is different from the structure of the data as stored in the TPF based computer's data storage, where the data stored in the relational database can be accessed using SQL statements.

A computer readable medium containing instructions for causing a computer to perform a method for miscellaneous function management, comprising the steps of:

• sending a miscellaneous function management request by a client terminal to a transaction processing facility (TPF) based computer, where the TPF based computer comprises data storage that includes TPF data;
• sending the miscellaneous function management request by the TPF based computer to a server computer, which includes a relational database separate from he data storage of the TPF based computer that has a structured replica of data stored in the data storage of the TPF based computer;
• and
• generating a structured query language (SQL) statement reflecting the miscellaneous function management request and sending the generated SQL statement by the server computer to the relational database;
• updating the relational database based on the SQL statement.