Systems, methods and computer program products for automating retrieval of data from a DB2 database
View Patent ↗Data is automatically retrieved from a DataBase 2 (DB2) database using a DB2 scripter module that is configured to automatically log on to the DB2 database, to automatically perform a query of the DB2 database, and to automatically extract from the DB2 database a dataset that results from the query. A dataset processor module is configured to convert the dataset into a text file, and to deliver the text file to a delivery site, for retrieval by the user. The DB2 scripter module can extract the dataset by printing the dataset to a DB2 virtual printer and/or by exporting the dataset to a File Transfer Protocol (FTP) site.
1. A system for automating retrieval of data from a DataBase 2-database comprising:
a memory coupled to a processor;
a DataBase 2 scripter module disposed in the memory that is configured to automatically log on to the DataBase 2 database, to automatically perform a query of the DataBase 2 database and to automatically extract from the DataBase 2 database a dataset that results from the query; and
a dataset processor module disposed in the memory that is configured to convert the dataset that is extracted from the DataBase 2 database into a text file and to deliver the text file to a delivery site for retrieval by a user,
wherein the DataBase 2 scripter module is activated upon occurrence of a predetermined event.
2. A system according to claim 1 wherein the predetermined event comprises a predetermined time.
3. A system according to claim 1 further comprising a user processor module disposed in the memory that is configured to convert the text file into a format that is viewable by the user.
4. A system according to claim 3 wherein the user processor module comprises a personal computer spreadsheet macro.
5. A system according to claim 1 wherein the dataset processor module comprises a scripter module.
6. A system according to claim 1 wherein the predetermined event comprises activation by a user.
7. A system for automating retrieval of data from a DataBase 2 database comprising:
a memory coupled to a processor;
a DataBase 2 scripter module disposed in the memory that is configured to automatically log on to the DataBase 2 database, to automatically perform a query of the DataBase 2 database and to automatically extract from the DataBase 2 database a dataset that results from the query; and
a dataset processor module disposed in the memory that is configured to convert the dataset that is extracted from the DataBase 2 database into a text file and to deliver the text file to a delivery site for retrieval by a user,
wherein the DataBase 2 scripter module is further configured to automatically log off the DataBase 2 database after automatically extracting the dataset that results from the query.
8. A system according to claim 7 further comprising a user processor module disposed in the memory that is configured to convert the text file into a format that is viewable by the user.
9. A system according to claim 8 wherein the user processor module comprises a personal computer spreadsheet macro.
10. A system according to claim 7 wherein the dataset processor module comprises a scripter module.
11. A system according to claim 7 wherein the predetermined event comprises activation by a user.
12. A computer program product that is configured to automate retrieval of data from a DataBase 2 database, the computer program product comprising a computer usable storage medium having computer-readable program code embodied in the medium, the computer-readable program code comprising:
computer-readable program code that is configured to automatically log on to the DataBase 2 database, to automatically perform a query of the DataBase 2 database and to automatically extract from the DataBase 2 database a dataset that results from the query; and
computer-readable program code that is configured to convert the dataset that is extracted from the DataBase 2 database into a text file and to deliver the text file to a delivery site for retrieval by a user,
wherein the computer-readable program code that is configured to automatically log on to the DataBase 2 database is responsive to occurrence of a predetermined event.
13. A computer program product according to claim 12 wherein the predetermined event comprises a predetermined time.
14. A computer program product according to claim 12 further comprising computer-readable program code that is configured to convert the text file into a format that is viewable by the user.
15. A computer program product according to claim 12 wherein the computer-readable program code that is configured to automatically log on to the DataBase 2 database is further configured to automatically log off the DataBase 2 database after automatically extracting the dataset that results from the query.
16. A computer program product according to claim 12 wherein the predetermined event comprises activation by a user.