Systems, methods and computer program products for automating retrieval of data from a DB2 database

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....

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Marr, Gary William, Nowak, Jane Barbara, Horbulewicz, Piotr, Volozhanin, Leonid Anatolyevich
Format: Patent
Sprache:eng
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung: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.