Browse Prior Art Database

Dynamic order to remote data base DB2 or ORACLE asynchronize fetching data.

IP.com Disclosure Number: IPCOM000014290D
Original Publication Date: 2001-Jul-01
Included in the Prior Art Database: 2003-Jun-19
Document File: 2 page(s) / 43K

Publishing Venue

IBM

Abstract

Disclosed is a method for sending a dynamic order to remote databases to continuously and asynchronously fetch data in an environment comprising a library server, and an object server. We implemented this method to create a validation utility. Using this utility, the user will get a report of discrepancies between two databases, namely, the Library Server and Object Server. The invention creates a dynamic function to deliver the query order to the cross platform Library Server to get the data to perform the comparison with Object Server's data. The dynamic function is named LbsDynamicMessage. It has 4 parameters: the first one is communication buffer; the second one is communication handle; the third one is query code which can be 'OPEN', 'FETCH', or 'CLOSE'; and the last one is the query data. This function packs communication information, query data, and row counts into a communication buffer. Then, an existing validation utility on the object server side takes the communication handle and communication buffer as input, using a communication function, and delivers the order to the Library Server. The Library Server receives the order, and according to the query code, executes the dynamic query and and uses the communication function to send the result back to the validation utility. The following are steps for the validation utility to query the Library Server to get the data to implement its validation function:

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 53% of the total text.

Page 1 of 2

Dynamic order to remote data base DB2 or ORACLE asynchronize fetching data.

   Disclosed is a method for sending a dynamic order to remote databases to continuously and asynchronously fetch data in an environment comprising a library server, and an object server. We implemented this method to create a validation utility. Using this utility, the user will get a report of discrepancies between two databases, namely, the Library Server and Object Server.

The invention creates a dynamic function to deliver the query order to the cross platform Library Server to get the data to perform the comparison with Object Server's data.

The dynamic function is named LbsDynamicMessage. It has 4 parameters: the first one is communication buffer; the second one is communication handle; the third one is query code which can be 'OPEN', 'FETCH', or 'CLOSE'; and the last one is the query data. This function packs communication information, query data, and row counts into a communication buffer. Then, an existing validation utility on the object server side takes the communication handle and communication buffer as input, using a communication function, and delivers the order to the Library Server. The Library Server receives the order, and according to the query code, executes the dynamic query and and uses the communication function to send the result back to the validation utility.

The following are steps for the validation utility to query the Library Server to get the data to implement its validation function:

1. The application needs to prepare the SQL statement as query data.

query: 'select ItemID, RepType, PartNum, VersionNum, PartLen, a.Created, a.Changed,
c.SMSCollName, PartFlag...